Revision 5278
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1172 | 1172 |
taxonname text, |
| 1173 | 1173 |
rank taxonrank, |
| 1174 | 1174 |
verbatimrank text, |
| 1175 |
taxon_id integer, |
|
| 1176 | 1175 |
taxonomicname text, |
| 1177 | 1176 |
author text, |
| 1178 | 1177 |
taxonomicnamewithauthor text, |
| ... | ... | |
| 1261 | 1260 |
|
| 1262 | 1261 |
|
| 1263 | 1262 |
-- |
| 1264 |
-- Name: COLUMN taxonconcept.taxon_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1265 |
-- |
|
| 1266 |
|
|
| 1267 |
COMMENT ON COLUMN taxonconcept.taxon_id IS 'The corresponding taxon in the tree of life. Only used for parsed names.'; |
|
| 1268 |
|
|
| 1269 |
|
|
| 1270 |
-- |
|
| 1271 | 1263 |
-- Name: COLUMN taxonconcept.taxonomicname; Type: COMMENT; Schema: public; Owner: - |
| 1272 | 1264 |
-- |
| 1273 | 1265 |
|
| ... | ... | |
| 5871 | 5863 |
|
| 5872 | 5864 |
|
| 5873 | 5865 |
-- |
| 5874 |
-- Name: taxonconcept_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5875 |
-- |
|
| 5876 |
|
|
| 5877 |
ALTER TABLE ONLY taxonconcept |
|
| 5878 |
ADD CONSTRAINT taxonconcept_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5879 |
|
|
| 5880 |
|
|
| 5881 |
-- |
|
| 5882 | 5866 |
-- Name: taxondetermination_party_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5883 | 5867 |
-- |
| 5884 | 5868 |
|
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