Revision 7055
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4975 | 4975 |
|
| 4976 | 4976 |
|
| 4977 | 4977 |
-- |
| 4978 |
-- Name: address_organization_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4979 |
-- |
|
| 4980 |
|
|
| 4981 |
CREATE INDEX address_organization_id_idx ON address (organization_id); |
|
| 4982 |
|
|
| 4983 |
|
|
| 4984 |
-- |
|
| 4985 |
-- Name: address_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4986 |
-- |
|
| 4987 |
|
|
| 4988 |
CREATE INDEX address_party_id_idx ON address (party_id); |
|
| 4989 |
|
|
| 4990 |
|
|
| 4991 |
-- |
|
| 4992 |
-- Name: aggregateoccurrence_coverindex_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4993 |
-- |
|
| 4994 |
|
|
| 4995 |
CREATE INDEX aggregateoccurrence_coverindex_id_idx ON aggregateoccurrence (coverindex_id); |
|
| 4996 |
|
|
| 4997 |
|
|
| 4998 |
-- |
|
| 4999 |
-- Name: aggregateoccurrence_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5000 |
-- |
|
| 5001 |
|
|
| 5002 |
CREATE INDEX aggregateoccurrence_method_id_idx ON aggregateoccurrence (method_id); |
|
| 5003 |
|
|
| 5004 |
|
|
| 5005 |
-- |
|
| 4978 | 5006 |
-- Name: aggregateoccurrence_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4979 | 5007 |
-- |
| 4980 | 5008 |
|
| ... | ... | |
| 4982 | 5010 |
|
| 4983 | 5011 |
|
| 4984 | 5012 |
-- |
| 5013 |
-- Name: aggregateoccurrence_stratum_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5014 |
-- |
|
| 5015 |
|
|
| 5016 |
CREATE INDEX aggregateoccurrence_stratum_id_idx ON aggregateoccurrence (stratum_id); |
|
| 5017 |
|
|
| 5018 |
|
|
| 5019 |
-- |
|
| 4985 | 5020 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4986 | 5021 |
-- |
| 4987 | 5022 |
|
| ... | ... | |
| 5031 | 5066 |
|
| 5032 | 5067 |
|
| 5033 | 5068 |
-- |
| 5069 |
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5070 |
-- |
|
| 5071 |
|
|
| 5072 |
CREATE INDEX classcontributor_commclass_id_idx ON classcontributor (commclass_id); |
|
| 5073 |
|
|
| 5074 |
|
|
| 5075 |
-- |
|
| 5076 |
-- Name: classcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5077 |
-- |
|
| 5078 |
|
|
| 5079 |
CREATE INDEX classcontributor_party_id_idx ON classcontributor (party_id); |
|
| 5080 |
|
|
| 5081 |
|
|
| 5082 |
-- |
|
| 5034 | 5083 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5035 | 5084 |
-- |
| 5036 | 5085 |
|
| ... | ... | |
| 5038 | 5087 |
|
| 5039 | 5088 |
|
| 5040 | 5089 |
-- |
| 5090 |
-- Name: commclass_classpublication_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5091 |
-- |
|
| 5092 |
|
|
| 5093 |
CREATE INDEX commclass_classpublication_id_idx ON commclass (classpublication_id); |
|
| 5094 |
|
|
| 5095 |
|
|
| 5096 |
-- |
|
| 5041 | 5097 |
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5042 | 5098 |
-- |
| 5043 | 5099 |
|
| ... | ... | |
| 5052 | 5108 |
|
| 5053 | 5109 |
|
| 5054 | 5110 |
-- |
| 5111 |
-- Name: commconcept_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5112 |
-- |
|
| 5113 |
|
|
| 5114 |
CREATE INDEX commconcept_reference_id_idx ON commconcept (reference_id); |
|
| 5115 |
|
|
| 5116 |
|
|
| 5117 |
-- |
|
| 5118 |
-- Name: commcorrelation_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5119 |
-- |
|
| 5120 |
|
|
| 5121 |
CREATE INDEX commcorrelation_commconcept_id_idx ON commcorrelation (commconcept_id); |
|
| 5122 |
|
|
| 5123 |
|
|
| 5124 |
-- |
|
| 5125 |
-- Name: commcorrelation_commstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5126 |
-- |
|
| 5127 |
|
|
| 5128 |
CREATE INDEX commcorrelation_commstatus_id_idx ON commcorrelation (commstatus_id); |
|
| 5129 |
|
|
| 5130 |
|
|
| 5131 |
-- |
|
| 5132 |
-- Name: commdetermination_commauthority_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5133 |
-- |
|
| 5134 |
|
|
| 5135 |
CREATE INDEX commdetermination_commauthority_id_idx ON commdetermination (commauthority_id); |
|
| 5136 |
|
|
| 5137 |
|
|
| 5138 |
-- |
|
| 5139 |
-- Name: commdetermination_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5140 |
-- |
|
| 5141 |
|
|
| 5142 |
CREATE INDEX commdetermination_commconcept_id_idx ON commdetermination (commconcept_id); |
|
| 5143 |
|
|
| 5144 |
|
|
| 5145 |
-- |
|
| 5146 |
-- Name: commlineage_childcommstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5147 |
-- |
|
| 5148 |
|
|
| 5149 |
CREATE INDEX commlineage_childcommstatus_id_idx ON commlineage (childcommstatus_id); |
|
| 5150 |
|
|
| 5151 |
|
|
| 5152 |
-- |
|
| 5153 |
-- Name: commlineage_parentcommstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5154 |
-- |
|
| 5155 |
|
|
| 5156 |
CREATE INDEX commlineage_parentcommstatus_id_idx ON commlineage (parentcommstatus_id); |
|
| 5157 |
|
|
| 5158 |
|
|
| 5159 |
-- |
|
| 5160 |
-- Name: commname_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5161 |
-- |
|
| 5162 |
|
|
| 5163 |
CREATE INDEX commname_source_id_idx ON commname (source_id); |
|
| 5164 |
|
|
| 5165 |
|
|
| 5166 |
-- |
|
| 5055 | 5167 |
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5056 | 5168 |
-- |
| 5057 | 5169 |
|
| ... | ... | |
| 5059 | 5171 |
|
| 5060 | 5172 |
|
| 5061 | 5173 |
-- |
| 5174 |
-- Name: commstatus_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5175 |
-- |
|
| 5176 |
|
|
| 5177 |
CREATE INDEX commstatus_commconcept_id_idx ON commstatus (commconcept_id); |
|
| 5178 |
|
|
| 5179 |
|
|
| 5180 |
-- |
|
| 5181 |
-- Name: commstatus_commparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5182 |
-- |
|
| 5183 |
|
|
| 5184 |
CREATE INDEX commstatus_commparent_id_idx ON commstatus (commparent_id); |
|
| 5185 |
|
|
| 5186 |
|
|
| 5187 |
-- |
|
| 5188 |
-- Name: commstatus_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5189 |
-- |
|
| 5190 |
|
|
| 5191 |
CREATE INDEX commstatus_party_id_idx ON commstatus (party_id); |
|
| 5192 |
|
|
| 5193 |
|
|
| 5194 |
-- |
|
| 5195 |
-- Name: commstatus_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5196 |
-- |
|
| 5197 |
|
|
| 5198 |
CREATE INDEX commstatus_source_id_idx ON commstatus (source_id); |
|
| 5199 |
|
|
| 5200 |
|
|
| 5201 |
-- |
|
| 5202 |
-- Name: commusage_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5203 |
-- |
|
| 5204 |
|
|
| 5205 |
CREATE INDEX commusage_commconcept_id_idx ON commusage (commconcept_id); |
|
| 5206 |
|
|
| 5207 |
|
|
| 5208 |
-- |
|
| 5209 |
-- Name: commusage_commname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5210 |
-- |
|
| 5211 |
|
|
| 5212 |
CREATE INDEX commusage_commname_id_idx ON commusage (commname_id); |
|
| 5213 |
|
|
| 5214 |
|
|
| 5215 |
-- |
|
| 5216 |
-- Name: commusage_commstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5217 |
-- |
|
| 5218 |
|
|
| 5219 |
CREATE INDEX commusage_commstatus_id_idx ON commusage (commstatus_id); |
|
| 5220 |
|
|
| 5221 |
|
|
| 5222 |
-- |
|
| 5223 |
-- Name: commusage_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5224 |
-- |
|
| 5225 |
|
|
| 5226 |
CREATE INDEX commusage_party_id_idx ON commusage (party_id); |
|
| 5227 |
|
|
| 5228 |
|
|
| 5229 |
-- |
|
| 5062 | 5230 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5063 | 5231 |
-- |
| 5064 | 5232 |
|
| ... | ... | |
| 5066 | 5234 |
|
| 5067 | 5235 |
|
| 5068 | 5236 |
-- |
| 5237 |
-- Name: coverindex_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5238 |
-- |
|
| 5239 |
|
|
| 5240 |
CREATE INDEX coverindex_covermethod_id_idx ON coverindex (covermethod_id); |
|
| 5241 |
|
|
| 5242 |
|
|
| 5243 |
-- |
|
| 5069 | 5244 |
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5070 | 5245 |
-- |
| 5071 | 5246 |
|
| ... | ... | |
| 5073 | 5248 |
|
| 5074 | 5249 |
|
| 5075 | 5250 |
-- |
| 5251 |
-- Name: covermethod_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5252 |
-- |
|
| 5253 |
|
|
| 5254 |
CREATE INDEX covermethod_source_id_idx ON covermethod (source_id); |
|
| 5255 |
|
|
| 5256 |
|
|
| 5257 |
-- |
|
| 5258 |
-- Name: disturbanceobs_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5259 |
-- |
|
| 5260 |
|
|
| 5261 |
CREATE INDEX disturbanceobs_locationevent_id_idx ON disturbanceobs (locationevent_id); |
|
| 5262 |
|
|
| 5263 |
|
|
| 5264 |
-- |
|
| 5076 | 5265 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5077 | 5266 |
-- |
| 5078 | 5267 |
|
| ... | ... | |
| 5080 | 5269 |
|
| 5081 | 5270 |
|
| 5082 | 5271 |
-- |
| 5272 |
-- Name: graphic_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5273 |
-- |
|
| 5274 |
|
|
| 5275 |
CREATE INDEX graphic_locationevent_id_idx ON graphic (locationevent_id); |
|
| 5276 |
|
|
| 5277 |
|
|
| 5278 |
-- |
|
| 5083 | 5279 |
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5084 | 5280 |
-- |
| 5085 | 5281 |
|
| ... | ... | |
| 5143 | 5339 |
|
| 5144 | 5340 |
|
| 5145 | 5341 |
-- |
| 5342 |
-- Name: locationevent_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5343 |
-- |
|
| 5344 |
|
|
| 5345 |
CREATE INDEX locationevent_method_id_idx ON locationevent (method_id); |
|
| 5346 |
|
|
| 5347 |
|
|
| 5348 |
-- |
|
| 5349 |
-- Name: locationevent_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5350 |
-- |
|
| 5351 |
|
|
| 5352 |
CREATE INDEX locationevent_parent_id_idx ON locationevent (parent_id); |
|
| 5353 |
|
|
| 5354 |
|
|
| 5355 |
-- |
|
| 5356 |
-- Name: locationevent_previous_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5357 |
-- |
|
| 5358 |
|
|
| 5359 |
CREATE INDEX locationevent_previous_id_idx ON locationevent (previous_id); |
|
| 5360 |
|
|
| 5361 |
|
|
| 5362 |
-- |
|
| 5363 |
-- Name: locationevent_project_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5364 |
-- |
|
| 5365 |
|
|
| 5366 |
CREATE INDEX locationevent_project_id_idx ON locationevent (project_id); |
|
| 5367 |
|
|
| 5368 |
|
|
| 5369 |
-- |
|
| 5370 |
-- Name: locationevent_soiltaxon_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5371 |
-- |
|
| 5372 |
|
|
| 5373 |
CREATE INDEX locationevent_soiltaxon_id_idx ON locationevent (soiltaxon_id); |
|
| 5374 |
|
|
| 5375 |
|
|
| 5376 |
-- |
|
| 5146 | 5377 |
-- Name: locationevent_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5147 | 5378 |
-- |
| 5148 | 5379 |
|
| ... | ... | |
| 5185 | 5416 |
|
| 5186 | 5417 |
|
| 5187 | 5418 |
-- |
| 5419 |
-- Name: locationeventcontributor_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5420 |
-- |
|
| 5421 |
|
|
| 5422 |
CREATE INDEX locationeventcontributor_locationevent_id_idx ON locationeventcontributor (locationevent_id); |
|
| 5423 |
|
|
| 5424 |
|
|
| 5425 |
-- |
|
| 5426 |
-- Name: locationeventcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5427 |
-- |
|
| 5428 |
|
|
| 5429 |
CREATE INDEX locationeventcontributor_party_id_idx ON locationeventcontributor (party_id); |
|
| 5430 |
|
|
| 5431 |
|
|
| 5432 |
-- |
|
| 5188 | 5433 |
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5189 | 5434 |
-- |
| 5190 | 5435 |
|
| ... | ... | |
| 5192 | 5437 |
|
| 5193 | 5438 |
|
| 5194 | 5439 |
-- |
| 5440 |
-- Name: locationeventsynonym_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5441 |
-- |
|
| 5442 |
|
|
| 5443 |
CREATE INDEX locationeventsynonym_party_id_idx ON locationeventsynonym (party_id); |
|
| 5444 |
|
|
| 5445 |
|
|
| 5446 |
-- |
|
| 5447 |
-- Name: locationeventsynonym_primarylocationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5448 |
-- |
|
| 5449 |
|
|
| 5450 |
CREATE INDEX locationeventsynonym_primarylocationevent_id_idx ON locationeventsynonym (primarylocationevent_id); |
|
| 5451 |
|
|
| 5452 |
|
|
| 5453 |
-- |
|
| 5454 |
-- Name: locationeventsynonym_synonymlocationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5455 |
-- |
|
| 5456 |
|
|
| 5457 |
CREATE INDEX locationeventsynonym_synonymlocationevent_id_idx ON locationeventsynonym (synonymlocationevent_id); |
|
| 5458 |
|
|
| 5459 |
|
|
| 5460 |
-- |
|
| 5461 |
-- Name: locationplace_identifier_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5462 |
-- |
|
| 5463 |
|
|
| 5464 |
CREATE INDEX locationplace_identifier_id_idx ON locationplace (identifier_id); |
|
| 5465 |
|
|
| 5466 |
|
|
| 5467 |
-- |
|
| 5468 |
-- Name: locationplace_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5469 |
-- |
|
| 5470 |
|
|
| 5471 |
CREATE INDEX locationplace_place_id_idx ON locationplace (place_id); |
|
| 5472 |
|
|
| 5473 |
|
|
| 5474 |
-- |
|
| 5195 | 5475 |
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5196 | 5476 |
-- |
| 5197 | 5477 |
|
| ... | ... | |
| 5206 | 5486 |
|
| 5207 | 5487 |
|
| 5208 | 5488 |
-- |
| 5489 |
-- Name: method_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5490 |
-- |
|
| 5491 |
|
|
| 5492 |
CREATE INDEX method_covermethod_id_idx ON method (covermethod_id); |
|
| 5493 |
|
|
| 5494 |
|
|
| 5495 |
-- |
|
| 5496 |
-- Name: method_subplotmethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5497 |
-- |
|
| 5498 |
|
|
| 5499 |
CREATE INDEX method_subplotmethod_id_idx ON method (subplotmethod_id); |
|
| 5500 |
|
|
| 5501 |
|
|
| 5502 |
-- |
|
| 5209 | 5503 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5210 | 5504 |
-- |
| 5211 | 5505 |
|
| ... | ... | |
| 5213 | 5507 |
|
| 5214 | 5508 |
|
| 5215 | 5509 |
-- |
| 5510 |
-- Name: methodtaxonclass_submethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5511 |
-- |
|
| 5512 |
|
|
| 5513 |
CREATE INDEX methodtaxonclass_submethod_id_idx ON methodtaxonclass (submethod_id); |
|
| 5514 |
|
|
| 5515 |
|
|
| 5516 |
-- |
|
| 5517 |
-- Name: methodtaxonclass_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5518 |
-- |
|
| 5519 |
|
|
| 5520 |
CREATE INDEX methodtaxonclass_taxonlabel_id_idx ON methodtaxonclass (taxonlabel_id); |
|
| 5521 |
|
|
| 5522 |
|
|
| 5523 |
-- |
|
| 5216 | 5524 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5217 | 5525 |
-- |
| 5218 | 5526 |
|
| ... | ... | |
| 5220 | 5528 |
|
| 5221 | 5529 |
|
| 5222 | 5530 |
-- |
| 5531 |
-- Name: note_notelink_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5532 |
-- |
|
| 5533 |
|
|
| 5534 |
CREATE INDEX note_notelink_id_idx ON note (notelink_id); |
|
| 5535 |
|
|
| 5536 |
|
|
| 5537 |
-- |
|
| 5538 |
-- Name: note_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5539 |
-- |
|
| 5540 |
|
|
| 5541 |
CREATE INDEX note_party_id_idx ON note (party_id); |
|
| 5542 |
|
|
| 5543 |
|
|
| 5544 |
-- |
|
| 5223 | 5545 |
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5224 | 5546 |
-- |
| 5225 | 5547 |
|
| ... | ... | |
| 5227 | 5549 |
|
| 5228 | 5550 |
|
| 5229 | 5551 |
-- |
| 5552 |
-- Name: party_currentname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5553 |
-- |
|
| 5554 |
|
|
| 5555 |
CREATE INDEX party_currentname_id_idx ON party (currentname_id); |
|
| 5556 |
|
|
| 5557 |
|
|
| 5558 |
-- |
|
| 5230 | 5559 |
-- Name: party_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5231 | 5560 |
-- |
| 5232 | 5561 |
|
| ... | ... | |
| 5248 | 5577 |
|
| 5249 | 5578 |
|
| 5250 | 5579 |
-- |
| 5580 |
-- Name: partymember_childparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5581 |
-- |
|
| 5582 |
|
|
| 5583 |
CREATE INDEX partymember_childparty_id_idx ON partymember (childparty_id); |
|
| 5584 |
|
|
| 5585 |
|
|
| 5586 |
-- |
|
| 5587 |
-- Name: partymember_parentparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5588 |
-- |
|
| 5589 |
|
|
| 5590 |
CREATE INDEX partymember_parentparty_id_idx ON partymember (parentparty_id); |
|
| 5591 |
|
|
| 5592 |
|
|
| 5593 |
-- |
|
| 5594 |
-- Name: place_canon_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5595 |
-- |
|
| 5596 |
|
|
| 5597 |
CREATE INDEX place_canon_place_id_idx ON place (canon_place_id); |
|
| 5598 |
|
|
| 5599 |
|
|
| 5600 |
-- |
|
| 5601 |
-- Name: place_coordinates_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5602 |
-- |
|
| 5603 |
|
|
| 5604 |
CREATE INDEX place_coordinates_id_idx ON place (coordinates_id); |
|
| 5605 |
|
|
| 5606 |
|
|
| 5607 |
-- |
|
| 5251 | 5608 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5252 | 5609 |
-- |
| 5253 | 5610 |
|
| ... | ... | |
| 5262 | 5619 |
|
| 5263 | 5620 |
|
| 5264 | 5621 |
-- |
| 5622 |
-- Name: placecorrelation_childplace_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5623 |
-- |
|
| 5624 |
|
|
| 5625 |
CREATE INDEX placecorrelation_childplace_id_idx ON placecorrelation (childplace_id); |
|
| 5626 |
|
|
| 5627 |
|
|
| 5628 |
-- |
|
| 5629 |
-- Name: placecorrelation_parentplace_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5630 |
-- |
|
| 5631 |
|
|
| 5632 |
CREATE INDEX placecorrelation_parentplace_id_idx ON placecorrelation (parentplace_id); |
|
| 5633 |
|
|
| 5634 |
|
|
| 5635 |
-- |
|
| 5636 |
-- Name: placename_ancestor_ancestor_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5637 |
-- |
|
| 5638 |
|
|
| 5639 |
CREATE INDEX placename_ancestor_ancestor_id_idx ON placename_ancestor (ancestor_id); |
|
| 5640 |
|
|
| 5641 |
|
|
| 5642 |
-- |
|
| 5643 |
-- Name: placename_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5644 |
-- |
|
| 5645 |
|
|
| 5646 |
CREATE INDEX placename_parent_id_idx ON placename (parent_id); |
|
| 5647 |
|
|
| 5648 |
|
|
| 5649 |
-- |
|
| 5265 | 5650 |
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5266 | 5651 |
-- |
| 5267 | 5652 |
|
| ... | ... | |
| 5276 | 5661 |
|
| 5277 | 5662 |
|
| 5278 | 5663 |
-- |
| 5664 |
-- Name: plantobservation_plant_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5665 |
-- |
|
| 5666 |
|
|
| 5667 |
CREATE INDEX plantobservation_plant_id_idx ON plantobservation (plant_id); |
|
| 5668 |
|
|
| 5669 |
|
|
| 5670 |
-- |
|
| 5279 | 5671 |
-- Name: plantobservation_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5280 | 5672 |
-- |
| 5281 | 5673 |
|
| ... | ... | |
| 5318 | 5710 |
|
| 5319 | 5711 |
|
| 5320 | 5712 |
-- |
| 5713 |
-- Name: projectcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5714 |
-- |
|
| 5715 |
|
|
| 5716 |
CREATE INDEX projectcontributor_party_id_idx ON projectcontributor (party_id); |
|
| 5717 |
|
|
| 5718 |
|
|
| 5719 |
-- |
|
| 5720 |
-- Name: projectcontributor_project_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5721 |
-- |
|
| 5722 |
|
|
| 5723 |
CREATE INDEX projectcontributor_project_id_idx ON projectcontributor (project_id); |
|
| 5724 |
|
|
| 5725 |
|
|
| 5726 |
-- |
|
| 5727 |
-- Name: revision_previousrevision_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5728 |
-- |
|
| 5729 |
|
|
| 5730 |
CREATE INDEX revision_previousrevision_id_idx ON revision (previousrevision_id); |
|
| 5731 |
|
|
| 5732 |
|
|
| 5733 |
-- |
|
| 5321 | 5734 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5322 | 5735 |
-- |
| 5323 | 5736 |
|
| ... | ... | |
| 5325 | 5738 |
|
| 5326 | 5739 |
|
| 5327 | 5740 |
-- |
| 5741 |
-- Name: soiltaxon_soilparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5742 |
-- |
|
| 5743 |
|
|
| 5744 |
CREATE INDEX soiltaxon_soilparent_id_idx ON soiltaxon (soilparent_id); |
|
| 5745 |
|
|
| 5746 |
|
|
| 5747 |
-- |
|
| 5328 | 5748 |
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5329 | 5749 |
-- |
| 5330 | 5750 |
|
| ... | ... | |
| 5332 | 5752 |
|
| 5333 | 5753 |
|
| 5334 | 5754 |
-- |
| 5755 |
-- Name: source_matched_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5756 |
-- |
|
| 5757 |
|
|
| 5758 |
CREATE INDEX source_matched_source_id_idx ON source (matched_source_id); |
|
| 5759 |
|
|
| 5760 |
|
|
| 5761 |
-- |
|
| 5762 |
-- Name: source_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5763 |
-- |
|
| 5764 |
|
|
| 5765 |
CREATE INDEX source_parent_id_idx ON source (parent_id); |
|
| 5766 |
|
|
| 5767 |
|
|
| 5768 |
-- |
|
| 5335 | 5769 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5336 | 5770 |
-- |
| 5337 | 5771 |
|
| ... | ... | |
| 5339 | 5773 |
|
| 5340 | 5774 |
|
| 5341 | 5775 |
-- |
| 5776 |
-- Name: sourcecontributor_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5777 |
-- |
|
| 5778 |
|
|
| 5779 |
CREATE INDEX sourcecontributor_source_id_idx ON sourcecontributor (source_id); |
|
| 5780 |
|
|
| 5781 |
|
|
| 5782 |
-- |
|
| 5783 |
-- Name: sourcecontributor_sourceparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5784 |
-- |
|
| 5785 |
|
|
| 5786 |
CREATE INDEX sourcecontributor_sourceparty_id_idx ON sourcecontributor (sourceparty_id); |
|
| 5787 |
|
|
| 5788 |
|
|
| 5789 |
-- |
|
| 5342 | 5790 |
-- Name: sourcelist_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5343 | 5791 |
-- |
| 5344 | 5792 |
|
| ... | ... | |
| 5353 | 5801 |
|
| 5354 | 5802 |
|
| 5355 | 5803 |
-- |
| 5804 |
-- Name: specimenreplicate_institution_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5805 |
-- |
|
| 5806 |
|
|
| 5807 |
CREATE INDEX specimenreplicate_institution_id_idx ON specimenreplicate (institution_id); |
|
| 5808 |
|
|
| 5809 |
|
|
| 5810 |
-- |
|
| 5356 | 5811 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5357 | 5812 |
-- |
| 5358 | 5813 |
|
| ... | ... | |
| 5374 | 5829 |
|
| 5375 | 5830 |
|
| 5376 | 5831 |
-- |
| 5832 |
-- Name: specimenreplicate_specimen_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5833 |
-- |
|
| 5834 |
|
|
| 5835 |
CREATE INDEX specimenreplicate_specimen_id_idx ON specimenreplicate (specimen_id); |
|
| 5836 |
|
|
| 5837 |
|
|
| 5838 |
-- |
|
| 5377 | 5839 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5378 | 5840 |
-- |
| 5379 | 5841 |
|
| ... | ... | |
| 5423 | 5885 |
|
| 5424 | 5886 |
|
| 5425 | 5887 |
-- |
| 5888 |
-- Name: stratum_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5889 |
-- |
|
| 5890 |
|
|
| 5891 |
CREATE INDEX stratum_locationevent_id_idx ON stratum (locationevent_id); |
|
| 5892 |
|
|
| 5893 |
|
|
| 5894 |
-- |
|
| 5895 |
-- Name: stratum_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5896 |
-- |
|
| 5897 |
|
|
| 5898 |
CREATE INDEX stratum_method_id_idx ON stratum (method_id); |
|
| 5899 |
|
|
| 5900 |
|
|
| 5901 |
-- |
|
| 5426 | 5902 |
-- Name: taxon_trait_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5427 | 5903 |
-- |
| 5428 | 5904 |
|
| ... | ... | |
| 5430 | 5906 |
|
| 5431 | 5907 |
|
| 5432 | 5908 |
-- |
| 5909 |
-- Name: taxonalt_taxondetermination_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5910 |
-- |
|
| 5911 |
|
|
| 5912 |
CREATE INDEX taxonalt_taxondetermination_id_idx ON taxonalt (taxondetermination_id); |
|
| 5913 |
|
|
| 5914 |
|
|
| 5915 |
-- |
|
| 5916 |
-- Name: taxonalt_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5917 |
-- |
|
| 5918 |
|
|
| 5919 |
CREATE INDEX taxonalt_taxonlabel_id_idx ON taxonalt (taxonlabel_id); |
|
| 5920 |
|
|
| 5921 |
|
|
| 5922 |
-- |
|
| 5923 |
-- Name: taxonconcept_concept_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5924 |
-- |
|
| 5925 |
|
|
| 5926 |
CREATE INDEX taxonconcept_concept_reference_id_idx ON taxonconcept (concept_reference_id); |
|
| 5927 |
|
|
| 5928 |
|
|
| 5929 |
-- |
|
| 5930 |
-- Name: taxoncorrelation_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5931 |
-- |
|
| 5932 |
|
|
| 5933 |
CREATE INDEX taxoncorrelation_taxonlabel_id_idx ON taxoncorrelation (taxonlabel_id); |
|
| 5934 |
|
|
| 5935 |
|
|
| 5936 |
-- |
|
| 5937 |
-- Name: taxoncorrelation_taxonstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5938 |
-- |
|
| 5939 |
|
|
| 5940 |
CREATE INDEX taxoncorrelation_taxonstatus_id_idx ON taxoncorrelation (taxonstatus_id); |
|
| 5941 |
|
|
| 5942 |
|
|
| 5943 |
-- |
|
| 5433 | 5944 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5434 | 5945 |
-- |
| 5435 | 5946 |
|
| ... | ... | |
| 5437 | 5948 |
|
| 5438 | 5949 |
|
| 5439 | 5950 |
-- |
| 5951 |
-- Name: taxondetermination_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5952 |
-- |
|
| 5953 |
|
|
| 5954 |
CREATE INDEX taxondetermination_party_id_idx ON taxondetermination (party_id); |
|
| 5955 |
|
|
| 5956 |
|
|
| 5957 |
-- |
|
| 5440 | 5958 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5441 | 5959 |
-- |
| 5442 | 5960 |
|
| ... | ... | |
| 5451 | 5969 |
|
| 5452 | 5970 |
|
| 5453 | 5971 |
-- |
| 5972 |
-- Name: taxondetermination_taxonverbatim_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5973 |
-- |
|
| 5974 |
|
|
| 5975 |
CREATE INDEX taxondetermination_taxonverbatim_id_idx ON taxondetermination (taxonverbatim_id); |
|
| 5976 |
|
|
| 5977 |
|
|
| 5978 |
-- |
|
| 5454 | 5979 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5455 | 5980 |
-- |
| 5456 | 5981 |
|
| ... | ... | |
| 5479 | 6004 |
|
| 5480 | 6005 |
|
| 5481 | 6006 |
-- |
| 6007 |
-- Name: taxonlabel_canon_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6008 |
-- |
|
| 6009 |
|
|
| 6010 |
CREATE INDEX taxonlabel_canon_label_id_idx ON taxonlabel (canon_label_id); |
|
| 6011 |
|
|
| 6012 |
|
|
| 6013 |
-- |
|
| 5482 | 6014 |
-- Name: taxonlabel_matched_label_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5483 | 6015 |
-- |
| 5484 | 6016 |
|
| ... | ... | |
| 5486 | 6018 |
|
| 5487 | 6019 |
|
| 5488 | 6020 |
-- |
| 6021 |
-- Name: taxonlabel_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6022 |
-- |
|
| 6023 |
|
|
| 6024 |
CREATE INDEX taxonlabel_parent_id_idx ON taxonlabel (parent_id); |
|
| 6025 |
|
|
| 6026 |
|
|
| 6027 |
-- |
|
| 5489 | 6028 |
-- Name: taxonlabel_relationship_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5490 | 6029 |
-- |
| 5491 | 6030 |
|
| ... | ... | |
| 5507 | 6046 |
|
| 5508 | 6047 |
|
| 5509 | 6048 |
-- |
| 6049 |
-- Name: taxonlineage_childtaxonstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6050 |
-- |
|
| 6051 |
|
|
| 6052 |
CREATE INDEX taxonlineage_childtaxonstatus_id_idx ON taxonlineage (childtaxonstatus_id); |
|
| 6053 |
|
|
| 6054 |
|
|
| 6055 |
-- |
|
| 6056 |
-- Name: taxonlineage_parenttaxonstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6057 |
-- |
|
| 6058 |
|
|
| 6059 |
CREATE INDEX taxonlineage_parenttaxonstatus_id_idx ON taxonlineage (parenttaxonstatus_id); |
|
| 6060 |
|
|
| 6061 |
|
|
| 6062 |
-- |
|
| 5510 | 6063 |
-- Name: taxonoccurrence_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5511 | 6064 |
-- |
| 5512 | 6065 |
|
| ... | ... | |
| 5514 | 6067 |
|
| 5515 | 6068 |
|
| 5516 | 6069 |
-- |
| 6070 |
-- Name: taxonoccurrence_collector_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6071 |
-- |
|
| 6072 |
|
|
| 6073 |
CREATE INDEX taxonoccurrence_collector_id_idx ON taxonoccurrence (collector_id); |
|
| 6074 |
|
|
| 6075 |
|
|
| 6076 |
-- |
|
| 5517 | 6077 |
-- Name: taxonoccurrence_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5518 | 6078 |
-- |
| 5519 | 6079 |
|
| ... | ... | |
| 5549 | 6109 |
|
| 5550 | 6110 |
|
| 5551 | 6111 |
-- |
| 6112 |
-- Name: taxonstatus_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6113 |
-- |
|
| 6114 |
|
|
| 6115 |
CREATE INDEX taxonstatus_party_id_idx ON taxonstatus (party_id); |
|
| 6116 |
|
|
| 6117 |
|
|
| 6118 |
-- |
|
| 6119 |
-- Name: taxonstatus_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6120 |
-- |
|
| 6121 |
|
|
| 6122 |
CREATE INDEX taxonstatus_source_id_idx ON taxonstatus (source_id); |
|
| 6123 |
|
|
| 6124 |
|
|
| 6125 |
-- |
|
| 6126 |
-- Name: telephone_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6127 |
-- |
|
| 6128 |
|
|
| 6129 |
CREATE INDEX telephone_party_id_idx ON telephone (party_id); |
|
| 6130 |
|
|
| 6131 |
|
|
| 6132 |
-- |
|
| 5552 | 6133 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5553 | 6134 |
-- |
| 5554 | 6135 |
|
| ... | ... | |
| 5563 | 6144 |
|
| 5564 | 6145 |
|
| 5565 | 6146 |
-- |
| 6147 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6148 |
-- |
|
| 6149 |
|
|
| 6150 |
CREATE INDEX voucher_specimenreplicate_id_idx ON voucher (specimenreplicate_id); |
|
| 6151 |
|
|
| 6152 |
|
|
| 6153 |
-- |
|
| 5566 | 6154 |
-- Name: party_source_id_self_ref; Type: TRIGGER; Schema: public; Owner: - |
| 5567 | 6155 |
-- |
| 5568 | 6156 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 6088 | 6088 |
|
| 6089 | 6089 |
|
| 6090 | 6090 |
-- |
| 6091 |
-- Name: address_organization_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6092 |
-- |
|
| 6093 |
|
|
| 6094 |
CREATE INDEX address_organization_id_idx ON address USING btree (organization_id); |
|
| 6095 |
|
|
| 6096 |
|
|
| 6097 |
-- |
|
| 6098 |
-- Name: address_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6099 |
-- |
|
| 6100 |
|
|
| 6101 |
CREATE INDEX address_party_id_idx ON address USING btree (party_id); |
|
| 6102 |
|
|
| 6103 |
|
|
| 6104 |
-- |
|
| 6105 |
-- Name: aggregateoccurrence_coverindex_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6106 |
-- |
|
| 6107 |
|
|
| 6108 |
CREATE INDEX aggregateoccurrence_coverindex_id_idx ON aggregateoccurrence USING btree (coverindex_id); |
|
| 6109 |
|
|
| 6110 |
|
|
| 6111 |
-- |
|
| 6112 |
-- Name: aggregateoccurrence_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6113 |
-- |
|
| 6114 |
|
|
| 6115 |
CREATE INDEX aggregateoccurrence_method_id_idx ON aggregateoccurrence USING btree (method_id); |
|
| 6116 |
|
|
| 6117 |
|
|
| 6118 |
-- |
|
| 6091 | 6119 |
-- Name: aggregateoccurrence_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6092 | 6120 |
-- |
| 6093 | 6121 |
|
| ... | ... | |
| 6095 | 6123 |
|
| 6096 | 6124 |
|
| 6097 | 6125 |
-- |
| 6126 |
-- Name: aggregateoccurrence_stratum_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6127 |
-- |
|
| 6128 |
|
|
| 6129 |
CREATE INDEX aggregateoccurrence_stratum_id_idx ON aggregateoccurrence USING btree (stratum_id); |
|
| 6130 |
|
|
| 6131 |
|
|
| 6132 |
-- |
|
| 6098 | 6133 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6099 | 6134 |
-- |
| 6100 | 6135 |
|
| ... | ... | |
| 6144 | 6179 |
|
| 6145 | 6180 |
|
| 6146 | 6181 |
-- |
| 6182 |
-- Name: classcontributor_commclass_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6183 |
-- |
|
| 6184 |
|
|
| 6185 |
CREATE INDEX classcontributor_commclass_id_idx ON classcontributor USING btree (commclass_id); |
|
| 6186 |
|
|
| 6187 |
|
|
| 6188 |
-- |
|
| 6189 |
-- Name: classcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6190 |
-- |
|
| 6191 |
|
|
| 6192 |
CREATE INDEX classcontributor_party_id_idx ON classcontributor USING btree (party_id); |
|
| 6193 |
|
|
| 6194 |
|
|
| 6195 |
-- |
|
| 6147 | 6196 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6148 | 6197 |
-- |
| 6149 | 6198 |
|
| ... | ... | |
| 6151 | 6200 |
|
| 6152 | 6201 |
|
| 6153 | 6202 |
-- |
| 6203 |
-- Name: commclass_classpublication_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6204 |
-- |
|
| 6205 |
|
|
| 6206 |
CREATE INDEX commclass_classpublication_id_idx ON commclass USING btree (classpublication_id); |
|
| 6207 |
|
|
| 6208 |
|
|
| 6209 |
-- |
|
| 6154 | 6210 |
-- Name: commclass_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6155 | 6211 |
-- |
| 6156 | 6212 |
|
| ... | ... | |
| 6165 | 6221 |
|
| 6166 | 6222 |
|
| 6167 | 6223 |
-- |
| 6224 |
-- Name: commconcept_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6225 |
-- |
|
| 6226 |
|
|
| 6227 |
CREATE INDEX commconcept_reference_id_idx ON commconcept USING btree (reference_id); |
|
| 6228 |
|
|
| 6229 |
|
|
| 6230 |
-- |
|
| 6231 |
-- Name: commcorrelation_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6232 |
-- |
|
| 6233 |
|
|
| 6234 |
CREATE INDEX commcorrelation_commconcept_id_idx ON commcorrelation USING btree (commconcept_id); |
|
| 6235 |
|
|
| 6236 |
|
|
| 6237 |
-- |
|
| 6238 |
-- Name: commcorrelation_commstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6239 |
-- |
|
| 6240 |
|
|
| 6241 |
CREATE INDEX commcorrelation_commstatus_id_idx ON commcorrelation USING btree (commstatus_id); |
|
| 6242 |
|
|
| 6243 |
|
|
| 6244 |
-- |
|
| 6245 |
-- Name: commdetermination_commauthority_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6246 |
-- |
|
| 6247 |
|
|
| 6248 |
CREATE INDEX commdetermination_commauthority_id_idx ON commdetermination USING btree (commauthority_id); |
|
| 6249 |
|
|
| 6250 |
|
|
| 6251 |
-- |
|
| 6252 |
-- Name: commdetermination_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6253 |
-- |
|
| 6254 |
|
|
| 6255 |
CREATE INDEX commdetermination_commconcept_id_idx ON commdetermination USING btree (commconcept_id); |
|
| 6256 |
|
|
| 6257 |
|
|
| 6258 |
-- |
|
| 6259 |
-- Name: commlineage_childcommstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6260 |
-- |
|
| 6261 |
|
|
| 6262 |
CREATE INDEX commlineage_childcommstatus_id_idx ON commlineage USING btree (childcommstatus_id); |
|
| 6263 |
|
|
| 6264 |
|
|
| 6265 |
-- |
|
| 6266 |
-- Name: commlineage_parentcommstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6267 |
-- |
|
| 6268 |
|
|
| 6269 |
CREATE INDEX commlineage_parentcommstatus_id_idx ON commlineage USING btree (parentcommstatus_id); |
|
| 6270 |
|
|
| 6271 |
|
|
| 6272 |
-- |
|
| 6273 |
-- Name: commname_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6274 |
-- |
|
| 6275 |
|
|
| 6276 |
CREATE INDEX commname_source_id_idx ON commname USING btree (source_id); |
|
| 6277 |
|
|
| 6278 |
|
|
| 6279 |
-- |
|
| 6168 | 6280 |
-- Name: commstatus_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6169 | 6281 |
-- |
| 6170 | 6282 |
|
| ... | ... | |
| 6172 | 6284 |
|
| 6173 | 6285 |
|
| 6174 | 6286 |
-- |
| 6287 |
-- Name: commstatus_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6288 |
-- |
|
| 6289 |
|
|
| 6290 |
CREATE INDEX commstatus_commconcept_id_idx ON commstatus USING btree (commconcept_id); |
|
| 6291 |
|
|
| 6292 |
|
|
| 6293 |
-- |
|
| 6294 |
-- Name: commstatus_commparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6295 |
-- |
|
| 6296 |
|
|
| 6297 |
CREATE INDEX commstatus_commparent_id_idx ON commstatus USING btree (commparent_id); |
|
| 6298 |
|
|
| 6299 |
|
|
| 6300 |
-- |
|
| 6301 |
-- Name: commstatus_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6302 |
-- |
|
| 6303 |
|
|
| 6304 |
CREATE INDEX commstatus_party_id_idx ON commstatus USING btree (party_id); |
|
| 6305 |
|
|
| 6306 |
|
|
| 6307 |
-- |
|
| 6308 |
-- Name: commstatus_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6309 |
-- |
|
| 6310 |
|
|
| 6311 |
CREATE INDEX commstatus_source_id_idx ON commstatus USING btree (source_id); |
|
| 6312 |
|
|
| 6313 |
|
|
| 6314 |
-- |
|
| 6315 |
-- Name: commusage_commconcept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6316 |
-- |
|
| 6317 |
|
|
| 6318 |
CREATE INDEX commusage_commconcept_id_idx ON commusage USING btree (commconcept_id); |
|
| 6319 |
|
|
| 6320 |
|
|
| 6321 |
-- |
|
| 6322 |
-- Name: commusage_commname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6323 |
-- |
|
| 6324 |
|
|
| 6325 |
CREATE INDEX commusage_commname_id_idx ON commusage USING btree (commname_id); |
|
| 6326 |
|
|
| 6327 |
|
|
| 6328 |
-- |
|
| 6329 |
-- Name: commusage_commstatus_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6330 |
-- |
|
| 6331 |
|
|
| 6332 |
CREATE INDEX commusage_commstatus_id_idx ON commusage USING btree (commstatus_id); |
|
| 6333 |
|
|
| 6334 |
|
|
| 6335 |
-- |
|
| 6336 |
-- Name: commusage_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6337 |
-- |
|
| 6338 |
|
|
| 6339 |
CREATE INDEX commusage_party_id_idx ON commusage USING btree (party_id); |
|
| 6340 |
|
|
| 6341 |
|
|
| 6342 |
-- |
|
| 6175 | 6343 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6176 | 6344 |
-- |
| 6177 | 6345 |
|
| ... | ... | |
| 6179 | 6347 |
|
| 6180 | 6348 |
|
| 6181 | 6349 |
-- |
| 6350 |
-- Name: coverindex_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6351 |
-- |
|
| 6352 |
|
|
| 6353 |
CREATE INDEX coverindex_covermethod_id_idx ON coverindex USING btree (covermethod_id); |
|
| 6354 |
|
|
| 6355 |
|
|
| 6356 |
-- |
|
| 6182 | 6357 |
-- Name: covermethod_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6183 | 6358 |
-- |
| 6184 | 6359 |
|
| ... | ... | |
| 6186 | 6361 |
|
| 6187 | 6362 |
|
| 6188 | 6363 |
-- |
| 6364 |
-- Name: covermethod_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6365 |
-- |
|
| 6366 |
|
|
| 6367 |
CREATE INDEX covermethod_source_id_idx ON covermethod USING btree (source_id); |
|
| 6368 |
|
|
| 6369 |
|
|
| 6370 |
-- |
|
| 6371 |
-- Name: disturbanceobs_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6372 |
-- |
|
| 6373 |
|
|
| 6374 |
CREATE INDEX disturbanceobs_locationevent_id_idx ON disturbanceobs USING btree (locationevent_id); |
|
| 6375 |
|
|
| 6376 |
|
|
| 6377 |
-- |
|
| 6189 | 6378 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6190 | 6379 |
-- |
| 6191 | 6380 |
|
| ... | ... | |
| 6193 | 6382 |
|
| 6194 | 6383 |
|
| 6195 | 6384 |
-- |
| 6385 |
-- Name: graphic_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6386 |
-- |
|
| 6387 |
|
|
| 6388 |
CREATE INDEX graphic_locationevent_id_idx ON graphic USING btree (locationevent_id); |
|
| 6389 |
|
|
| 6390 |
|
|
| 6391 |
-- |
|
| 6196 | 6392 |
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6197 | 6393 |
-- |
| 6198 | 6394 |
|
| ... | ... | |
| 6256 | 6452 |
|
| 6257 | 6453 |
|
| 6258 | 6454 |
-- |
| 6455 |
-- Name: locationevent_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6456 |
-- |
|
| 6457 |
|
|
| 6458 |
CREATE INDEX locationevent_method_id_idx ON locationevent USING btree (method_id); |
|
| 6459 |
|
|
| 6460 |
|
|
| 6461 |
-- |
|
| 6462 |
-- Name: locationevent_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6463 |
-- |
|
| 6464 |
|
|
| 6465 |
CREATE INDEX locationevent_parent_id_idx ON locationevent USING btree (parent_id); |
|
| 6466 |
|
|
| 6467 |
|
|
| 6468 |
-- |
|
| 6469 |
-- Name: locationevent_previous_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6470 |
-- |
|
| 6471 |
|
|
| 6472 |
CREATE INDEX locationevent_previous_id_idx ON locationevent USING btree (previous_id); |
|
| 6473 |
|
|
| 6474 |
|
|
| 6475 |
-- |
|
| 6476 |
-- Name: locationevent_project_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6477 |
-- |
|
| 6478 |
|
|
| 6479 |
CREATE INDEX locationevent_project_id_idx ON locationevent USING btree (project_id); |
|
| 6480 |
|
|
| 6481 |
|
|
| 6482 |
-- |
|
| 6483 |
-- Name: locationevent_soiltaxon_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6484 |
-- |
|
| 6485 |
|
|
| 6486 |
CREATE INDEX locationevent_soiltaxon_id_idx ON locationevent USING btree (soiltaxon_id); |
|
| 6487 |
|
|
| 6488 |
|
|
| 6489 |
-- |
|
| 6259 | 6490 |
-- Name: locationevent_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6260 | 6491 |
-- |
| 6261 | 6492 |
|
| ... | ... | |
| 6298 | 6529 |
|
| 6299 | 6530 |
|
| 6300 | 6531 |
-- |
| 6532 |
-- Name: locationeventcontributor_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6533 |
-- |
|
| 6534 |
|
|
| 6535 |
CREATE INDEX locationeventcontributor_locationevent_id_idx ON locationeventcontributor USING btree (locationevent_id); |
|
| 6536 |
|
|
| 6537 |
|
|
| 6538 |
-- |
|
| 6539 |
-- Name: locationeventcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6540 |
-- |
|
| 6541 |
|
|
| 6542 |
CREATE INDEX locationeventcontributor_party_id_idx ON locationeventcontributor USING btree (party_id); |
|
| 6543 |
|
|
| 6544 |
|
|
| 6545 |
-- |
|
| 6301 | 6546 |
-- Name: locationeventsynonym_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6302 | 6547 |
-- |
| 6303 | 6548 |
|
| ... | ... | |
| 6305 | 6550 |
|
| 6306 | 6551 |
|
| 6307 | 6552 |
-- |
| 6553 |
-- Name: locationeventsynonym_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6554 |
-- |
|
| 6555 |
|
|
| 6556 |
CREATE INDEX locationeventsynonym_party_id_idx ON locationeventsynonym USING btree (party_id); |
|
| 6557 |
|
|
| 6558 |
|
|
| 6559 |
-- |
|
| 6560 |
-- Name: locationeventsynonym_primarylocationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6561 |
-- |
|
| 6562 |
|
|
| 6563 |
CREATE INDEX locationeventsynonym_primarylocationevent_id_idx ON locationeventsynonym USING btree (primarylocationevent_id); |
|
| 6564 |
|
|
| 6565 |
|
|
| 6566 |
-- |
|
| 6567 |
-- Name: locationeventsynonym_synonymlocationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6568 |
-- |
|
| 6569 |
|
|
| 6570 |
CREATE INDEX locationeventsynonym_synonymlocationevent_id_idx ON locationeventsynonym USING btree (synonymlocationevent_id); |
|
| 6571 |
|
|
| 6572 |
|
|
| 6573 |
-- |
|
| 6574 |
-- Name: locationplace_identifier_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6575 |
-- |
|
| 6576 |
|
|
| 6577 |
CREATE INDEX locationplace_identifier_id_idx ON locationplace USING btree (identifier_id); |
|
| 6578 |
|
|
| 6579 |
|
|
| 6580 |
-- |
|
| 6581 |
-- Name: locationplace_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6582 |
-- |
|
| 6583 |
|
|
| 6584 |
CREATE INDEX locationplace_place_id_idx ON locationplace USING btree (place_id); |
|
| 6585 |
|
|
| 6586 |
|
|
| 6587 |
-- |
|
| 6308 | 6588 |
-- Name: locationplace_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6309 | 6589 |
-- |
| 6310 | 6590 |
|
| ... | ... | |
| 6319 | 6599 |
|
| 6320 | 6600 |
|
| 6321 | 6601 |
-- |
| 6602 |
-- Name: method_covermethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6603 |
-- |
|
| 6604 |
|
|
| 6605 |
CREATE INDEX method_covermethod_id_idx ON method USING btree (covermethod_id); |
|
| 6606 |
|
|
| 6607 |
|
|
| 6608 |
-- |
|
| 6609 |
-- Name: method_subplotmethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6610 |
-- |
|
| 6611 |
|
|
| 6612 |
CREATE INDEX method_subplotmethod_id_idx ON method USING btree (subplotmethod_id); |
|
| 6613 |
|
|
| 6614 |
|
|
| 6615 |
-- |
|
| 6322 | 6616 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6323 | 6617 |
-- |
| 6324 | 6618 |
|
| ... | ... | |
| 6326 | 6620 |
|
| 6327 | 6621 |
|
| 6328 | 6622 |
-- |
| 6623 |
-- Name: methodtaxonclass_submethod_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6624 |
-- |
|
| 6625 |
|
|
| 6626 |
CREATE INDEX methodtaxonclass_submethod_id_idx ON methodtaxonclass USING btree (submethod_id); |
|
| 6627 |
|
|
| 6628 |
|
|
| 6629 |
-- |
|
| 6630 |
-- Name: methodtaxonclass_taxonlabel_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6631 |
-- |
|
| 6632 |
|
|
| 6633 |
CREATE INDEX methodtaxonclass_taxonlabel_id_idx ON methodtaxonclass USING btree (taxonlabel_id); |
|
| 6634 |
|
|
| 6635 |
|
|
| 6636 |
-- |
|
| 6329 | 6637 |
-- Name: note_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6330 | 6638 |
-- |
| 6331 | 6639 |
|
| ... | ... | |
| 6333 | 6641 |
|
| 6334 | 6642 |
|
| 6335 | 6643 |
-- |
| 6644 |
-- Name: note_notelink_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6645 |
-- |
|
| 6646 |
|
|
| 6647 |
CREATE INDEX note_notelink_id_idx ON note USING btree (notelink_id); |
|
| 6648 |
|
|
| 6649 |
|
|
| 6650 |
-- |
|
| 6651 |
-- Name: note_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6652 |
-- |
|
| 6653 |
|
|
| 6654 |
CREATE INDEX note_party_id_idx ON note USING btree (party_id); |
|
| 6655 |
|
|
| 6656 |
|
|
| 6657 |
-- |
|
| 6336 | 6658 |
-- Name: party_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6337 | 6659 |
-- |
| 6338 | 6660 |
|
| ... | ... | |
| 6340 | 6662 |
|
| 6341 | 6663 |
|
| 6342 | 6664 |
-- |
| 6665 |
-- Name: party_currentname_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6666 |
-- |
|
| 6667 |
|
|
| 6668 |
CREATE INDEX party_currentname_id_idx ON party USING btree (currentname_id); |
|
| 6669 |
|
|
| 6670 |
|
|
| 6671 |
-- |
|
| 6343 | 6672 |
-- Name: party_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6344 | 6673 |
-- |
| 6345 | 6674 |
|
| ... | ... | |
| 6361 | 6690 |
|
| 6362 | 6691 |
|
| 6363 | 6692 |
-- |
| 6693 |
-- Name: partymember_childparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6694 |
-- |
|
| 6695 |
|
|
| 6696 |
CREATE INDEX partymember_childparty_id_idx ON partymember USING btree (childparty_id); |
|
| 6697 |
|
|
| 6698 |
|
|
| 6699 |
-- |
|
| 6700 |
-- Name: partymember_parentparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6701 |
-- |
|
| 6702 |
|
|
| 6703 |
CREATE INDEX partymember_parentparty_id_idx ON partymember USING btree (parentparty_id); |
|
| 6704 |
|
|
| 6705 |
|
|
| 6706 |
-- |
|
| 6707 |
-- Name: place_canon_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6708 |
-- |
|
| 6709 |
|
|
| 6710 |
CREATE INDEX place_canon_place_id_idx ON place USING btree (canon_place_id); |
|
| 6711 |
|
|
| 6712 |
|
|
| 6713 |
-- |
|
| 6714 |
-- Name: place_coordinates_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6715 |
-- |
|
| 6716 |
|
|
| 6717 |
CREATE INDEX place_coordinates_id_idx ON place USING btree (coordinates_id); |
|
| 6718 |
|
|
| 6719 |
|
|
| 6720 |
-- |
|
| 6364 | 6721 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6365 | 6722 |
-- |
| 6366 | 6723 |
|
| ... | ... | |
| 6375 | 6732 |
|
| 6376 | 6733 |
|
| 6377 | 6734 |
-- |
| 6735 |
-- Name: placecorrelation_childplace_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6736 |
-- |
|
| 6737 |
|
|
| 6738 |
CREATE INDEX placecorrelation_childplace_id_idx ON placecorrelation USING btree (childplace_id); |
|
| 6739 |
|
|
| 6740 |
|
|
| 6741 |
-- |
|
| 6742 |
-- Name: placecorrelation_parentplace_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6743 |
-- |
|
| 6744 |
|
|
| 6745 |
CREATE INDEX placecorrelation_parentplace_id_idx ON placecorrelation USING btree (parentplace_id); |
|
| 6746 |
|
|
| 6747 |
|
|
| 6748 |
-- |
|
| 6749 |
-- Name: placename_ancestor_ancestor_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6750 |
-- |
|
| 6751 |
|
|
| 6752 |
CREATE INDEX placename_ancestor_ancestor_id_idx ON placename_ancestor USING btree (ancestor_id); |
|
| 6753 |
|
|
| 6754 |
|
|
| 6755 |
-- |
|
| 6756 |
-- Name: placename_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6757 |
-- |
|
| 6758 |
|
|
| 6759 |
CREATE INDEX placename_parent_id_idx ON placename USING btree (parent_id); |
|
| 6760 |
|
|
| 6761 |
|
|
| 6762 |
-- |
|
| 6378 | 6763 |
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6379 | 6764 |
-- |
| 6380 | 6765 |
|
| ... | ... | |
| 6389 | 6774 |
|
| 6390 | 6775 |
|
| 6391 | 6776 |
-- |
| 6777 |
-- Name: plantobservation_plant_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6778 |
-- |
|
| 6779 |
|
|
| 6780 |
CREATE INDEX plantobservation_plant_id_idx ON plantobservation USING btree (plant_id); |
|
| 6781 |
|
|
| 6782 |
|
|
| 6783 |
-- |
|
| 6392 | 6784 |
-- Name: plantobservation_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6393 | 6785 |
-- |
| 6394 | 6786 |
|
| ... | ... | |
| 6431 | 6823 |
|
| 6432 | 6824 |
|
| 6433 | 6825 |
-- |
| 6826 |
-- Name: projectcontributor_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6827 |
-- |
|
| 6828 |
|
|
| 6829 |
CREATE INDEX projectcontributor_party_id_idx ON projectcontributor USING btree (party_id); |
|
| 6830 |
|
|
| 6831 |
|
|
| 6832 |
-- |
|
| 6833 |
-- Name: projectcontributor_project_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6834 |
-- |
|
| 6835 |
|
|
| 6836 |
CREATE INDEX projectcontributor_project_id_idx ON projectcontributor USING btree (project_id); |
|
| 6837 |
|
|
| 6838 |
|
|
| 6839 |
-- |
|
| 6840 |
-- Name: revision_previousrevision_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6841 |
-- |
|
| 6842 |
|
|
| 6843 |
CREATE INDEX revision_previousrevision_id_idx ON revision USING btree (previousrevision_id); |
|
| 6844 |
|
|
| 6845 |
|
|
| 6846 |
-- |
|
| 6434 | 6847 |
-- Name: soiltaxon_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6435 | 6848 |
-- |
| 6436 | 6849 |
|
| ... | ... | |
| 6438 | 6851 |
|
| 6439 | 6852 |
|
| 6440 | 6853 |
-- |
| 6854 |
-- Name: soiltaxon_soilparent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6855 |
-- |
|
| 6856 |
|
|
| 6857 |
CREATE INDEX soiltaxon_soilparent_id_idx ON soiltaxon USING btree (soilparent_id); |
|
| 6858 |
|
|
| 6859 |
|
|
| 6860 |
-- |
|
| 6441 | 6861 |
-- Name: source_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6442 | 6862 |
-- |
| 6443 | 6863 |
|
| ... | ... | |
| 6445 | 6865 |
|
| 6446 | 6866 |
|
| 6447 | 6867 |
-- |
| 6868 |
-- Name: source_matched_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6869 |
-- |
|
| 6870 |
|
|
| 6871 |
CREATE INDEX source_matched_source_id_idx ON source USING btree (matched_source_id); |
|
| 6872 |
|
|
| 6873 |
|
|
| 6874 |
-- |
|
| 6875 |
-- Name: source_parent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6876 |
-- |
|
| 6877 |
|
|
| 6878 |
CREATE INDEX source_parent_id_idx ON source USING btree (parent_id); |
|
| 6879 |
|
|
| 6880 |
|
|
| 6881 |
-- |
|
| 6448 | 6882 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6449 | 6883 |
-- |
| 6450 | 6884 |
|
| ... | ... | |
| 6452 | 6886 |
|
| 6453 | 6887 |
|
| 6454 | 6888 |
-- |
| 6889 |
-- Name: sourcecontributor_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6890 |
-- |
|
| 6891 |
|
|
| 6892 |
CREATE INDEX sourcecontributor_source_id_idx ON sourcecontributor USING btree (source_id); |
|
| 6893 |
|
|
| 6894 |
|
|
| 6895 |
-- |
|
| 6896 |
-- Name: sourcecontributor_sourceparty_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6897 |
-- |
|
| 6898 |
|
|
| 6899 |
CREATE INDEX sourcecontributor_sourceparty_id_idx ON sourcecontributor USING btree (sourceparty_id); |
|
| 6900 |
|
|
| 6901 |
|
|
| 6902 |
-- |
|
| 6455 | 6903 |
-- Name: sourcelist_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6456 | 6904 |
-- |
| 6457 | 6905 |
|
| ... | ... | |
| 6466 | 6914 |
|
| 6467 | 6915 |
|
| 6468 | 6916 |
-- |
| 6917 |
-- Name: specimenreplicate_institution_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6918 |
-- |
|
| 6919 |
|
|
| 6920 |
CREATE INDEX specimenreplicate_institution_id_idx ON specimenreplicate USING btree (institution_id); |
|
| 6921 |
|
|
| 6922 |
|
|
| 6923 |
-- |
|
| 6469 | 6924 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6470 | 6925 |
-- |
| 6471 | 6926 |
|
| ... | ... | |
| 6487 | 6942 |
|
| 6488 | 6943 |
|
| 6489 | 6944 |
-- |
| 6945 |
-- Name: specimenreplicate_specimen_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6946 |
-- |
|
| 6947 |
|
|
| 6948 |
CREATE INDEX specimenreplicate_specimen_id_idx ON specimenreplicate USING btree (specimen_id); |
|
| 6949 |
|
|
| 6950 |
|
|
| 6951 |
-- |
|
| 6490 | 6952 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6491 | 6953 |
-- |
| 6492 | 6954 |
|
| ... | ... | |
| 6536 | 6998 |
|
| 6537 | 6999 |
|
| 6538 | 7000 |
-- |
| 7001 |
-- Name: stratum_locationevent_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7002 |
-- |
|
| 7003 |
|
|
| 7004 |
CREATE INDEX stratum_locationevent_id_idx ON stratum USING btree (locationevent_id); |
|
| 7005 |
|
|
| 7006 |
|
|
| 7007 |
-- |
|
| 7008 |
-- Name: stratum_method_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7009 |
-- |
|
| 7010 |
|
|
| 7011 |
CREATE INDEX stratum_method_id_idx ON stratum USING btree (method_id); |
|
| 7012 |
|
|
| 7013 |
|
|
| 7014 |
-- |
|
| 6539 | 7015 |
-- Name: taxon_trait_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
Also available in: Unified diff
schemas/vegbien.sql: Added covering indexes where needed, as described at <https://projects.nceas.ucsb.edu/nceas/issues/549>