Revision 10462
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 508 | 508 |
`id` varbinary(767) NOT NULL, |
| 509 | 509 |
`name` varbinary(767) DEFAULT NULL, |
| 510 | 510 |
`area_m2` double DEFAULT NULL, |
| 511 |
`bounding_box` varbinary(767) DEFAULT NULL, |
|
| 511 |
`bounding_box_WKT` varbinary(767) DEFAULT NULL, |
|
| 512 |
`footprint_geom_WKT` varbinary(767) DEFAULT NULL, |
|
| 512 | 513 |
PRIMARY KEY (`id`), |
| 513 | 514 |
CONSTRAINT `fk_subplot_place1` FOREIGN KEY (`id`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 514 | 515 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: plot: added footprint_geom_WKT. bounding_box: added units (WKT).