Project

General

Profile

« Previous | Next » 

Revision 10465

schemas/VegCore/VegCore.ERD.mwb: plot, subplot: added hstore extenders (dimensions, coordinates)

View differences:

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