Revision 4941
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 831 | 831 |
taxonpath_id int(11) NOT NULL, |
| 832 | 832 |
datasource_id int(11) NOT NULL, |
| 833 | 833 |
plantcode text, |
| 834 |
canon_id int(11), |
|
| 834 | 835 |
taxon_id int(11), |
| 835 | 836 |
scientificname text, |
| 836 | 837 |
scientificnameauthor text, |
| ... | ... | |
| 5025 | 5026 |
|
| 5026 | 5027 |
|
| 5027 | 5028 |
-- |
| 5029 |
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5030 |
-- |
|
| 5031 |
|
|
| 5032 |
|
|
| 5033 |
|
|
| 5034 |
|
|
| 5035 |
-- |
|
| 5028 | 5036 |
-- Name: taxonpath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5029 | 5037 |
-- |
| 5030 | 5038 |
|
| schemas/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