Revision 659
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 250 | 250 |
CONSTRAINT individualplant_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id) |
| 251 | 251 |
REFERENCES aggregateoccurrence (aggregateoccurrence_id) MATCH SIMPLE |
| 252 | 252 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 253 |
CONSTRAINT individualplant_keys_accessioncode UNIQUE (aggregateoccurrence_id , sourceaccessioncode ), |
|
| 254 |
CONSTRAINT individualplant_keys_code UNIQUE (aggregateoccurrence_id , authorplantcode ) |
|
| 253 |
CONSTRAINT individualplant_keys UNIQUE (aggregateoccurrence_id ) |
|
| 255 | 254 |
); |
| 256 | 255 |
|
| 257 | 256 |
CREATE TABLE stem -- VegBank's stemlocation table. |
Also available in: Unified diff
vegbien.sql: Changed individualplant UNIQUE constraint to enforce 1:1 relationship between aggregateoccurrence and individualplant