Revision 483
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 2224 | 2224 |
specimen_id integer NOT NULL, |
| 2225 | 2225 |
individualplant_id integer, |
| 2226 | 2226 |
reference_id integer NOT NULL, |
| 2227 |
collectioncode character varying(255) NOT NULL, |
|
| 2228 |
catalognumber character varying(255) NOT NULL |
|
| 2227 |
collectioncode_dwc character varying(255) NOT NULL,
|
|
| 2228 |
catalognumber_dwc character varying(255) NOT NULL
|
|
| 2229 | 2229 |
); |
| 2230 | 2230 |
|
| 2231 | 2231 |
|
| ... | ... | |
| 4218 | 4218 |
-- |
| 4219 | 4219 |
|
| 4220 | 4220 |
ALTER TABLE ONLY specimen |
| 4221 |
ADD CONSTRAINT specimen_keys UNIQUE (reference_id, collectioncode, catalognumber);
|
|
| 4221 |
ADD CONSTRAINT specimen_keys UNIQUE (reference_id, collectioncode_dwc, catalognumber_dwc);
|
|
| 4222 | 4222 |
|
| 4223 | 4223 |
|
| 4224 | 4224 |
-- |
Also available in: Unified diff
vegbien.sql: Added _dwc to specimen columns that are from DwC