Revision 1150
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2888 | 2888 |
|
| 2889 | 2889 |
|
| 2890 | 2890 |
-- |
| 2891 |
-- Name: aggregateoccurrence_plantobservation_1_to_1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 2892 |
-- |
|
| 2893 |
|
|
| 2894 |
ALTER TABLE aggregateoccurrence |
|
| 2895 |
ADD CONSTRAINT aggregateoccurrence_plantobservation_1_to_1 UNIQUE (plantobservation_id); |
|
| 2896 |
|
|
| 2897 |
|
|
| 2898 |
-- |
|
| 2891 | 2899 |
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 2892 | 2900 |
-- |
| 2893 | 2901 |
|
Also available in: Unified diff
vegbien.sql: Added constraint to enforce 1:1 aggregateoccurrence:plantobservation relationship