Revision 553
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2574 | 2574 |
int_currplantscinamenoauth character varying(255), |
| 2575 | 2575 |
int_currplantcommon character varying(255), |
| 2576 | 2576 |
int_currplantcode character varying(255), |
| 2577 |
accessioncode character varying(255) |
|
| 2577 |
accessioncode character varying(255), |
|
| 2578 |
currentdetermination_id integer, |
|
| 2579 |
originaldetermination_id integer |
|
| 2578 | 2580 |
); |
| 2579 | 2581 |
|
| 2580 | 2582 |
|
| ... | ... | |
| 4976 | 4978 |
|
| 4977 | 4979 |
|
| 4978 | 4980 |
-- |
| 4981 |
-- Name: fki_taxonoccurrence_currentdetermination_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4982 |
-- |
|
| 4983 |
|
|
| 4984 |
CREATE INDEX fki_taxonoccurrence_currentdetermination_id ON taxonoccurrence USING btree (currentdetermination_id); |
|
| 4985 |
|
|
| 4986 |
|
|
| 4987 |
-- |
|
| 4979 | 4988 |
-- Name: graphic_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4980 | 4989 |
-- |
| 4981 | 4990 |
|
| ... | ... | |
| 6594 | 6603 |
|
| 6595 | 6604 |
|
| 6596 | 6605 |
-- |
| 6606 |
-- Name: taxonoccurrence_currentdetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6607 |
-- |
|
| 6608 |
|
|
| 6609 |
ALTER TABLE ONLY taxonoccurrence |
|
| 6610 |
ADD CONSTRAINT taxonoccurrence_currentdetermination_id FOREIGN KEY (currentdetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6611 |
|
|
| 6612 |
|
|
| 6613 |
-- |
|
| 6597 | 6614 |
-- Name: taxonoccurrence_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6598 | 6615 |
-- |
| 6599 | 6616 |
|
| ... | ... | |
| 6602 | 6619 |
|
| 6603 | 6620 |
|
| 6604 | 6621 |
-- |
| 6622 |
-- Name: taxonoccurrence_originaldetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6623 |
-- |
|
| 6624 |
|
|
| 6625 |
ALTER TABLE ONLY taxonoccurrence |
|
| 6626 |
ADD CONSTRAINT taxonoccurrence_originaldetermination_id FOREIGN KEY (originaldetermination_id) REFERENCES taxondetermination(taxondetermination_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6627 |
|
|
| 6628 |
|
|
| 6629 |
-- |
|
| 6605 | 6630 |
-- Name: taxonoccurrence_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6606 | 6631 |
-- |
| 6607 | 6632 |
|
Also available in: Unified diff
vegbien.sql: Added taxonoccurrence.currentdetermination_id and originaldetermination_id