Revision 1050
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2265 | 2265 |
sourceaccessioncode text, |
| 2266 | 2266 |
accessioncode text, |
| 2267 | 2267 |
taxonoccurrence_id int(11) NOT NULL, |
| 2268 |
verbatimcollectorname text, |
|
| 2269 | 2268 |
collectionnumber text, |
| 2270 | 2269 |
specimen_id int(11), |
| 2271 | 2270 |
description text |
| ... | ... | |
| 2465 | 2464 |
CREATE TABLE taxonoccurrence ( |
| 2466 | 2465 |
taxonoccurrence_id int(11) NOT NULL, |
| 2467 | 2466 |
locationevent_id int(11), |
| 2468 |
authorplantname text, |
|
| 2469 |
reference_id int(11), |
|
| 2470 | 2467 |
emb_taxonoccurrence int(11), |
| 2471 |
accessioncode text |
|
| 2468 |
accessioncode text, |
|
| 2469 |
verbatimcollectorname text |
|
| 2472 | 2470 |
); |
| 2473 | 2471 |
|
| 2474 | 2472 |
|
| ... | ... | |
| 5597 | 5595 |
|
| 5598 | 5596 |
|
| 5599 | 5597 |
-- |
| 5600 |
-- Name: taxonoccurrence_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5601 |
-- |
|
| 5602 |
|
|
| 5603 |
CREATE INDEX taxonoccurrence_reference_id_x ON taxonoccurrence (reference_id); |
|
| 5604 |
|
|
| 5605 |
|
|
| 5606 |
-- |
|
| 5607 | 5598 |
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5608 | 5599 |
-- |
| 5609 | 5600 |
|
| ... | ... | |
| 6622 | 6613 |
|
| 6623 | 6614 |
|
| 6624 | 6615 |
-- |
| 6625 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6626 |
-- |
|
| 6627 |
|
|
| 6628 |
|
|
| 6629 |
|
|
| 6630 |
|
|
| 6631 |
-- |
|
| 6632 | 6616 |
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6633 | 6617 |
-- |
| 6634 | 6618 |
|
Also available in: Unified diff
VegBIEN: Moved specimenreplicate.verbatimcollectorname to taxonoccurrence since it can also apply to aggregateoccurrences. Removed no longer needed taxonoccurrence fields which are now in taxondetermination.