Revision 10465
Added by Aaron Marcuse-Kubitza almost 11 years ago
VegCore.pg.sql | ||
---|---|---|
513 | 513 |
"shape" text DEFAULT NULL, |
514 | 514 |
"bounding_box_rect" text DEFAULT NULL, |
515 | 515 |
"footprint_geom_WKT" text DEFAULT NULL, |
516 |
"dimensions" hstore DEFAULT NULL, |
|
516 | 517 |
PRIMARY KEY ("id"), |
517 | 518 |
/*CONSTRAINT "fk_subplot_place1" FOREIGN KEY ("id") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
518 | 519 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
... | ... | |
847 | 848 |
"id" text NOT NULL, |
848 | 849 |
"x_m" double precision DEFAULT NULL, |
849 | 850 |
"y_m" double precision DEFAULT NULL, |
851 |
"coordinates" hstore DEFAULT NULL, |
|
850 | 852 |
PRIMARY KEY ("id"), |
851 | 853 |
/*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
852 | 854 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"subplot, line, or any other subsample or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot)'*/; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: plot, subplot: added hstore extenders (dimensions, coordinates)