Revision 7054
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 6088 | 6088 |
|
| 6089 | 6089 |
|
| 6090 | 6090 |
-- |
| 6091 |
-- Name: aggregateoccurrence_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6092 |
-- |
|
| 6093 |
|
|
| 6094 |
CREATE INDEX aggregateoccurrence_source_id_idx ON aggregateoccurrence USING btree (source_id); |
|
| 6095 |
|
|
| 6096 |
|
|
| 6097 |
-- |
|
| 6091 | 6098 |
-- Name: aggregateoccurrence_taxonoccurrence; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6092 | 6099 |
-- |
| 6093 | 6100 |
|
| ... | ... | |
| 6249 | 6256 |
|
| 6250 | 6257 |
|
| 6251 | 6258 |
-- |
| 6259 |
-- Name: locationevent_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6260 |
-- |
|
| 6261 |
|
|
| 6262 |
CREATE INDEX locationevent_source_id_idx ON locationevent USING btree (source_id); |
|
| 6263 |
|
|
| 6264 |
|
|
| 6265 |
-- |
|
| 6252 | 6266 |
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6253 | 6267 |
-- |
| 6254 | 6268 |
|
| ... | ... | |
| 6326 | 6340 |
|
| 6327 | 6341 |
|
| 6328 | 6342 |
-- |
| 6343 |
-- Name: party_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6344 |
-- |
|
| 6345 |
|
|
| 6346 |
CREATE INDEX party_source_id_idx ON party USING btree (source_id); |
|
| 6347 |
|
|
| 6348 |
|
|
| 6349 |
-- |
|
| 6329 | 6350 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6330 | 6351 |
-- |
| 6331 | 6352 |
|
| ... | ... | |
| 6368 | 6389 |
|
| 6369 | 6390 |
|
| 6370 | 6391 |
-- |
| 6392 |
-- Name: plantobservation_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6393 |
-- |
|
| 6394 |
|
|
| 6395 |
CREATE INDEX plantobservation_source_id_idx ON plantobservation USING btree (source_id); |
|
| 6396 |
|
|
| 6397 |
|
|
| 6398 |
-- |
|
| 6371 | 6399 |
-- Name: plantobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6372 | 6400 |
-- |
| 6373 | 6401 |
|
| ... | ... | |
| 6382 | 6410 |
|
| 6383 | 6411 |
|
| 6384 | 6412 |
-- |
| 6413 |
-- Name: project_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6414 |
-- |
|
| 6415 |
|
|
| 6416 |
CREATE INDEX project_source_id_idx ON project USING btree (source_id); |
|
| 6417 |
|
|
| 6418 |
|
|
| 6419 |
-- |
|
| 6385 | 6420 |
-- Name: project_unique_name_date; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6386 | 6421 |
-- |
| 6387 | 6422 |
|
| ... | ... | |
| 6424 | 6459 |
|
| 6425 | 6460 |
|
| 6426 | 6461 |
-- |
| 6462 |
-- Name: sourcename_matched_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6463 |
-- |
|
| 6464 |
|
|
| 6465 |
CREATE INDEX sourcename_matched_source_id_idx ON sourcename USING btree (matched_source_id); |
|
| 6466 |
|
|
| 6467 |
|
|
| 6468 |
-- |
|
| 6427 | 6469 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6428 | 6470 |
-- |
| 6429 | 6471 |
|
| ... | ... | |
| 6438 | 6480 |
|
| 6439 | 6481 |
|
| 6440 | 6482 |
-- |
| 6483 |
-- Name: specimenreplicate_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6484 |
-- |
|
| 6485 |
|
|
| 6486 |
CREATE INDEX specimenreplicate_source_id_idx ON specimenreplicate USING btree (source_id); |
|
| 6487 |
|
|
| 6488 |
|
|
| 6489 |
-- |
|
| 6441 | 6490 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6442 | 6491 |
-- |
| 6443 | 6492 |
|
| ... | ... | |
| 6466 | 6515 |
|
| 6467 | 6516 |
|
| 6468 | 6517 |
-- |
| 6518 |
-- Name: stemobservation_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6519 |
-- |
|
| 6520 |
|
|
| 6521 |
CREATE INDEX stemobservation_source_id_idx ON stemobservation USING btree (source_id); |
|
| 6522 |
|
|
| 6523 |
|
|
| 6524 |
-- |
|
| 6469 | 6525 |
-- Name: stemobservation_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6470 | 6526 |
-- |
| 6471 | 6527 |
|
| ... | ... | |
| 6501 | 6557 |
|
| 6502 | 6558 |
|
| 6503 | 6559 |
-- |
| 6560 |
-- Name: taxondetermination_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6561 |
-- |
|
| 6562 |
|
|
| 6563 |
CREATE INDEX taxondetermination_source_id_idx ON taxondetermination USING btree (source_id); |
|
| 6564 |
|
|
| 6565 |
|
|
| 6566 |
-- |
|
| 6504 | 6567 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6505 | 6568 |
-- |
| 6506 | 6569 |
|
| ... | ... | |
| 6543 | 6606 |
|
| 6544 | 6607 |
|
| 6545 | 6608 |
-- |
| 6609 |
-- Name: taxonlabel_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6610 |
-- |
|
| 6611 |
|
|
| 6612 |
CREATE INDEX taxonlabel_source_id_idx ON taxonlabel USING btree (source_id); |
|
| 6613 |
|
|
| 6614 |
|
|
| 6615 |
-- |
|
| 6546 | 6616 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6547 | 6617 |
-- |
| 6548 | 6618 |
|
| ... | ... | |
| 6564 | 6634 |
|
| 6565 | 6635 |
|
| 6566 | 6636 |
-- |
| 6637 |
-- Name: taxonoccurrence_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6638 |
-- |
|
| 6639 |
|
|
| 6640 |
CREATE INDEX taxonoccurrence_source_id_idx ON taxonoccurrence USING btree (source_id); |
|
| 6641 |
|
|
| 6642 |
|
|
| 6643 |
-- |
|
| 6567 | 6644 |
-- Name: taxonoccurrence_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6568 | 6645 |
-- |
| 6569 | 6646 |
|
Also available in: Unified diff
schemas/vegbien.sql: fkeys to source: Added covering indexes where needed, as described at <https://projects.nceas.ucsb.edu/nceas/issues/549>