Revision 3655
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4717 | 4717 |
|
| 4718 | 4718 |
|
| 4719 | 4719 |
-- |
| 4720 |
-- Name: specimenreplicate_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4721 |
-- |
|
| 4722 |
|
|
| 4723 |
ALTER TABLE specimenreplicate |
|
| 4724 |
ADD CONSTRAINT specimenreplicate_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4725 |
|
|
| 4726 |
|
|
| 4727 |
-- |
|
| 4720 | 4728 |
-- Name: specimenreplicate_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4721 | 4729 |
-- |
| 4722 | 4730 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5278 | 5278 |
|
| 5279 | 5279 |
|
| 5280 | 5280 |
-- |
| 5281 |
-- Name: specimenreplicate_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5282 |
-- |
|
| 5283 |
|
|
| 5284 |
ALTER TABLE ONLY specimenreplicate |
|
| 5285 |
ADD CONSTRAINT specimenreplicate_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5286 |
|
|
| 5287 |
|
|
| 5288 |
-- |
|
| 5281 | 5289 |
-- Name: specimenreplicate_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5282 | 5290 |
-- |
| 5283 | 5291 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added locationevent fkey, since fkeys are not inherited from parent tables