Revision 812
Added by Aaron Marcuse-Kubitza about 13 years ago
vegbien.my.sql | ||
---|---|---|
5609 | 5609 |
-- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5610 | 5610 |
-- |
5611 | 5611 |
|
5612 |
ALTER TABLE classcontributor |
|
5613 |
ADD CONSTRAINT classcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5614 | 5612 |
|
5615 | 5613 |
|
5614 |
|
|
5616 | 5615 |
-- |
5617 | 5616 |
-- Name: classcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5618 | 5617 |
-- |
... | ... | |
5625 | 5624 |
-- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5626 | 5625 |
-- |
5627 | 5626 |
|
5628 |
ALTER TABLE commclass |
|
5629 |
ADD CONSTRAINT commclass_classpublication_id FOREIGN KEY (classpublication_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5630 | 5627 |
|
5631 | 5628 |
|
5629 |
|
|
5632 | 5630 |
-- |
5633 | 5631 |
-- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5634 | 5632 |
-- |
... | ... | |
5649 | 5647 |
-- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5650 | 5648 |
-- |
5651 | 5649 |
|
5652 |
ALTER TABLE commconcept |
|
5653 |
ADD CONSTRAINT commconcept_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5654 | 5650 |
|
5655 | 5651 |
|
5652 |
|
|
5656 | 5653 |
-- |
5657 | 5654 |
-- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5658 | 5655 |
-- |
... | ... | |
5673 | 5670 |
-- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5674 | 5671 |
-- |
5675 | 5672 |
|
5676 |
ALTER TABLE commdetermination |
|
5677 |
ADD CONSTRAINT commdetermination_commauthority_id FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5678 | 5673 |
|
5679 | 5674 |
|
5675 |
|
|
5680 | 5676 |
-- |
5681 | 5677 |
-- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5682 | 5678 |
-- |
... | ... | |
5713 | 5709 |
-- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5714 | 5710 |
-- |
5715 | 5711 |
|
5716 |
ALTER TABLE commname |
|
5717 |
ADD CONSTRAINT commname_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5718 | 5712 |
|
5719 | 5713 |
|
5714 |
|
|
5720 | 5715 |
-- |
5721 | 5716 |
-- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5722 | 5717 |
-- |
... | ... | |
5737 | 5732 |
-- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5738 | 5733 |
-- |
5739 | 5734 |
|
5740 |
ALTER TABLE commstatus |
|
5741 |
ADD CONSTRAINT commstatus_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5742 | 5735 |
|
5743 | 5736 |
|
5737 |
|
|
5744 | 5738 |
-- |
5745 | 5739 |
-- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5746 | 5740 |
-- |
5747 | 5741 |
|
5748 |
ALTER TABLE commstatus |
|
5749 |
ADD CONSTRAINT commstatus_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5750 | 5742 |
|
5751 | 5743 |
|
5744 |
|
|
5752 | 5745 |
-- |
5753 | 5746 |
-- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5754 | 5747 |
-- |
... | ... | |
5777 | 5770 |
-- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5778 | 5771 |
-- |
5779 | 5772 |
|
5780 |
ALTER TABLE commusage |
|
5781 |
ADD CONSTRAINT commusage_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5782 | 5773 |
|
5783 | 5774 |
|
5775 |
|
|
5784 | 5776 |
-- |
5785 | 5777 |
-- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5786 | 5778 |
-- |
... | ... | |
5793 | 5785 |
-- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5794 | 5786 |
-- |
5795 | 5787 |
|
5796 |
ALTER TABLE covermethod |
|
5797 |
ADD CONSTRAINT covermethod_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5798 | 5788 |
|
5799 | 5789 |
|
5790 |
|
|
5800 | 5791 |
-- |
5801 | 5792 |
-- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5802 | 5793 |
-- |
... | ... | |
5841 | 5832 |
-- Name: location_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5842 | 5833 |
-- |
5843 | 5834 |
|
5844 |
ALTER TABLE location |
|
5845 |
ADD CONSTRAINT location_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5846 | 5835 |
|
5847 | 5836 |
|
5837 |
|
|
5848 | 5838 |
-- |
5849 | 5839 |
-- Name: locationevent_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5850 | 5840 |
-- |
... | ... | |
5897 | 5887 |
-- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5898 | 5888 |
-- |
5899 | 5889 |
|
5900 |
ALTER TABLE locationeventcontributor |
|
5901 |
ADD CONSTRAINT locationeventcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5902 | 5890 |
|
5903 | 5891 |
|
5892 |
|
|
5904 | 5893 |
-- |
5905 | 5894 |
-- Name: locationeventcontributor_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5906 | 5895 |
-- |
... | ... | |
5913 | 5902 |
-- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5914 | 5903 |
-- |
5915 | 5904 |
|
5916 |
ALTER TABLE locationeventsynonym |
|
5917 |
ADD CONSTRAINT locationeventsynonym_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5918 | 5905 |
|
5919 | 5906 |
|
5907 |
|
|
5920 | 5908 |
-- |
5921 | 5909 |
-- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5922 | 5910 |
-- |
... | ... | |
5961 | 5949 |
-- Name: namedplace_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5962 | 5950 |
-- |
5963 | 5951 |
|
5964 |
ALTER TABLE namedplace |
|
5965 |
ADD CONSTRAINT namedplace_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5966 | 5952 |
|
5967 | 5953 |
|
5954 |
|
|
5968 | 5955 |
-- |
5969 | 5956 |
-- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5970 | 5957 |
-- |
... | ... | |
5993 | 5980 |
-- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
5994 | 5981 |
-- |
5995 | 5982 |
|
5996 |
ALTER TABLE note |
|
5997 |
ADD CONSTRAINT note_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
5998 | 5983 |
|
5999 | 5984 |
|
5985 |
|
|
6000 | 5986 |
-- |
6001 | 5987 |
-- Name: note_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6002 | 5988 |
-- |
... | ... | |
6049 | 6035 |
-- Name: plantconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6050 | 6036 |
-- |
6051 | 6037 |
|
6052 |
ALTER TABLE plantconcept |
|
6053 |
ADD CONSTRAINT plantconcept_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6054 | 6038 |
|
6055 | 6039 |
|
6040 |
|
|
6056 | 6041 |
-- |
6057 | 6042 |
-- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6058 | 6043 |
-- |
... | ... | |
6089 | 6074 |
-- Name: plantname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6090 | 6075 |
-- |
6091 | 6076 |
|
6092 |
ALTER TABLE plantname |
|
6093 |
ADD CONSTRAINT plantname_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6094 | 6077 |
|
6095 | 6078 |
|
6079 |
|
|
6096 | 6080 |
-- |
6097 | 6081 |
-- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6098 | 6082 |
-- |
... | ... | |
6105 | 6089 |
-- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6106 | 6090 |
-- |
6107 | 6091 |
|
6108 |
ALTER TABLE plantstatus |
|
6109 |
ADD CONSTRAINT plantstatus_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6110 | 6092 |
|
6111 | 6093 |
|
6094 |
|
|
6112 | 6095 |
-- |
6113 | 6096 |
-- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6114 | 6097 |
-- |
... | ... | |
6129 | 6112 |
-- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6130 | 6113 |
-- |
6131 | 6114 |
|
6132 |
ALTER TABLE plantstatus |
|
6133 |
ADD CONSTRAINT plantstatus_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6134 | 6115 |
|
6135 | 6116 |
|
6117 |
|
|
6136 | 6118 |
-- |
6137 | 6119 |
-- Name: planttag_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6138 | 6120 |
-- |
... | ... | |
6145 | 6127 |
-- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6146 | 6128 |
-- |
6147 | 6129 |
|
6148 |
ALTER TABLE plantusage |
|
6149 |
ADD CONSTRAINT plantusage_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6150 | 6130 |
|
6151 | 6131 |
|
6132 |
|
|
6152 | 6133 |
-- |
6153 | 6134 |
-- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6154 | 6135 |
-- |
... | ... | |
6177 | 6158 |
-- Name: project_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6178 | 6159 |
-- |
6179 | 6160 |
|
6180 |
ALTER TABLE project |
|
6181 |
ADD CONSTRAINT project_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6182 | 6161 |
|
6183 | 6162 |
|
6163 |
|
|
6184 | 6164 |
-- |
6185 | 6165 |
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6186 | 6166 |
-- |
6187 | 6167 |
|
6188 |
ALTER TABLE projectcontributor |
|
6189 |
ADD CONSTRAINT projectcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6190 | 6168 |
|
6191 | 6169 |
|
6170 |
|
|
6192 | 6171 |
-- |
6193 | 6172 |
-- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6194 | 6173 |
-- |
... | ... | |
6273 | 6252 |
-- Name: specimenreplicate_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6274 | 6253 |
-- |
6275 | 6254 |
|
6276 |
ALTER TABLE specimenreplicate |
|
6277 |
ADD CONSTRAINT specimenreplicate_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6278 | 6255 |
|
6279 | 6256 |
|
6257 |
|
|
6280 | 6258 |
-- |
6281 | 6259 |
-- Name: specimenreplicate_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
6282 | 6260 |
-- |
6283 | 6261 |
|
6284 |
ALTER TABLE specimenreplicate |
|
6285 |
ADD CONSTRAINT specimenreplicate_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6286 | 6262 |
|
6287 | 6263 |
|
6264 |
|
|
6288 | 6265 |
-- |
6289 | 6266 |
-- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6290 | 6267 |
-- |
... | ... | |
6329 | 6306 |
-- Name: stratummethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6330 | 6307 |
-- |
6331 | 6308 |
|
6332 |
ALTER TABLE stratummethod |
|
6333 |
ADD CONSTRAINT stratummethod_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6334 | 6309 |
|
6335 | 6310 |
|
6311 |
|
|
6336 | 6312 |
-- |
6337 | 6313 |
-- Name: stratumtype_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6338 | 6314 |
-- |
... | ... | |
6361 | 6337 |
-- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6362 | 6338 |
-- |
6363 | 6339 |
|
6364 |
ALTER TABLE taxondetermination |
|
6365 |
ADD CONSTRAINT taxondetermination_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6366 | 6340 |
|
6367 | 6341 |
|
6342 |
|
|
6368 | 6343 |
-- |
6369 | 6344 |
-- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6370 | 6345 |
-- |
... | ... | |
6377 | 6352 |
-- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6378 | 6353 |
-- |
6379 | 6354 |
|
6380 |
ALTER TABLE taxondetermination |
|
6381 |
ADD CONSTRAINT taxondetermination_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6382 | 6355 |
|
6383 | 6356 |
|
6357 |
|
|
6384 | 6358 |
-- |
6385 | 6359 |
-- Name: taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6386 | 6360 |
-- |
... | ... | |
6409 | 6383 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6410 | 6384 |
-- |
6411 | 6385 |
|
6412 |
ALTER TABLE taxonoccurrence |
|
6413 |
ADD CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6414 | 6386 |
|
6415 | 6387 |
|
6388 |
|
|
6416 | 6389 |
-- |
6417 | 6390 |
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6418 | 6391 |
-- |
... | ... | |
6513 | 6486 |
-- Name: usr_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6514 | 6487 |
-- |
6515 | 6488 |
|
6516 |
ALTER TABLE usr |
|
6517 |
ADD CONSTRAINT usr_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6518 | 6489 |
|
6519 | 6490 |
|
6491 |
|
|
6520 | 6492 |
-- |
6521 | 6493 |
-- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
6522 | 6494 |
-- |
Also available in: Unified diff
filter_ERD.csv: Remove fkeys to heavily-linked tables (reference, party)