Revision 4941
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 1115 | 1115 |
taxonpath_id integer NOT NULL, |
| 1116 | 1116 |
datasource_id integer NOT NULL, |
| 1117 | 1117 |
plantcode text, |
| 1118 |
canon_id integer, |
|
| 1118 | 1119 |
taxon_id integer, |
| 1119 | 1120 |
scientificname text, |
| 1120 | 1121 |
scientificnameauthor text, |
| ... | ... | |
| 5653 | 5654 |
|
| 5654 | 5655 |
|
| 5655 | 5656 |
-- |
| 5657 |
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5658 |
-- |
|
| 5659 |
|
|
| 5660 |
ALTER TABLE ONLY taxonpath |
|
| 5661 |
ADD CONSTRAINT taxonpath_canon_id_fkey FOREIGN KEY (canon_id) REFERENCES taxonpath(taxonpath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5662 |
|
|
| 5663 |
|
|
| 5664 |
-- |
|
| 5656 | 5665 |
-- Name: taxonpath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5657 | 5666 |
-- |
| 5658 | 5667 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonpath: Added canon_id for the canonical (scrubbed) taxonpath determined by TNRS