Revision 5228
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 786 | 786 |
cultivar text, |
| 787 | 787 |
morphospecies text, |
| 788 | 788 |
otherranks text, |
| 789 |
scope_id int(11),
|
|
| 789 |
concept_reference_id int(11),
|
|
| 790 | 790 |
accessioncode text |
| 791 | 791 |
); |
| 792 | 792 |
|
| ... | ... | |
| 939 | 939 |
|
| 940 | 940 |
|
| 941 | 941 |
-- |
| 942 |
-- Name: COLUMN taxonconcept.scope_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 942 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 943 | 943 |
-- |
| 944 | 944 |
|
| 945 | 945 |
|
| ... | ... | |
| 5076 | 5076 |
|
| 5077 | 5077 |
|
| 5078 | 5078 |
-- |
| 5079 |
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5079 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5080 | 5080 |
-- |
| 5081 | 5081 |
|
| 5082 |
ALTER TABLE taxonconcept |
|
| 5083 |
ADD CONSTRAINT taxonconcept_concept_reference_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES taxonscope(taxonscope_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5082 | 5084 |
|
| 5083 | 5085 |
|
| 5084 |
|
|
| 5085 | 5086 |
-- |
| 5086 |
-- Name: taxonconcept_scope_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5087 |
-- Name: taxonconcept_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5087 | 5088 |
-- |
| 5088 | 5089 |
|
| 5089 |
ALTER TABLE taxonconcept |
|
| 5090 |
ADD CONSTRAINT taxonconcept_scope_id_fkey FOREIGN KEY (scope_id) REFERENCES taxonscope(taxonscope_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5091 | 5090 |
|
| 5092 | 5091 |
|
| 5092 |
|
|
| 5093 | 5093 |
-- |
| 5094 | 5094 |
-- Name: taxonconcept_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5095 | 5095 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed scope_id -> concept_reference_id as part of taxonomic schema refactoring at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/2012-10-03_conference_call#Taxonomic-schema-refactoring>