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

--

CREATE INDEX address_organization_id_idx ON address USING btree (organization_id);

--

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

--

CREATE INDEX address_party_id_idx ON address USING btree (party_id);

--

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

--

CREATE INDEX aggregateoccurrence_coverindex_id_idx ON aggregateoccurrence USING btree (coverindex_id);

--

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

--

CREATE INDEX aggregateoccurrence_method_id_idx ON aggregateoccurrence USING btree (method_id);

--

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

--

CREATE INDEX aggregateoccurrence_stratum_id_idx ON aggregateoccurrence USING btree (stratum_id);

--

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

--

CREATE INDEX classcontributor_commclass_id_idx ON classcontributor USING btree (commclass_id);

--

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

--

CREATE INDEX classcontributor_party_id_idx ON classcontributor USING btree (party_id);

--

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

--

CREATE INDEX commclass_classpublication_id_idx ON commclass USING btree (classpublication_id);

--

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

--

CREATE INDEX commconcept_reference_id_idx ON commconcept USING btree (reference_id);

--

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

--

CREATE INDEX commcorrelation_commconcept_id_idx ON commcorrelation USING btree (commconcept_id);

--

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

--

CREATE INDEX commcorrelation_commstatus_id_idx ON commcorrelation USING btree (commstatus_id);

--

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

--

CREATE INDEX commdetermination_commauthority_id_idx ON commdetermination USING btree (commauthority_id);

--

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

--

CREATE INDEX commdetermination_commconcept_id_idx ON commdetermination USING btree (commconcept_id);

--

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

--

CREATE INDEX commlineage_childcommstatus_id_idx ON commlineage USING btree (childcommstatus_id);

--

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

--

CREATE INDEX commlineage_parentcommstatus_id_idx ON commlineage USING btree (parentcommstatus_id);

--

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

--

CREATE INDEX commname_source_id_idx ON commname USING btree (source_id);

--

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

--

CREATE INDEX commstatus_commconcept_id_idx ON commstatus USING btree (commconcept_id);

--

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

--

CREATE INDEX commstatus_commparent_id_idx ON commstatus USING btree (commparent_id);

--

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

--

CREATE INDEX commstatus_party_id_idx ON commstatus USING btree (party_id);

--

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

--

CREATE INDEX commstatus_source_id_idx ON commstatus USING btree (source_id);

--

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

--

CREATE INDEX commusage_commconcept_id_idx ON commusage USING btree (commconcept_id);

--

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

--

CREATE INDEX commusage_commname_id_idx ON commusage USING btree (commname_id);

--

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

--

CREATE INDEX commusage_commstatus_id_idx ON commusage USING btree (commstatus_id);

--

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

--

CREATE INDEX commusage_party_id_idx ON commusage USING btree (party_id);

--

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

--

CREATE INDEX coverindex_covermethod_id_idx ON coverindex USING btree (covermethod_id);

--

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

--

CREATE INDEX covermethod_source_id_idx ON covermethod USING btree (source_id);

--

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

--

CREATE INDEX disturbanceobs_locationevent_id_idx ON disturbanceobs USING btree (locationevent_id);

--

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

--

CREATE INDEX graphic_locationevent_id_idx ON graphic USING btree (locationevent_id);

--

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

--

CREATE INDEX locationevent_method_id_idx ON locationevent USING btree (method_id);

--

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

--

CREATE INDEX locationevent_parent_id_idx ON locationevent USING btree (parent_id);

--

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

--

CREATE INDEX locationevent_previous_id_idx ON locationevent USING btree (previous_id);

--

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

--

CREATE INDEX locationevent_project_id_idx ON locationevent USING btree (project_id);

--

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

--

CREATE INDEX locationevent_soiltaxon_id_idx ON locationevent USING btree (soiltaxon_id);

--

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

--

CREATE INDEX locationeventcontributor_locationevent_id_idx ON locationeventcontributor USING btree (locationevent_id);

--

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

--

CREATE INDEX locationeventcontributor_party_id_idx ON locationeventcontributor USING btree (party_id);

--

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

--

CREATE INDEX locationeventsynonym_party_id_idx ON locationeventsynonym USING btree (party_id);

--

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

--

CREATE INDEX locationeventsynonym_primarylocationevent_id_idx ON locationeventsynonym USING btree (primarylocationevent_id);

--

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

--

CREATE INDEX locationeventsynonym_synonymlocationevent_id_idx ON locationeventsynonym USING btree (synonymlocationevent_id);

--

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

--

CREATE INDEX locationplace_identifier_id_idx ON locationplace USING btree (identifier_id);

--

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

--

CREATE INDEX locationplace_place_id_idx ON locationplace USING btree (place_id);

--

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

--

CREATE INDEX method_covermethod_id_idx ON method USING btree (covermethod_id);

--

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

--

CREATE INDEX method_subplotmethod_id_idx ON method USING btree (subplotmethod_id);

--

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

--

CREATE INDEX methodtaxonclass_submethod_id_idx ON methodtaxonclass USING btree (submethod_id);

--

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

--

CREATE INDEX methodtaxonclass_taxonlabel_id_idx ON methodtaxonclass USING btree (taxonlabel_id);

--

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

--

CREATE INDEX note_notelink_id_idx ON note USING btree (notelink_id);

--

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

--

CREATE INDEX note_party_id_idx ON note USING btree (party_id);

--

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

--

CREATE INDEX party_currentname_id_idx ON party USING btree (currentname_id);

--

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

--

CREATE INDEX partymember_childparty_id_idx ON partymember USING btree (childparty_id);

--

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

--

CREATE INDEX partymember_parentparty_id_idx ON partymember USING btree (parentparty_id);

--

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

--

CREATE INDEX place_canon_place_id_idx ON place USING btree (canon_place_id);

--

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

--

CREATE INDEX place_coordinates_id_idx ON place USING btree (coordinates_id);

--

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

--

CREATE INDEX placecorrelation_childplace_id_idx ON placecorrelation USING btree (childplace_id);

--

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

--

CREATE INDEX placecorrelation_parentplace_id_idx ON placecorrelation USING btree (parentplace_id);

--

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

--

CREATE INDEX placename_ancestor_ancestor_id_idx ON placename_ancestor USING btree (ancestor_id);

--

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

--

CREATE INDEX placename_parent_id_idx ON placename USING btree (parent_id);

--

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

--

CREATE INDEX plantobservation_plant_id_idx ON plantobservation USING btree (plant_id);

--

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

--

CREATE INDEX projectcontributor_party_id_idx ON projectcontributor USING btree (party_id);

--

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

--

CREATE INDEX projectcontributor_project_id_idx ON projectcontributor USING btree (project_id);

--

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

--

CREATE INDEX revision_previousrevision_id_idx ON revision USING btree (previousrevision_id);

--

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

--

CREATE INDEX soiltaxon_soilparent_id_idx ON soiltaxon USING btree (soilparent_id);

--

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

--

CREATE INDEX source_matched_source_id_idx ON source USING btree (matched_source_id);

--

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

--

CREATE INDEX source_parent_id_idx ON source USING btree (parent_id);

--

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

--

CREATE INDEX sourcecontributor_source_id_idx ON sourcecontributor USING btree (source_id);

--

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

--

CREATE INDEX sourcecontributor_sourceparty_id_idx ON sourcecontributor USING btree (sourceparty_id);

--

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

--

CREATE INDEX specimenreplicate_institution_id_idx ON specimenreplicate USING btree (institution_id);

--

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

--

CREATE INDEX specimenreplicate_specimen_id_idx ON specimenreplicate USING btree (specimen_id);

--

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

--

CREATE INDEX stratum_locationevent_id_idx ON stratum USING btree (locationevent_id);

--

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

--

CREATE INDEX stratum_method_id_idx ON stratum USING btree (method_id);

--

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

--

CREATE INDEX taxonalt_taxondetermination_id_idx ON taxonalt USING btree (taxondetermination_id);

--

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

--

CREATE INDEX taxonalt_taxonlabel_id_idx ON taxonalt USING btree (taxonlabel_id);

--

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

--

CREATE INDEX taxonconcept_concept_reference_id_idx ON taxonconcept USING btree (concept_reference_id);

--

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

--

CREATE INDEX taxoncorrelation_taxonlabel_id_idx ON taxoncorrelation USING btree (taxonlabel_id);

--

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

--

CREATE INDEX taxoncorrelation_taxonstatus_id_idx ON taxoncorrelation USING btree (taxonstatus_id);

--

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

--

CREATE INDEX taxondetermination_party_id_idx ON taxondetermination USING btree (party_id);

--

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

--

CREATE INDEX taxondetermination_taxonverbatim_id_idx ON taxondetermination USING btree (taxonverbatim_id);

--

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

--

CREATE INDEX taxonlabel_canon_label_id_idx ON taxonlabel USING btree (canon_label_id);

--

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

--

CREATE INDEX taxonlabel_parent_id_idx ON taxonlabel USING btree (parent_id);

--

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

--

CREATE INDEX taxonlineage_childtaxonstatus_id_idx ON taxonlineage USING btree (childtaxonstatus_id);

--

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

--

CREATE INDEX taxonlineage_parenttaxonstatus_id_idx ON taxonlineage USING btree (parenttaxonstatus_id);

--

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

--

CREATE INDEX taxonoccurrence_collector_id_idx ON taxonoccurrence USING btree (collector_id);

--

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

--

CREATE INDEX taxonstatus_party_id_idx ON taxonstatus USING btree (party_id);

--

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

--

CREATE INDEX taxonstatus_source_id_idx ON taxonstatus USING btree (source_id);

--

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

--

CREATE INDEX telephone_party_id_idx ON telephone USING btree (party_id);

--

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

--

CREATE INDEX voucher_specimenreplicate_id_idx ON voucher USING btree (specimenreplicate_id);

--