Revision 5983
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1009 | 1009 |
place_id int(11) NOT NULL, |
| 1010 | 1010 |
reference_id int(11) NOT NULL, |
| 1011 | 1011 |
placecode text, |
| 1012 |
canon_place_id int(11), |
|
| 1012 | 1013 |
matched_place_id int(11), |
| 1013 | 1014 |
coordinates_id int(11), |
| 1014 | 1015 |
placename_id int(11), |
| ... | ... | |
| 4922 | 4923 |
|
| 4923 | 4924 |
|
| 4924 | 4925 |
-- |
| 4926 |
-- Name: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4927 |
-- |
|
| 4928 |
|
|
| 4929 |
|
|
| 4930 |
|
|
| 4931 |
|
|
| 4932 |
-- |
|
| 4925 | 4933 |
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4926 | 4934 |
-- |
| 4927 | 4935 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 2 | 2 |
,,"fkeys to heavily-linked tables" |
| 3 | 3 |
"^ALTER TABLE (?:commclass)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES \b[^;]*;",,outward |
| 4 | 4 |
"^ALTER TABLE (?:taxoncorrelation|taxonlineage)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES taxonlabel\b[^;]*;",,inward |
| 5 |
"^ALTER TABLE (?:place)\b[^;]*\bFOREIGN KEY\b[^;]*\(canon_place_id\) REFERENCES place\b[^;]*;",,inward |
|
| 5 | 6 |
"^ALTER TABLE (?:taxonlabel)\b[^;]*\bFOREIGN KEY\b[^;]*\(canon_label_id\) REFERENCES taxonlabel\b[^;]*;",,inward |
| 6 | 7 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES coverindex\b[^;]*;",,inward |
| 7 | 8 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| schemas/vegbien.sql | ||
|---|---|---|
| 1562 | 1562 |
place_id integer NOT NULL, |
| 1563 | 1563 |
reference_id integer NOT NULL, |
| 1564 | 1564 |
placecode text, |
| 1565 |
canon_place_id integer, |
|
| 1565 | 1566 |
matched_place_id integer, |
| 1566 | 1567 |
coordinates_id integer, |
| 1567 | 1568 |
placename_id integer, |
| ... | ... | |
| 5814 | 5815 |
|
| 5815 | 5816 |
|
| 5816 | 5817 |
-- |
| 5818 |
-- Name: place_canon_place_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5819 |
-- |
|
| 5820 |
|
|
| 5821 |
ALTER TABLE ONLY place |
|
| 5822 |
ADD CONSTRAINT place_canon_place_id_fkey FOREIGN KEY (canon_place_id) REFERENCES place(place_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5823 |
|
|
| 5824 |
|
|
| 5825 |
-- |
|
| 5817 | 5826 |
-- Name: place_coordinates_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5818 | 5827 |
-- |
| 5819 | 5828 |
|
Also available in: Unified diff
schemas/vegbien.sql: place: Added canon_place_id