Revision 4943
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 |
canon_taxonpath_id integer,
|
|
| 1119 | 1119 |
taxon_id integer, |
| 1120 | 1120 |
scientificname text, |
| 1121 | 1121 |
scientificnameauthor text, |
| ... | ... | |
| 5654 | 5654 |
|
| 5655 | 5655 |
|
| 5656 | 5656 |
-- |
| 5657 |
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5657 |
-- Name: taxonpath_canon_taxonpath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5658 | 5658 |
-- |
| 5659 | 5659 |
|
| 5660 | 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;
|
|
| 5661 |
ADD CONSTRAINT taxonpath_canon_taxonpath_id_fkey FOREIGN KEY (canon_taxonpath_id) REFERENCES taxonpath(taxonpath_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5662 | 5662 |
|
| 5663 | 5663 |
|
| 5664 | 5664 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonpath: Renamed canon_id to canon_taxonpath_id to clarify that this is a recursive fkey. The convention is that a recursive fkey includes the table name plus a descriptive prefix.