Revision 5278
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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