/schemas/vegbien.for_ERD.sql - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 660

vegbien.sql: Enforce 1:1 relationship between aggregateoccurrence<->individualplant and taxonoccurrence<->specimen

       CONSTRAINT individualplant_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id)
           REFERENCES aggregateoccurrence (aggregateoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT individualplant_keys UNIQUE (aggregateoccurrence_id )
       CONSTRAINT individualplant_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id )
     );
     CREATE TABLE stem -- VegBank's stemlocation table.
-...
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
       CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
       CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber )
       CONSTRAINT specimen_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
       CONSTRAINT specimen_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
     );
     CREATE TABLE voucher

Also available in: Unified diff