-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX address_organization_id_x ON address  (organization_id);

--

-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX address_party_id_x ON address  (party_id);

--

-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence  (taxonoccurrence_id);

--

-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_commclass_id_x ON classcontributor  (commclass_id);

--

-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_party_id_x ON classcontributor  (party_id);

--

-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_role_id_x ON classcontributor  (role);

--

-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commclass_classpublication_id_x ON commclass  (classpublication_id);

--

-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commclass_locationevent_id_x ON commclass  (locationevent_id);

--

-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_commname_id_x ON commconcept  (commname_id);

--

-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_dobscount_x ON commconcept  (d_obscount);

--

-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_reference_id_x ON commconcept  (reference_id);

--

-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation  (commconcept_id);

--

-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation  (commstatus_id);

--

-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commauthority_id_x ON commdetermination  (commauthority_id);

--

-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commclass_id_x ON commdetermination  (commclass_id);

--

-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commconcept_id_x ON commdetermination  (commconcept_id);

--

-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commlineage_childcommstatus_id_x ON commlineage  (childcommstatus_id);

--

-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage  (parentcommstatus_id);

--

-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commname_reference_id_x ON commname  (reference_id);

--

-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commconcept_id_x ON commstatus  (commconcept_id);

--

-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commlevel_x ON commstatus  (commlevel);

--

-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commparent_id_x ON commstatus  (commparent_id);

--

-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_party_id_x ON commstatus  (party_id);

--

-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_reference_id_x ON commstatus  (reference_id);

--

-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_classsystem_x ON commusage  (classsystem);

--

-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commconcept_id_x ON commusage  (commconcept_id);

--

-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commname_id_x ON commusage  (commname_id);

--

-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commname_x ON commusage  (commname);

--

-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commstatus_id_x ON commusage  (commstatus_id);

--

-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_party_id_x ON commusage  (party_id);

--

-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX coverindex_covermethod_id_x ON coverindex  (covermethod_id);

--

-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX covermethod_reference_id_x ON covermethod  (reference_id);

--

-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX definedvalue_userdefined_id_x ON definedvalue  (userdefined_id);

--

-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs  (locationevent_id);

--

-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence  (coverindex_id);

--

-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence  (plantobservation_id);

--

-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence  (stratum_id);

--

-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination  (identifier_id);

--

-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_datasource_id ON locationevent  (datasource_id);

--

-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_method_id ON locationevent  (method_id);

--

-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_parent_id ON locationevent  (parent_id);

--

-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_method_reference_id ON method  (reference_id);

--

-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_method_subplotmethod_id ON method  (subplotmethod_id);

--

-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass  (method_id);

--

-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass  (plantconcept_id);

--

-- Name: fki_namedplace_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor  (ancestor_id);

--

-- Name: fki_namedplace_ancestor_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor  (namedplace_id);

--

-- Name: fki_namedplace_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_parent_id ON namedplace  (parent_id);

--

-- Name: fki_plantname_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor  (ancestor_id);

--

-- Name: fki_plantname_ancestor_plantname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor  (plantname_id);

--

-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_parent_id ON plantname  (parent_id);

--

-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_scope_id ON plantname  (scope_id);

--

-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope  (locationevent_id);

--

-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope  (namedplace_id);

--

-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_project_id ON plantnamescope  (project_id);

--

-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantobservation_plant_id ON plantobservation  (plant_id);

--

-- Name: fki_project_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_project_datasource_id ON project  (datasource_id);

--

-- Name: fki_specimenreplicate_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_specimenreplicate_datasource_id ON specimenreplicate  (datasource_id);

--

-- Name: fki_specimenreplicate_institution_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_specimenreplicate_institution_id ON specimenreplicate  (institution_id);

--

-- Name: fki_specimenreplicate_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_specimenreplicate_plantobservation_id ON specimenreplicate  (plantobservation_id);

--

-- Name: fki_specimenreplicate_specimen_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_specimenreplicate_specimen_id ON specimenreplicate  (specimen_id);

--

-- Name: fki_stemtag_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_stemtag_plant_id ON stemtag  (stemobservation_id);

--

-- Name: fki_stemtag_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_stemtag_plantobservation_id ON stemtag  (stemobservation_id);

--

-- Name: fki_stemtag_stemobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_stemtag_stemobservation_id ON stemtag  (stemobservation_id);

--

-- Name: graphic_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX graphic_locationevent_id_x ON graphic  (locationevent_id);

--

-- Name: location_centerlatitude; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: location_centerlongitude; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX location_parent_id_x ON location  (parent_id);

--

-- Name: locationdetermination_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationdetermination_location_id_x ON locationdetermination  (location_id);

--

-- Name: locationdetermination_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: locationevent_location_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationevent_location_id_x ON locationevent  (location_id);

--

-- Name: locationevent_previousobs_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationevent_previousobs_id_x ON locationevent  (previous_id);

--

-- Name: locationevent_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationevent_project_id ON locationevent  (project_id);

--

-- Name: locationevent_soiltaxon_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationevent_soiltaxon_id_x ON locationevent  (soiltaxon_id);

--

-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventcontributor_locationevent_id_x ON locationeventcontributor  (locationevent_id);

--

-- Name: locationeventcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventcontributor_party_id_x ON locationeventcontributor  (party_id);

--

-- Name: locationeventcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventcontributor_role_id_x ON locationeventcontributor  (role);

--

-- Name: locationeventsynonym_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventsynonym_party_id_x ON locationeventsynonym  (party_id);

--

-- Name: locationeventsynonym_primarylocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventsynonym_primarylocationevent_id_x ON locationeventsynonym  (primarylocationevent_id);

--

-- Name: locationeventsynonym_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventsynonym_role_id_x ON locationeventsynonym  (role);

--

-- Name: locationeventsynonym_synonymlocationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX locationeventsynonym_synonymlocationevent_id_x ON locationeventsynonym  (synonymlocationevent_id);

--

-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX method_name ON method  (name);

--

-- Name: note_notelink_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX note_notelink_id_x ON note  (notelink_id);

--

-- Name: note_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX note_party_id_x ON note  (party_id);

--

-- Name: note_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX note_role_id_x ON note  (role);

--

-- Name: party_currentname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX party_currentname_id_x ON party  (currentname_id);

--

-- Name: party_givenname; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: party_middlename; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: party_organizationname; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: party_surname; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

--

-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX partymember_childparty_id_x ON partymember  (childparty_id);

--

-- Name: partymember_parentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX partymember_parentparty_id_x ON partymember  (parentparty_id);

--

-- Name: partymember_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX partymember_role_id_x ON partymember  (role);

--

-- Name: plantconcept_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantconcept_plantname_id_x ON plantconcept  (plantname_id);

--

-- Name: plantcorrelation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantcorrelation_plantconcept_id_x ON plantcorrelation  (plantconcept_id);

--

-- Name: plantcorrelation_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantcorrelation_plantstatus_id_x ON plantcorrelation  (plantstatus_id);

--

-- Name: plantlineage_childplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantlineage_childplantstatus_id_x ON plantlineage  (childplantstatus_id);

--

-- Name: plantlineage_parentplantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantlineage_parentplantstatus_id_x ON plantlineage  (parentplantstatus_id);

--

-- Name: plantstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantstatus_party_id_x ON plantstatus  (party_id);

--

-- Name: plantstatus_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantstatus_plantconcept_id_x ON plantstatus  (plantconcept_id);

--

-- Name: plantstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantstatus_reference_id_x ON plantstatus  (reference_id);

--

-- Name: plantusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_classsystem_x ON plantusage  (classsystem);

--

-- Name: plantusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_party_id_x ON plantusage  (party_id);

--

-- Name: plantusage_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_plantconcept_id_x ON plantusage  (plantconcept_id);

--

-- Name: plantusage_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_plantname_id_x ON plantusage  (plantname_id);

--

-- Name: plantusage_plantname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_plantname_x ON plantusage  (plantname);

--

-- Name: plantusage_plantstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX plantusage_plantstatus_id_x ON plantusage  (plantstatus_id);

--

-- Name: projectcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX projectcontributor_party_id_x ON projectcontributor  (party_id);

--

-- Name: projectcontributor_project_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX projectcontributor_project_id_x ON projectcontributor  (project_id);

--

-- Name: projectcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX projectcontributor_role_id_x ON projectcontributor  (role);

--

-- Name: reference_referencejournal_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX reference_referencejournal_id_x ON reference  (referencejournal_id);

--

-- Name: referencealtident_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX referencealtident_reference_id_x ON referencealtident  (reference_id);

--

-- Name: referencecontributor_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX referencecontributor_reference_id_x ON referencecontributor  (reference_id);

--

-- Name: referencecontributor_referenceparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX referencecontributor_referenceparty_id_x ON referencecontributor  (referenceparty_id);

--

-- Name: referenceparty_currentparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX referenceparty_currentparty_id_x ON referenceparty  (currentparty_id);

--

-- Name: revision_previousrevision_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX revision_previousrevision_id_x ON revision  (previousrevision_id);

--

-- Name: soilobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX soilobs_locationevent_id_x ON soilobs  (locationevent_id);

--

-- Name: soiltaxon_soilparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX soiltaxon_soilparent_id_x ON soiltaxon  (soilparent_id);

--

-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX stemobservation_plantobservation_id_x ON stemobservation  (plantobservation_id);

--

-- Name: stratum_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX stratum_locationevent_id_x ON stratum  (locationevent_id);

--

-- Name: taxonalt_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxonalt_plantconcept_id_x ON taxonalt  (plantconcept_id);

--

-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt  (taxondetermination_id);

--

-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxondetermination_party_id_x ON taxondetermination  (party_id);

--

-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination  (plantconcept_id);

--

-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxondetermination_reference_id_x ON taxondetermination  (reference_id);

--

-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxondetermination_role_id_x ON taxondetermination  (role);

--

-- Name: taxondetermination_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxondetermination_taxonoccurrence_id_x ON taxondetermination  (taxonoccurrence_id);

--

-- Name: taxonoccurrence_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX taxonoccurrence_locationevent_id_x ON taxonoccurrence  (locationevent_id);

--

-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX telephone_party_id_x ON telephone  (party_id);

--

-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX address_organization_id_x ON address USING btree (organization_id);

--

-- Name: address_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX address_party_id_x ON address USING btree (party_id);

--

-- Name: aggregateoccurrence_taxonoccurrence_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX aggregateoccurrence_taxonoccurrence_id_x ON aggregateoccurrence USING btree (taxonoccurrence_id);

--

-- Name: classcontributor_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_commclass_id_x ON classcontributor USING btree (commclass_id);

--

-- Name: classcontributor_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_party_id_x ON classcontributor USING btree (party_id);

--

-- Name: classcontributor_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX classcontributor_role_id_x ON classcontributor USING btree (role);

--

-- Name: commclass_classpublication_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commclass_classpublication_id_x ON commclass USING btree (classpublication_id);

--

-- Name: commclass_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commclass_locationevent_id_x ON commclass USING btree (locationevent_id);

--

-- Name: commconcept_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_commname_id_x ON commconcept USING btree (commname_id);

--

-- Name: commconcept_dobscount_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_dobscount_x ON commconcept USING btree (d_obscount);

--

-- Name: commconcept_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commconcept_reference_id_x ON commconcept USING btree (reference_id);

--

-- Name: commcorrelation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commcorrelation_commconcept_id_x ON commcorrelation USING btree (commconcept_id);

--

-- Name: commcorrelation_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commcorrelation_commstatus_id_x ON commcorrelation USING btree (commstatus_id);

--

-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commauthority_id_x ON commdetermination USING btree (commauthority_id);

--

-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commclass_id_x ON commdetermination USING btree (commclass_id);

--

-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commdetermination_commconcept_id_x ON commdetermination USING btree (commconcept_id);

--

-- Name: commlineage_childcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commlineage_childcommstatus_id_x ON commlineage USING btree (childcommstatus_id);

--

-- Name: commlineage_parentcommstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commlineage_parentcommstatus_id_x ON commlineage USING btree (parentcommstatus_id);

--

-- Name: commname_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commname_reference_id_x ON commname USING btree (reference_id);

--

-- Name: commstatus_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commconcept_id_x ON commstatus USING btree (commconcept_id);

--

-- Name: commstatus_commlevel_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commlevel_x ON commstatus USING btree (commlevel);

--

-- Name: commstatus_commparent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_commparent_id_x ON commstatus USING btree (commparent_id);

--

-- Name: commstatus_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_party_id_x ON commstatus USING btree (party_id);

--

-- Name: commstatus_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commstatus_reference_id_x ON commstatus USING btree (reference_id);

--

-- Name: commusage_classsystem_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_classsystem_x ON commusage USING btree (classsystem);

--

-- Name: commusage_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commconcept_id_x ON commusage USING btree (commconcept_id);

--

-- Name: commusage_commname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commname_id_x ON commusage USING btree (commname_id);

--

-- Name: commusage_commname_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commname_x ON commusage USING btree (commname);

--

-- Name: commusage_commstatus_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_commstatus_id_x ON commusage USING btree (commstatus_id);

--

-- Name: commusage_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX commusage_party_id_x ON commusage USING btree (party_id);

--

-- Name: coverindex_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX coverindex_covermethod_id_x ON coverindex USING btree (covermethod_id);

--

-- Name: covermethod_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX covermethod_reference_id_x ON covermethod USING btree (reference_id);

--

-- Name: definedvalue_userdefined_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX definedvalue_userdefined_id_x ON definedvalue USING btree (userdefined_id);

--

-- Name: disturbanceobs_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX disturbanceobs_locationevent_id_x ON disturbanceobs USING btree (locationevent_id);

--

-- Name: fki_aggregateoccurrence_coverindex_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_coverindex_id ON aggregateoccurrence USING btree (coverindex_id);

--

-- Name: fki_aggregateoccurrence_plantobservation_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_plantobservation_id ON aggregateoccurrence USING btree (plantobservation_id);

--

-- Name: fki_aggregateoccurrence_stratum_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_aggregateoccurrence_stratum_id ON aggregateoccurrence USING btree (stratum_id);

--

-- Name: fki_locationdetermination_identifier_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination USING btree (identifier_id);

--

-- Name: fki_locationevent_datasource_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_datasource_id ON locationevent USING btree (datasource_id);

--

-- Name: fki_locationevent_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_method_id ON locationevent USING btree (method_id);

--

-- Name: fki_locationevent_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_locationevent_parent_id ON locationevent USING btree (parent_id);

--

-- Name: fki_method_reference_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_method_reference_id ON method USING btree (reference_id);

--

-- Name: fki_method_subplotmethod_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_method_subplotmethod_id ON method USING btree (subplotmethod_id);

--

-- Name: fki_methodtaxonclass_method_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtaxonclass_method_id ON methodtaxonclass USING btree (method_id);

--

-- Name: fki_methodtaxonclass_plantconcept_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_methodtaxonclass_plantconcept_id ON methodtaxonclass USING btree (plantconcept_id);

--

-- Name: fki_namedplace_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_ancestor_ancestor_id ON namedplace_ancestor USING btree (ancestor_id);

--

-- Name: fki_namedplace_ancestor_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_ancestor_namedplace_id ON namedplace_ancestor USING btree (namedplace_id);

--

-- Name: fki_namedplace_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_namedplace_parent_id ON namedplace USING btree (parent_id);

--

-- Name: fki_plantname_ancestor_ancestor_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_ancestor_ancestor_id ON plantname_ancestor USING btree (ancestor_id);

--

-- Name: fki_plantname_ancestor_plantname_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_ancestor_plantname_id ON plantname_ancestor USING btree (plantname_id);

--

-- Name: fki_plantname_parent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_parent_id ON plantname USING btree (parent_id);

--

-- Name: fki_plantname_scope_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantname_scope_id ON plantname USING btree (scope_id);

--

-- Name: fki_plantnamescope_locationevent_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_locationevent_id ON plantnamescope USING btree (locationevent_id);

--

-- Name: fki_plantnamescope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_namedplace_id ON plantnamescope USING btree (namedplace_id);

--

-- Name: fki_plantnamescope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantnamescope_project_id ON plantnamescope USING btree (project_id);

--

-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE INDEX fki_plantobservation_plant_id ON plantobservation USING btree (plant_id);