Revision 659
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 4050 | 4050 |
|
| 4051 | 4051 |
|
| 4052 | 4052 |
-- |
| 4053 |
-- Name: individualplant_keys_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4053 |
-- Name: individualplant_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4054 | 4054 |
-- |
| 4055 | 4055 |
|
| 4056 | 4056 |
ALTER TABLE ONLY individualplant |
| 4057 |
ADD CONSTRAINT individualplant_keys_accessioncode UNIQUE (aggregateoccurrence_id, sourceaccessioncode);
|
|
| 4057 |
ADD CONSTRAINT individualplant_keys UNIQUE (aggregateoccurrence_id);
|
|
| 4058 | 4058 |
|
| 4059 | 4059 |
|
| 4060 | 4060 |
-- |
| 4061 |
-- Name: individualplant_keys_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4062 |
-- |
|
| 4063 |
|
|
| 4064 |
ALTER TABLE ONLY individualplant |
|
| 4065 |
ADD CONSTRAINT individualplant_keys_code UNIQUE (aggregateoccurrence_id, authorplantcode); |
|
| 4066 |
|
|
| 4067 |
|
|
| 4068 |
-- |
|
| 4069 | 4061 |
-- Name: individualplant_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4070 | 4062 |
-- |
| 4071 | 4063 |
|
Also available in: Unified diff
vegbien.sql: Changed individualplant UNIQUE constraint to enforce 1:1 relationship between aggregateoccurrence and individualplant