Revision 4943
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 |
canon_taxonpath_id int(11),
|
|
| 835 | 835 |
taxon_id int(11), |
| 836 | 836 |
scientificname text, |
| 837 | 837 |
scientificnameauthor text, |
| ... | ... | |
| 5026 | 5026 |
|
| 5027 | 5027 |
|
| 5028 | 5028 |
-- |
| 5029 |
-- Name: taxonpath_canon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5029 |
-- Name: taxonpath_canon_taxonpath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5030 | 5030 |
-- |
| 5031 | 5031 |
|
| 5032 | 5032 |
ALTER TABLE taxonpath |
| 5033 |
ADD CONSTRAINT taxonpath_canon_id_fkey FOREIGN KEY (canon_id) REFERENCES taxonpath(taxonpath_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5033 |
ADD CONSTRAINT taxonpath_canon_taxonpath_id_fkey FOREIGN KEY (canon_taxonpath_id) REFERENCES taxonpath(taxonpath_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5034 | 5034 |
|
| 5035 | 5035 |
|
| 5036 | 5036 |
-- |
| 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 |
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.