Revision 3654
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3950 | 3950 |
|
| 3951 | 3951 |
|
| 3952 | 3952 |
-- |
| 3953 |
-- Name: aggregateoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 3954 |
-- |
|
| 3955 |
|
|
| 3956 |
|
|
| 3957 |
|
|
| 3958 |
|
|
| 3959 |
-- |
|
| 3953 | 3960 |
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 3954 | 3961 |
-- |
| 3955 | 3962 |
|
| ... | ... | |
| 4227 | 4234 |
|
| 4228 | 4235 |
|
| 4229 | 4236 |
-- |
| 4237 |
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4238 |
-- |
|
| 4239 |
|
|
| 4240 |
|
|
| 4241 |
|
|
| 4242 |
|
|
| 4243 |
-- |
|
| 4230 | 4244 |
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4231 | 4245 |
-- |
| 4232 | 4246 |
|
| ... | ... | |
| 4535 | 4549 |
|
| 4536 | 4550 |
|
| 4537 | 4551 |
-- |
| 4552 |
-- Name: plantobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4553 |
-- |
|
| 4554 |
|
|
| 4555 |
|
|
| 4556 |
|
|
| 4557 |
|
|
| 4558 |
-- |
|
| 4538 | 4559 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4539 | 4560 |
-- |
| 4540 | 4561 |
|
| ... | ... | |
| 4712 | 4733 |
|
| 4713 | 4734 |
|
| 4714 | 4735 |
-- |
| 4736 |
-- Name: stemobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4737 |
-- |
|
| 4738 |
|
|
| 4739 |
|
|
| 4740 |
|
|
| 4741 |
|
|
| 4742 |
-- |
|
| 4715 | 4743 |
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4716 | 4744 |
-- |
| 4717 | 4745 |
|
| ... | ... | |
| 4782 | 4810 |
|
| 4783 | 4811 |
|
| 4784 | 4812 |
-- |
| 4813 |
-- Name: taxonoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4814 |
-- |
|
| 4815 |
|
|
| 4816 |
|
|
| 4817 |
|
|
| 4818 |
|
|
| 4819 |
-- |
|
| 4785 | 4820 |
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4786 | 4821 |
-- |
| 4787 | 4822 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4486 | 4486 |
|
| 4487 | 4487 |
|
| 4488 | 4488 |
-- |
| 4489 |
-- Name: aggregateoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4490 |
-- |
|
| 4491 |
|
|
| 4492 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 4493 |
ADD CONSTRAINT aggregateoccurrence_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4494 |
|
|
| 4495 |
|
|
| 4496 |
-- |
|
| 4489 | 4497 |
-- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4490 | 4498 |
-- |
| 4491 | 4499 |
|
| ... | ... | |
| 4774 | 4782 |
|
| 4775 | 4783 |
|
| 4776 | 4784 |
-- |
| 4785 |
-- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4786 |
-- |
|
| 4787 |
|
|
| 4788 |
ALTER TABLE ONLY locationevent |
|
| 4789 |
ADD CONSTRAINT locationevent_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4790 |
|
|
| 4791 |
|
|
| 4792 |
-- |
|
| 4777 | 4793 |
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4778 | 4794 |
-- |
| 4779 | 4795 |
|
| ... | ... | |
| 5086 | 5102 |
|
| 5087 | 5103 |
|
| 5088 | 5104 |
-- |
| 5105 |
-- Name: plantobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5106 |
-- |
|
| 5107 |
|
|
| 5108 |
ALTER TABLE ONLY plantobservation |
|
| 5109 |
ADD CONSTRAINT plantobservation_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5110 |
|
|
| 5111 |
|
|
| 5112 |
-- |
|
| 5089 | 5113 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5090 | 5114 |
-- |
| 5091 | 5115 |
|
| ... | ... | |
| 5270 | 5294 |
|
| 5271 | 5295 |
|
| 5272 | 5296 |
-- |
| 5297 |
-- Name: stemobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5298 |
-- |
|
| 5299 |
|
|
| 5300 |
ALTER TABLE ONLY stemobservation |
|
| 5301 |
ADD CONSTRAINT stemobservation_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5302 |
|
|
| 5303 |
|
|
| 5304 |
-- |
|
| 5273 | 5305 |
-- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5274 | 5306 |
-- |
| 5275 | 5307 |
|
| ... | ... | |
| 5342 | 5374 |
|
| 5343 | 5375 |
|
| 5344 | 5376 |
-- |
| 5377 |
-- Name: taxonoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5378 |
-- |
|
| 5379 |
|
|
| 5380 |
ALTER TABLE ONLY taxonoccurrence |
|
| 5381 |
ADD CONSTRAINT taxonoccurrence_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5382 |
|
|
| 5383 |
|
|
| 5384 |
-- |
|
| 5345 | 5385 |
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5346 | 5386 |
-- |
| 5347 | 5387 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added datasource_id fkey constraints to all tables that needed it