Project

General

Profile

« Previous | Next » 

Revision 672

Added by Aaron Marcuse-Kubitza about 13 years ago

vegbien.sql: Removed specimenreplicate:taxonoccurrence 1:1 requirement

View differences:

vegbien.for_ERD.sql
316 316 
      ON UPDATE CASCADE ON DELETE CASCADE,
317 317 
  CONSTRAINT specimenreplicate_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ),
318 318 
  CONSTRAINT specimenreplicate_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ),
319 
  CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber ),
320 
  CONSTRAINT specimenreplicate_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id )
319 
  CONSTRAINT specimenreplicate_keys_collectionnumber UNIQUE (reference_id , collectioncode_dwc , collectionnumber )
321 320 
);
322 321 

  		




  323
  322
  
    
CREATE TABLE voucher


  		












Also available in:  Unified diff