Revision 5983
Added by Aaron Marcuse-Kubitza about 12 years ago
| 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