/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 3731

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: Reset foreign key constraint names to autogenerated defaults for consistency

     --
     -- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE address
         ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE address
         ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
         ADD CONSTRAINT aggregateoccurrence_coverindex_id_fkey FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
     --
     -- Name: aggregateoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE classcontributor
         ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commclass
         ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commclass_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commconcept
         ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commcorrelation
         ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commcorrelation
         ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commdetermination
         ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commdetermination
         ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commlineage
         ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commlineage
         ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commstatus
         ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commstatus
         ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commusage
         ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commusage
         ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE commusage
         ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE coverindex
         ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: definedvalue_userdefined_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: definedvalue_userdefined_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE definedvalue
         ADD CONSTRAINT definedvalue_userdefined_id FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT definedvalue_userdefined_id_fkey FOREIGN KEY (userdefined_id) REFERENCES userdefined(userdefined_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: disturbanceobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: disturbanceobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE disturbanceobs
         ADD CONSTRAINT disturbanceobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT disturbanceobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: graphic_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: graphic_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE graphic
         ADD CONSTRAINT graphic_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT graphic_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: location_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: location_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: location_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE location
         ADD CONSTRAINT location_parent_id FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT location_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationdetermination_identifier_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationdetermination_identifier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: locationdetermination_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationdetermination_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationdetermination
         ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationdetermination_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationdetermination_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationdetermination_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationdetermination
         ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationdetermination_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_location_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_location_id_fkey FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_parent_id FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_previousobs_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_previousobs_id FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_previous_id_fkey FOREIGN KEY (previous_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationevent_soiltaxon_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationevent_soiltaxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationevent
         ADD CONSTRAINT locationevent_soiltaxon_id FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationevent_soiltaxon_id_fkey FOREIGN KEY (soiltaxon_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationeventcontributor_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationeventcontributor
         ADD CONSTRAINT locationeventcontributor_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationeventcontributor_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationeventcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationeventcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: locationeventsynonym_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationeventsynonym_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: locationeventsynonym_primarylocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationeventsynonym_primarylocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationeventsynonym
         ADD CONSTRAINT locationeventsynonym_primarylocationevent_id FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationeventsynonym_primarylocationevent_id_fkey FOREIGN KEY (primarylocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: locationeventsynonym_synonymlocationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: locationeventsynonym_synonymlocationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE locationeventsynonym
         ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT locationeventsynonym_synonymlocationevent_id_fkey FOREIGN KEY (synonymlocationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: method_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE method
         ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT method_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: method_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: method_subplotmethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: method_subplotmethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE method
         ADD CONSTRAINT method_subplotmethod_id FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
         ADD CONSTRAINT method_subplotmethod_id_fkey FOREIGN KEY (subplotmethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
     --
     -- Name: methodtaxonclass_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: methodtaxonclass_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE methodtaxonclass
         ADD CONSTRAINT methodtaxonclass_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT methodtaxonclass_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: methodtaxonclass_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: methodtaxonclass_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE methodtaxonclass
         ADD CONSTRAINT methodtaxonclass_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT methodtaxonclass_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: methodtaxonclass_submethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: methodtaxonclass_submethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE methodtaxonclass
         ADD CONSTRAINT methodtaxonclass_submethod_id FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
         ADD CONSTRAINT methodtaxonclass_submethod_id_fkey FOREIGN KEY (submethod_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE SET NULL;
     --
     -- Name: namedplace_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: namedplace_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE namedplace_ancestor
         ADD CONSTRAINT namedplace_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT namedplace_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: namedplace_ancestor_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: namedplace_ancestor_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE namedplace_ancestor
         ADD CONSTRAINT namedplace_ancestor_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT namedplace_ancestor_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: namedplace_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: namedplace_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE namedplace
         ADD CONSTRAINT namedplace_parent_id FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT namedplace_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: namedplacecorrelation_childplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: namedplacecorrelation_childplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE namedplacecorrelation
         ADD CONSTRAINT namedplacecorrelation_childplace_id FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT namedplacecorrelation_childplace_id_fkey FOREIGN KEY (childplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: namedplacecorrelation_parentplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: namedplacecorrelation_parentplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE namedplacecorrelation
         ADD CONSTRAINT namedplacecorrelation_parentplace_id FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT namedplacecorrelation_parentplace_id_fkey FOREIGN KEY (parentplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: note_notelink_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: note_notelink_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE note
         ADD CONSTRAINT note_notelink_id FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT note_notelink_id_fkey FOREIGN KEY (notelink_id) REFERENCES notelink(notelink_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: note_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: note_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: party_currentname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: party_currentname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE party
         ADD CONSTRAINT party_currentname_id FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT party_currentname_id_fkey FOREIGN KEY (currentname_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: partymember_childparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: partymember_childparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE partymember
         ADD CONSTRAINT partymember_childparty_id FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT partymember_childparty_id_fkey FOREIGN KEY (childparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: partymember_parentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: partymember_parentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE partymember
         ADD CONSTRAINT partymember_parentparty_id FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT partymember_parentparty_id_fkey FOREIGN KEY (parentparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantconcept_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantconcept_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantconcept
         ADD CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantconcept_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantcorrelation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantcorrelation_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantcorrelation
         ADD CONSTRAINT plantcorrelation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantcorrelation_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantcorrelation_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantcorrelation_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantcorrelation
         ADD CONSTRAINT plantcorrelation_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantcorrelation_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantlineage_childplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantlineage_childplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantlineage
         ADD CONSTRAINT plantlineage_childplantstatus_id FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantlineage_childplantstatus_id_fkey FOREIGN KEY (childplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantlineage_parentplantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantlineage_parentplantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantlineage
         ADD CONSTRAINT plantlineage_parentplantstatus_id FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantlineage_parentplantstatus_id_fkey FOREIGN KEY (parentplantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantname_ancestor_ancestor_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantname_ancestor_ancestor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantname_ancestor
         ADD CONSTRAINT plantname_ancestor_ancestor_id FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantname_ancestor_ancestor_id_fkey FOREIGN KEY (ancestor_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantname_ancestor_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantname_ancestor_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantname_ancestor
         ADD CONSTRAINT plantname_ancestor_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantname_ancestor_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantname_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantname_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantname
         ADD CONSTRAINT plantname_parent_id FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantname_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantname_scope_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantname_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantname
         ADD CONSTRAINT plantname_scope_id FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantname_scope_id_fkey FOREIGN KEY (scope_id) REFERENCES plantnamescope(plantnamescope_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantnamescope_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantnamescope_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantnamescope
         ADD CONSTRAINT plantnamescope_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantnamescope_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantnamescope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantnamescope_namedplace_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantnamescope
         ADD CONSTRAINT plantnamescope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantnamescope_namedplace_id_fkey FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantnamescope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantnamescope_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantnamescope
         ADD CONSTRAINT plantnamescope_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantnamescope_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantobservation_aggregateoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantobservation_aggregateoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantobservation
         ADD CONSTRAINT plantobservation_aggregateoccurrence_id FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantobservation_aggregateoccurrence_id_fkey FOREIGN KEY (aggregateoccurrence_id) REFERENCES aggregateoccurrence(aggregateoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: plantobservation_plant_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantobservation_plant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantobservation
         ADD CONSTRAINT plantobservation_plant_id FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantobservation_plant_id_fkey FOREIGN KEY (plant_id) REFERENCES plant(plant_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: plantstatus_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantstatus_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantstatus
         ADD CONSTRAINT plantstatus_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantstatus_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: plantusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: plantusage_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantusage_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantusage
         ADD CONSTRAINT plantusage_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantusage_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantusage_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantusage_plantname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantusage
         ADD CONSTRAINT plantusage_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantusage_plantname_id_fkey FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: plantusage_plantstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: plantusage_plantstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE plantusage
         ADD CONSTRAINT plantusage_plantstatus_id FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT plantusage_plantstatus_id_fkey FOREIGN KEY (plantstatus_id) REFERENCES plantstatus(plantstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: project_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: project_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: projectcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: projectcontributor_project_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: projectcontributor_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE projectcontributor
         ADD CONSTRAINT projectcontributor_project_id FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT projectcontributor_project_id_fkey FOREIGN KEY (project_id) REFERENCES project(project_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: reference_referencejournal_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: reference_referencejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE reference
         ADD CONSTRAINT reference_referencejournal_id FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT reference_referencejournal_id_fkey FOREIGN KEY (referencejournal_id) REFERENCES referencejournal(referencejournal_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: referencealtident_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: referencealtident_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE referencealtident
         ADD CONSTRAINT referencealtident_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT referencealtident_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: referencecontributor_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: referencecontributor_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE referencecontributor
         ADD CONSTRAINT referencecontributor_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT referencecontributor_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: referencecontributor_referenceparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE referencecontributor
         ADD CONSTRAINT referencecontributor_referenceparty_id FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: referenceparty_currentparty_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE referenceparty
         ADD CONSTRAINT referenceparty_currentparty_id FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: revision_previousrevision_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE revision
         ADD CONSTRAINT revision_previousrevision_id FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT revision_previousrevision_id_fkey FOREIGN KEY (previousrevision_id) REFERENCES revision(revision_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: soilobs_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: soilobs_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE soilobs
         ADD CONSTRAINT soilobs_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT soilobs_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: soiltaxon_soilparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: soiltaxon_soilparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE soiltaxon
         ADD CONSTRAINT soiltaxon_soilparent_id FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT soiltaxon_soilparent_id_fkey FOREIGN KEY (soilparent_id) REFERENCES soiltaxon(soiltaxon_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimenreplicate_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: specimenreplicate_institution_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_institution_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: specimenreplicate_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE specimenreplicate
         ADD CONSTRAINT specimenreplicate_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT specimenreplicate_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimenreplicate_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE specimenreplicate
         ADD CONSTRAINT specimenreplicate_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT specimenreplicate_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: specimenreplicate_specimen_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: specimenreplicate_specimen_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE specimenreplicate
         ADD CONSTRAINT specimenreplicate_specimen_id FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT specimenreplicate_specimen_id_fkey FOREIGN KEY (specimen_id) REFERENCES specimen(specimen_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: stemobservation_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: stemobservation_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: stemobservation_plantobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: stemobservation_plantobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE stemobservation
         ADD CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT stemobservation_plantobservation_id_fkey FOREIGN KEY (plantobservation_id) REFERENCES plantobservation(plantobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: stemtag_stemobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: stemtag_stemobservation_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE stemtag
         ADD CONSTRAINT stemtag_stemobservation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT stemtag_stemobservation_id_fkey FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: stratum_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: stratum_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE stratum
         ADD CONSTRAINT stratum_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT stratum_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: stratum_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: stratum_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE stratum
         ADD CONSTRAINT stratum_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT stratum_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: taxonalt_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxonalt_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE taxonalt
         ADD CONSTRAINT taxonalt_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT taxonalt_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxonalt_taxondetermination_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE taxonalt
         ADD CONSTRAINT taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT taxonalt_taxondetermination_id_fkey FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxondetermination_plantconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE taxondetermination
         ADD CONSTRAINT taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT taxondetermination_plantconcept_id_fkey FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxondetermination_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: taxonoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxonoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     --
     -- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: taxonoccurrence_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE taxonoccurrence
         ADD CONSTRAINT taxonoccurrence_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT taxonoccurrence_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: telephone_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE telephone
         ADD CONSTRAINT telephone_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT telephone_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
-...
     --
     -- Name: voucher_specimenreplicate_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: voucher_specimenreplicate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE voucher
         ADD CONSTRAINT voucher_specimenreplicate_id FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT voucher_specimenreplicate_id_fkey FOREIGN KEY (specimenreplicate_id) REFERENCES specimenreplicate(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: voucher_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: voucher_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE voucher
         ADD CONSTRAINT voucher_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT voucher_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --

     --
     -- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: address_organization_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY address
         ADD CONSTRAINT address_organization_id FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT address_organization_id_fkey FOREIGN KEY (organization_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: address_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: address_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY address
         ADD CONSTRAINT address_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT address_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_coverindex_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_coverindex_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_coverindex_id FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
         ADD CONSTRAINT aggregateoccurrence_coverindex_id_fkey FOREIGN KEY (coverindex_id) REFERENCES coverindex(coverindex_id) ON UPDATE CASCADE ON DELETE SET NULL;
     --
     -- Name: aggregateoccurrence_datasource_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_datasource_id FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_datasource_id_fkey FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_method_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_method_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_method_id FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_method_id_fkey FOREIGN KEY (method_id) REFERENCES method(method_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_stratum_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_stratum_id_fkey FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: aggregateoccurrence_taxonoccurrence_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: aggregateoccurrence_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY aggregateoccurrence
         ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT aggregateoccurrence_taxonoccurrence_id_fkey FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: classcontributor_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY classcontributor
         ADD CONSTRAINT classcontributor_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT classcontributor_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: classcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: classcontributor_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY classcontributor
         ADD CONSTRAINT classcontributor_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT classcontributor_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commclass_classpublication_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commclass_classpublication_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commclass
         ADD CONSTRAINT commclass_classpublication_id FOREIGN KEY (classpublication_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commclass_classpublication_id_fkey FOREIGN KEY (classpublication_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commclass_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commclass_locationevent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commclass
         ADD CONSTRAINT commclass_locationevent_id FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commclass_locationevent_id_fkey FOREIGN KEY (locationevent_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commconcept_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commconcept_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commconcept
         ADD CONSTRAINT commconcept_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commconcept_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commconcept_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commconcept
         ADD CONSTRAINT commconcept_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commcorrelation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commcorrelation_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commcorrelation
         ADD CONSTRAINT commcorrelation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commcorrelation_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commcorrelation_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commcorrelation_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commcorrelation
         ADD CONSTRAINT commcorrelation_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commcorrelation_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commauthority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commdetermination
         ADD CONSTRAINT commdetermination_commauthority_id FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commdetermination_commauthority_id_fkey FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commdetermination
         ADD CONSTRAINT commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commdetermination_commclass_id_fkey FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commdetermination_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commdetermination
         ADD CONSTRAINT commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commdetermination_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commlineage_childcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commlineage_childcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commlineage
         ADD CONSTRAINT commlineage_childcommstatus_id FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commlineage_childcommstatus_id_fkey FOREIGN KEY (childcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commlineage_parentcommstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commlineage_parentcommstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commlineage
         ADD CONSTRAINT commlineage_parentcommstatus_id FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commlineage_parentcommstatus_id_fkey FOREIGN KEY (parentcommstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commname_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commname_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commname
         ADD CONSTRAINT commname_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commname_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commstatus
         ADD CONSTRAINT commstatus_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_commparent_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_commparent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commstatus
         ADD CONSTRAINT commstatus_commparent_id FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_commparent_id_fkey FOREIGN KEY (commparent_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commstatus
         ADD CONSTRAINT commstatus_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commstatus_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commstatus_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commstatus
         ADD CONSTRAINT commstatus_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commstatus_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commusage
         ADD CONSTRAINT commusage_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commconcept_id_fkey FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_commname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commname_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commusage
         ADD CONSTRAINT commusage_commname_id FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commname_id_fkey FOREIGN KEY (commname_id) REFERENCES commname(commname_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_commstatus_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_commstatus_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commusage
         ADD CONSTRAINT commusage_commstatus_id FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_commstatus_id_fkey FOREIGN KEY (commstatus_id) REFERENCES commstatus(commstatus_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: commusage_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: commusage_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY commusage
         ADD CONSTRAINT commusage_party_id FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT commusage_party_id_fkey FOREIGN KEY (party_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: coverindex_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: coverindex_covermethod_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY coverindex
         ADD CONSTRAINT coverindex_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT coverindex_covermethod_id_fkey FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --
     -- Name: covermethod_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
     -- Name: covermethod_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
     --
     ALTER TABLE ONLY covermethod
         ADD CONSTRAINT covermethod_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
         ADD CONSTRAINT covermethod_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
     --

... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff

Project

General

Profile

Revision 3731

Added by Aaron Marcuse-Kubitza over 12 years ago