Revision 1050
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2601 | 2601 |
sourceaccessioncode text, |
| 2602 | 2602 |
accessioncode text, |
| 2603 | 2603 |
taxonoccurrence_id integer NOT NULL, |
| 2604 |
verbatimcollectorname text, |
|
| 2605 | 2604 |
collectionnumber text, |
| 2606 | 2605 |
specimen_id integer, |
| 2607 | 2606 |
description text |
| ... | ... | |
| 2826 | 2825 |
CREATE TABLE taxonoccurrence ( |
| 2827 | 2826 |
taxonoccurrence_id integer NOT NULL, |
| 2828 | 2827 |
locationevent_id integer, |
| 2829 |
authorplantname text, |
|
| 2830 |
reference_id integer, |
|
| 2831 | 2828 |
emb_taxonoccurrence integer, |
| 2832 |
accessioncode text |
|
| 2829 |
accessioncode text, |
|
| 2830 |
verbatimcollectorname text |
|
| 2833 | 2831 |
); |
| 2834 | 2832 |
|
| 2835 | 2833 |
|
| ... | ... | |
| 6043 | 6041 |
|
| 6044 | 6042 |
|
| 6045 | 6043 |
-- |
| 6046 |
-- Name: taxonoccurrence_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6047 |
-- |
|
| 6048 |
|
|
| 6049 |
CREATE INDEX taxonoccurrence_reference_id_x ON taxonoccurrence USING btree (reference_id); |
|
| 6050 |
|
|
| 6051 |
|
|
| 6052 |
-- |
|
| 6053 | 6044 |
-- Name: telephone_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6054 | 6045 |
-- |
| 6055 | 6046 |
|
| ... | ... | |
| 7096 | 7087 |
|
| 7097 | 7088 |
|
| 7098 | 7089 |
-- |
| 7099 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7100 |
-- |
|
| 7101 |
|
|
| 7102 |
ALTER TABLE ONLY taxonoccurrence |
|
| 7103 |
ADD CONSTRAINT taxonoccurrence_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7104 |
|
|
| 7105 |
|
|
| 7106 |
-- |
|
| 7107 | 7090 |
-- Name: telephone_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7108 | 7091 |
-- |
| 7109 | 7092 |
|
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.