Revision 589
Added by Aaron Marcuse-Kubitza almost 13 years ago
| 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