Revision 8566
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 743 | 743 |
-- ----------------------------------------------------- |
| 744 | 744 |
CREATE TABLE IF NOT EXISTS `geovalidation` ( |
| 745 | 745 |
`id` TEXT NOT NULL , |
| 746 |
`place_path` TEXT NOT NULL , |
|
| 747 |
`coordinates` TEXT NOT NULL , |
|
| 748 | 746 |
PRIMARY KEY (`id`) , |
| 749 |
INDEX `fk_geovalidation_coordinates1` (`coordinates` ASC) , |
|
| 750 |
INDEX `fk_geovalidation_placename1` (`place_path` ASC) , |
|
| 751 | 747 |
CONSTRAINT `fk_geovalidation_record1` |
| 752 | 748 |
FOREIGN KEY (`id` ) |
| 753 | 749 |
REFERENCES `record` (`id` ) |
| 754 | 750 |
ON DELETE CASCADE |
| 755 | 751 |
ON UPDATE CASCADE, |
| 756 |
CONSTRAINT `fk_geovalidation_coordinates1` |
|
| 757 |
FOREIGN KEY (`coordinates` ) |
|
| 758 |
REFERENCES `coordinates` (`id` ) |
|
| 759 |
ON DELETE CASCADE |
|
| 760 |
ON UPDATE CASCADE, |
|
| 761 |
CONSTRAINT `fk_geovalidation_placename1` |
|
| 762 |
FOREIGN KEY (`place_path` ) |
|
| 752 |
CONSTRAINT `fk_geovalidation_place_path1` |
|
| 753 |
FOREIGN KEY (`id` ) |
|
| 763 | 754 |
REFERENCES `place_path` (`id` ) |
| 764 | 755 |
ON DELETE CASCADE |
| 765 | 756 |
ON UPDATE CASCADE) |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: made geovalidation extend place_path instead of being pointed to by it, because it provides a set of optional fields a (geovalidated) place_path may have