Revision 589
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 265 | 265 |
accessioncode character varying(255), |
| 266 | 266 |
taxonoccurrence_id int(11) NOT NULL, |
| 267 | 267 |
collectornumber_dwc character varying(255), |
| 268 |
authorspecimencode character varying(20), |
|
| 268 | 269 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 269 | 270 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
| 270 | 271 |
REFERENCES party (party_id) MATCH SIMPLE |
| ... | ... | |
| 279 | 280 |
REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE |
| 280 | 281 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 281 | 282 |
CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ), |
| 282 |
CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ) |
|
| 283 |
CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ), |
|
| 284 |
CONSTRAINT specimen_keys_code UNIQUE (reference_id , collectioncode_dwc , authorspecimencode ) |
|
| 283 | 285 |
); |
| 284 | 286 |
|
| 285 | 287 |
CREATE TABLE voucher |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 104 | 104 |
accessioncode character varying(255), |
| 105 | 105 |
taxonoccurrence_id integer NOT NULL, |
| 106 | 106 |
collectornumber_dwc character varying(255), |
| 107 |
authorspecimencode character varying(20), |
|
| 107 | 108 |
); |
| 108 | 109 |
|
| 109 | 110 |
CREATE TABLE voucher |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 265 | 265 |
accessioncode character varying(255), |
| 266 | 266 |
taxonoccurrence_id integer NOT NULL, |
| 267 | 267 |
collectornumber_dwc character varying(255), |
| 268 |
authorspecimencode character varying(20), |
|
| 268 | 269 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 269 | 270 |
CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id) |
| 270 | 271 |
REFERENCES party (party_id) MATCH SIMPLE |
| ... | ... | |
| 279 | 280 |
REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE |
| 280 | 281 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 281 | 282 |
CONSTRAINT specimen_keys_accessioncode UNIQUE (reference_id , collectioncode_dwc , sourceaccessioncode ), |
| 282 |
CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ) |
|
| 283 |
CONSTRAINT specimen_keys_catalognumber UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc ), |
|
| 284 |
CONSTRAINT specimen_keys_code UNIQUE (reference_id , collectioncode_dwc , authorspecimencode ) |
|
| 283 | 285 |
); |
| 284 | 286 |
|
| 285 | 287 |
CREATE TABLE voucher |
| schemas/vegbien.sql | ||
|---|---|---|
| 2274 | 2274 |
sourceaccessioncode character varying(100), |
| 2275 | 2275 |
accessioncode character varying(255), |
| 2276 | 2276 |
taxonoccurrence_id integer NOT NULL, |
| 2277 |
collectornumber_dwc character varying(255) |
|
| 2277 |
collectornumber_dwc character varying(255), |
|
| 2278 |
authorspecimencode character varying(20) |
|
| 2278 | 2279 |
); |
| 2279 | 2280 |
|
| 2280 | 2281 |
|
| ... | ... | |
| 4398 | 4399 |
|
| 4399 | 4400 |
|
| 4400 | 4401 |
-- |
| 4402 |
-- Name: specimen_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4403 |
-- |
|
| 4404 |
|
|
| 4405 |
ALTER TABLE ONLY specimen |
|
| 4406 |
ADD CONSTRAINT specimen_keys_code UNIQUE (reference_id, collectioncode_dwc, authorspecimencode); |
|
| 4407 |
|
|
| 4408 |
|
|
| 4409 |
-- |
|
| 4401 | 4410 |
-- Name: specimen_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4402 | 4411 |
-- |
| 4403 | 4412 |
|
Also available in: Unified diff
vegbien.sql: Added specimen.authorspecimencode