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

--

CREATE INDEX address_organization_id_idx ON address  (organization_id);

--

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

--

CREATE INDEX address_party_id_idx ON address  (party_id);

--

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

--

CREATE INDEX aggregateoccurrence_coverindex_id_idx ON aggregateoccurrence  (coverindex_id);

--

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

--

CREATE INDEX aggregateoccurrence_method_id_idx ON aggregateoccurrence  (method_id);

--

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

--

CREATE INDEX aggregateoccurrence_stratum_id_idx ON aggregateoccurrence  (stratum_id);

--

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

--

CREATE INDEX classcontributor_commclass_id_idx ON classcontributor  (commclass_id);

--

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

--

CREATE INDEX classcontributor_party_id_idx ON classcontributor  (party_id);

--

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

--

CREATE INDEX commclass_classpublication_id_idx ON commclass  (classpublication_id);

--

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

--

CREATE INDEX commconcept_reference_id_idx ON commconcept  (reference_id);

--

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

--

CREATE INDEX commcorrelation_commconcept_id_idx ON commcorrelation  (commconcept_id);

--

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

--

CREATE INDEX commcorrelation_commstatus_id_idx ON commcorrelation  (commstatus_id);

--

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

--

CREATE INDEX commdetermination_commauthority_id_idx ON commdetermination  (commauthority_id);

--

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

--

CREATE INDEX commdetermination_commconcept_id_idx ON commdetermination  (commconcept_id);

--

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

--

CREATE INDEX commlineage_childcommstatus_id_idx ON commlineage  (childcommstatus_id);

--

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

--

CREATE INDEX commlineage_parentcommstatus_id_idx ON commlineage  (parentcommstatus_id);

--

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

--

CREATE INDEX commname_source_id_idx ON commname  (source_id);

--

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

--

CREATE INDEX commstatus_commconcept_id_idx ON commstatus  (commconcept_id);

--

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

--

CREATE INDEX commstatus_commparent_id_idx ON commstatus  (commparent_id);

--

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

--

CREATE INDEX commstatus_party_id_idx ON commstatus  (party_id);

--

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

--

CREATE INDEX commstatus_source_id_idx ON commstatus  (source_id);

--

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

--

CREATE INDEX commusage_commconcept_id_idx ON commusage  (commconcept_id);

--

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

--

CREATE INDEX commusage_commname_id_idx ON commusage  (commname_id);

--

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

--

CREATE INDEX commusage_commstatus_id_idx ON commusage  (commstatus_id);

--

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

--

CREATE INDEX commusage_party_id_idx ON commusage  (party_id);

--

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

--

CREATE INDEX coverindex_covermethod_id_idx ON coverindex  (covermethod_id);

--

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

--

CREATE INDEX covermethod_source_id_idx ON covermethod  (source_id);

--

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

--

CREATE INDEX disturbanceobs_locationevent_id_idx ON disturbanceobs  (locationevent_id);

--

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

--

CREATE INDEX graphic_locationevent_id_idx ON graphic  (locationevent_id);

--

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

--

CREATE INDEX locationevent_method_id_idx ON locationevent  (method_id);

--

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

--

CREATE INDEX locationevent_parent_id_idx ON locationevent  (parent_id);

--

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

--

CREATE INDEX locationevent_previous_id_idx ON locationevent  (previous_id);

--

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

--

CREATE INDEX locationevent_project_id_idx ON locationevent  (project_id);

--

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

--

CREATE INDEX locationevent_soiltaxon_id_idx ON locationevent  (soiltaxon_id);

--

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

--

CREATE INDEX locationeventcontributor_locationevent_id_idx ON locationeventcontributor  (locationevent_id);

--

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

--

CREATE INDEX locationeventcontributor_party_id_idx ON locationeventcontributor  (party_id);

--

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

--

CREATE INDEX locationeventsynonym_party_id_idx ON locationeventsynonym  (party_id);

--

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

--

CREATE INDEX locationeventsynonym_primarylocationevent_id_idx ON locationeventsynonym  (primarylocationevent_id);

--

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

--

CREATE INDEX locationeventsynonym_synonymlocationevent_id_idx ON locationeventsynonym  (synonymlocationevent_id);

--

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

--

CREATE INDEX locationplace_identifier_id_idx ON locationplace  (identifier_id);

--

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

--

CREATE INDEX locationplace_place_id_idx ON locationplace  (place_id);

--

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

--

CREATE INDEX method_covermethod_id_idx ON method  (covermethod_id);

--

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

--

CREATE INDEX method_subplotmethod_id_idx ON method  (subplotmethod_id);

--

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

--

CREATE INDEX methodtaxonclass_submethod_id_idx ON methodtaxonclass  (submethod_id);

--

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

--

CREATE INDEX methodtaxonclass_taxonlabel_id_idx ON methodtaxonclass  (taxonlabel_id);

--

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

--

CREATE INDEX note_notelink_id_idx ON note  (notelink_id);

--

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

--

CREATE INDEX note_party_id_idx ON note  (party_id);

--

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

--

CREATE INDEX party_currentname_id_idx ON party  (currentname_id);

--

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

--

CREATE INDEX partymember_childparty_id_idx ON partymember  (childparty_id);

--

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

--

CREATE INDEX partymember_parentparty_id_idx ON partymember  (parentparty_id);

--

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

--

CREATE INDEX place_canon_place_id_idx ON place  (canon_place_id);

--

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

--

CREATE INDEX place_coordinates_id_idx ON place  (coordinates_id);

--

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

--

CREATE INDEX placecorrelation_childplace_id_idx ON placecorrelation  (childplace_id);

--

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

--

CREATE INDEX placecorrelation_parentplace_id_idx ON placecorrelation  (parentplace_id);

--

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

--

CREATE INDEX placename_ancestor_ancestor_id_idx ON placename_ancestor  (ancestor_id);

--

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

--

CREATE INDEX placename_parent_id_idx ON placename  (parent_id);

--

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

--

CREATE INDEX plantobservation_plant_id_idx ON plantobservation  (plant_id);

--

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

--

CREATE INDEX projectcontributor_party_id_idx ON projectcontributor  (party_id);

--

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

--

CREATE INDEX projectcontributor_project_id_idx ON projectcontributor  (project_id);

--

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

--

CREATE INDEX revision_previousrevision_id_idx ON revision  (previousrevision_id);

--

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

--

CREATE INDEX soiltaxon_soilparent_id_idx ON soiltaxon  (soilparent_id);

--

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

--

CREATE INDEX source_matched_source_id_idx ON source  (matched_source_id);

--

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

--

CREATE INDEX source_parent_id_idx ON source  (parent_id);

--

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

--

CREATE INDEX sourcecontributor_source_id_idx ON sourcecontributor  (source_id);

--

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

--

CREATE INDEX sourcecontributor_sourceparty_id_idx ON sourcecontributor  (sourceparty_id);

--

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

--

CREATE INDEX specimenreplicate_institution_id_idx ON specimenreplicate  (institution_id);

--

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

--

CREATE INDEX specimenreplicate_specimen_id_idx ON specimenreplicate  (specimen_id);

--

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

--

CREATE INDEX stratum_locationevent_id_idx ON stratum  (locationevent_id);

--

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

--

CREATE INDEX stratum_method_id_idx ON stratum  (method_id);

--

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

--

CREATE INDEX taxonalt_taxondetermination_id_idx ON taxonalt  (taxondetermination_id);

--

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

--

CREATE INDEX taxonalt_taxonlabel_id_idx ON taxonalt  (taxonlabel_id);

--

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

--

CREATE INDEX taxonconcept_concept_reference_id_idx ON taxonconcept  (concept_reference_id);

--

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

--

CREATE INDEX taxoncorrelation_taxonlabel_id_idx ON taxoncorrelation  (taxonlabel_id);

--

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

--

CREATE INDEX taxoncorrelation_taxonstatus_id_idx ON taxoncorrelation  (taxonstatus_id);

--

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

--

CREATE INDEX taxondetermination_party_id_idx ON taxondetermination  (party_id);

--

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

--

CREATE INDEX taxondetermination_taxonverbatim_id_idx ON taxondetermination  (taxonverbatim_id);

--

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

--

CREATE INDEX taxonlabel_canon_label_id_idx ON taxonlabel  (canon_label_id);

--

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

--

CREATE INDEX taxonlabel_parent_id_idx ON taxonlabel  (parent_id);

--

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

--

CREATE INDEX taxonlineage_childtaxonstatus_id_idx ON taxonlineage  (childtaxonstatus_id);

--

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

--

CREATE INDEX taxonlineage_parenttaxonstatus_id_idx ON taxonlineage  (parenttaxonstatus_id);

--

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

--

CREATE INDEX taxonoccurrence_collector_id_idx ON taxonoccurrence  (collector_id);

--

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

--

CREATE INDEX taxonstatus_party_id_idx ON taxonstatus  (party_id);

--

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

--

CREATE INDEX taxonstatus_source_id_idx ON taxonstatus  (source_id);

--

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

--

CREATE INDEX telephone_party_id_idx ON telephone  (party_id);

--

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

--

CREATE INDEX voucher_specimenreplicate_id_idx ON voucher  (specimenreplicate_id);

--