Revision 3200
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3567 | 3567 |
|
| 3568 | 3568 |
ALTER TABLE taxonoccurrence |
| 3569 | 3569 |
ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY (taxonoccurrence_id); |
| 3570 |
ALTER TABLE taxondetermination |
|
| 3571 |
ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 3570 | 3572 |
|
| 3571 | 3573 |
|
| 3574 |
|
|
| 3572 | 3575 |
-- |
| 3573 | 3576 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3574 | 3577 |
-- |
| schemas/filter_ERD.csv | ||
|---|---|---|
| 8 | 8 |
ALTER TABLE specimenreplicate |
| 9 | 9 |
ADD CONSTRAINT specimenreplicate_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
| 10 | 10 |
", |
| 11 |
"^ALTER TABLE taxonoccurrence |
|
| 12 |
ADD CONSTRAINT taxonoccurrence_pkey PRIMARY KEY \(taxonoccurrence_id\);","\g<0> |
|
| 13 |
ALTER TABLE taxondetermination |
|
| 14 |
ADD CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 15 |
", |
|
Also available in: Unified diff
schemas/filter_ERD.csv: Add back taxondetermination->taxonoccurrence fkey because that has been replaced by a trigger in the SQL