Project

General

Profile

« Previous | Next » 

Revision 567

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Added count field to taxonBin

View differences:

schemas/vegbien.for_ERD.my.sql
362 362 
  sizeclass_id int(11),
363 363 
  coverindex_id int(11),
364 364 
  accessioncode character varying(255),
365 
  count int(11) NOT NULL,
365 366 
  CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id ),
366 367 
  CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id)
367 368 
      REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
schemas/vegbien.for_wiki.sql
165 165 
  sizeclass_id integer,
166 166 
  coverindex_id integer,
167 167 
  accessioncode character varying(255),
168 
  count integer NOT NULL,
168 169 
);
schemas/vegbien.for_ERD.sql
362 362 
  sizeclass_id integer,
363 363 
  coverindex_id integer,
364 364 
  accessioncode character varying(255),
365 
  count integer NOT NULL,
365 366 
  CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id ),
366 367 
  CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id)
367 368 
      REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
schemas/vegbien.sql
2496 2496 
    stratum_id integer,
2497 2497 
    sizeclass_id integer,
2498 2498 
    coverindex_id integer,
2499 
    accessioncode character varying(255)
2499 
    accessioncode character varying(255),
2500 
    count integer NOT NULL
2500 2501 
);
2501 2502 

  		




  2502
  2503
  
    

  		












Also available in:  Unified diff