Revision 651
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 303 | 303 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 304 | 304 |
CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ), |
| 305 | 305 |
CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ), |
| 306 |
CONSTRAINT specimen_keys_code UNIQUE (reference_id , collectioncode_dwc , authorspecimencode )
|
|
| 306 |
CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber )
|
|
| 307 | 307 |
); |
| 308 | 308 |
|
| 309 | 309 |
CREATE TABLE voucher |
Also available in: Unified diff
vegbien.sql: Updated name of UNIQUE constraint for specimen collectionnumber. Regenerated vegbien.ERD exports.