Revision 5278
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 794 | 794 |
taxonname text, |
| 795 | 795 |
rank text, |
| 796 | 796 |
verbatimrank text, |
| 797 |
taxon_id int(11), |
|
| 798 | 797 |
taxonomicname text, |
| 799 | 798 |
author text, |
| 800 | 799 |
taxonomicnamewithauthor text, |
| ... | ... | |
| 872 | 871 |
|
| 873 | 872 |
|
| 874 | 873 |
-- |
| 875 |
-- Name: COLUMN taxonconcept.taxon_id; Type: COMMENT; Schema: public; Owner: - |
|
| 876 |
-- |
|
| 877 |
|
|
| 878 |
|
|
| 879 |
|
|
| 880 |
|
|
| 881 |
-- |
|
| 882 | 874 |
-- Name: COLUMN taxonconcept.taxonomicname; Type: COMMENT; Schema: public; Owner: - |
| 883 | 875 |
-- |
| 884 | 876 |
|
| ... | ... | |
| 5134 | 5126 |
|
| 5135 | 5127 |
|
| 5136 | 5128 |
-- |
| 5137 |
-- Name: taxonconcept_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5138 |
-- |
|
| 5139 |
|
|
| 5140 |
ALTER TABLE taxonconcept |
|
| 5141 |
ADD CONSTRAINT taxonconcept_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5142 |
|
|
| 5143 |
|
|
| 5144 |
-- |
|
| 5145 | 5129 |
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5146 | 5130 |
-- |
| 5147 | 5131 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Removed taxon_id, since taxonconcept now contains all the information needed to represent a taxonomic hierarchy, including both conceptual and nomenclature information