Revision 481
Added by Aaron Marcuse-Kubitza about 13 years ago
schemas/vegbien.sql | ||
---|---|---|
2222 | 2222 |
|
2223 | 2223 |
CREATE TABLE specimen ( |
2224 | 2224 |
specimen_id integer NOT NULL, |
2225 |
individualplant_id integer NOT NULL,
|
|
2225 |
individualplant_id integer, |
|
2226 | 2226 |
reference_id integer NOT NULL, |
2227 | 2227 |
collectioncode character varying(255) NOT NULL, |
2228 | 2228 |
catalognumber character varying(255) |
Also available in: Unified diff
vegbien.sql: Made specimen.individualplant_id optional because specimens are not required to have a corresponding plot event (which all individualplants must have)