Revision 10462
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 510 | 510 |
"id" text NOT NULL, |
| 511 | 511 |
"name" text DEFAULT NULL, |
| 512 | 512 |
"area_m2" double precision DEFAULT NULL, |
| 513 |
"bounding_box" text DEFAULT NULL, |
|
| 513 |
"bounding_box_WKT" text DEFAULT NULL, |
|
| 514 |
"footprint_geom_WKT" text DEFAULT NULL, |
|
| 514 | 515 |
PRIMARY KEY ("id"),
|
| 515 | 516 |
/*CONSTRAINT "fk_subplot_place1" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 516 | 517 |
) /*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).