Revision 10474
Added by Aaron Marcuse-Kubitza almost 11 years ago
VegCore.pg.sql | ||
---|---|---|
262 | 262 |
/*!40101 SET character_set_client = utf8 */; |
263 | 263 |
CREATE TABLE "geovalidation" ( |
264 | 264 |
"id" text NOT NULL, |
265 |
"input_geoplace" text NOT NULL, |
|
266 |
"scrubbed_geoplace" text NOT NULL, |
|
265 | 267 |
"geovalid" integer NOT NULL, |
266 | 268 |
"lat_long_domain_valid" integer NOT NULL, |
267 | 269 |
"lat_long_in_place_ranks" hstore DEFAULT NULL, |
268 | 270 |
PRIMARY KEY ("id"), |
269 |
/*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
271 |
/*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true), |
|
272 |
/*KEY "fk_geovalidation_geoplace2_idx" ("scrubbed_geoplace")*/CHECK (true), |
|
273 |
/*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
274 |
/*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
270 | 275 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/; |
271 | 276 |
/*!40101 SET character_set_client = @saved_cs_client */; |
272 | 277 |
|
Also available in: Unified diff
bugfix: schemas/VegCore/VegCore.ERD.mwb: geovalidation: HAVE-AN input geoplace rather than BEING-ONE, to allow multiple geovalidations for a geoplace by different sources