Revision 4970
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 634 | 634 |
placepath_id int(11) NOT NULL, |
| 635 | 635 |
datasource_id int(11) NOT NULL, |
| 636 | 636 |
placecode text, |
| 637 |
canon_placepath_id int(11), |
|
| 637 | 638 |
place_id int(11), |
| 638 | 639 |
continent text, |
| 639 | 640 |
country text, |
| ... | ... | |
| 653 | 654 |
|
| 654 | 655 |
|
| 655 | 656 |
-- |
| 657 |
-- Name: COLUMN placepath.canon_placepath_id; Type: COMMENT; Schema: public; Owner: - |
|
| 658 |
-- |
|
| 659 |
|
|
| 660 |
|
|
| 661 |
|
|
| 662 |
|
|
| 663 |
-- |
|
| 656 | 664 |
-- Name: COLUMN placepath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 657 | 665 |
-- |
| 658 | 666 |
|
| ... | ... | |
| 4669 | 4677 |
|
| 4670 | 4678 |
|
| 4671 | 4679 |
-- |
| 4680 |
-- Name: placepath_canon_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4681 |
-- |
|
| 4682 |
|
|
| 4683 |
ALTER TABLE placepath |
|
| 4684 |
ADD CONSTRAINT placepath_canon_placepath_id_fkey FOREIGN KEY (canon_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4685 |
|
|
| 4686 |
|
|
| 4687 |
-- |
|
| 4672 | 4688 |
-- Name: placepath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4673 | 4689 |
-- |
| 4674 | 4690 |
|
Also available in: Unified diff
schemas/vegbien.sql: placepath: Added canon_placepath_id, analogous to taxonpath.canon_taxonpath_id