Revision 641
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.for_ERD.my.sql | ||
|---|---|---|
| 290 | 290 |
accessioncode character varying(255), |
| 291 | 291 |
taxonoccurrence_id int(11) NOT NULL, |
| 292 | 292 |
verbatimcollectorname character varying(255), |
| 293 |
authorspecimencode character varying(20),
|
|
| 293 |
collectionnumber character varying(255),
|
|
| 294 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 295 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 296 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| schemas/vegbien.for_wiki.sql | ||
|---|---|---|
| 103 | 103 |
accessioncode character varying(255), |
| 104 | 104 |
taxonoccurrence_id integer NOT NULL, |
| 105 | 105 |
verbatimcollectorname character varying(255), |
| 106 |
authorspecimencode character varying(20),
|
|
| 106 |
collectionnumber character varying(255),
|
|
| 107 | 107 |
); |
| 108 | 108 |
|
| 109 | 109 |
CREATE TABLE voucher |
| schemas/vegbien.for_ERD.sql | ||
|---|---|---|
| 290 | 290 |
accessioncode character varying(255), |
| 291 | 291 |
taxonoccurrence_id integer NOT NULL, |
| 292 | 292 |
verbatimcollectorname character varying(255), |
| 293 |
authorspecimencode character varying(20),
|
|
| 293 |
collectionnumber character varying(255),
|
|
| 294 | 294 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ), |
| 295 | 295 |
CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id) |
| 296 | 296 |
REFERENCES party (party_id) MATCH SIMPLE |
| schemas/vegbien.sql | ||
|---|---|---|
| 2273 | 2273 |
accessioncode character varying(255), |
| 2274 | 2274 |
taxonoccurrence_id integer NOT NULL, |
| 2275 | 2275 |
verbatimcollectorname character varying(255), |
| 2276 |
authorspecimencode character varying(20)
|
|
| 2276 |
collectionnumber character varying(255)
|
|
| 2277 | 2277 |
); |
| 2278 | 2278 |
|
| 2279 | 2279 |
|
| ... | ... | |
| 4400 | 4400 |
-- |
| 4401 | 4401 |
|
| 4402 | 4402 |
ALTER TABLE ONLY specimen |
| 4403 |
ADD CONSTRAINT specimen_keys_code UNIQUE (reference_id, collectioncode_dwc, authorspecimencode);
|
|
| 4403 |
ADD CONSTRAINT specimen_keys_code UNIQUE (reference_id, collectioncode_dwc, collectionnumber);
|
|
| 4404 | 4404 |
|
| 4405 | 4405 |
|
| 4406 | 4406 |
-- |
Also available in: Unified diff
vegbien.sql: Renamed authorspecimencode to collectionnumber to match its name in source data