Revision 672
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.for_ERD.my.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 |
| schemas/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 |
| schemas/vegbien.sql | ||
|---|---|---|
| 4470 | 4470 |
|
| 4471 | 4471 |
|
| 4472 | 4472 |
-- |
| 4473 |
-- Name: specimenreplicate_taxonoccurrence_id_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4474 |
-- |
|
| 4475 |
|
|
| 4476 |
ALTER TABLE ONLY specimenreplicate |
|
| 4477 |
ADD CONSTRAINT specimenreplicate_taxonoccurrence_id_1_to_1 UNIQUE (taxonoccurrence_id); |
|
| 4478 |
|
|
| 4479 |
|
|
| 4480 |
-- |
|
| 4481 | 4473 |
-- Name: stem_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4482 | 4474 |
-- |
| 4483 | 4475 |
|
Also available in: Unified diff
vegbien.sql: Removed specimenreplicate:taxonoccurrence 1:1 requirement