Revision 10475
Added by Aaron Marcuse-Kubitza almost 11 years ago
VegCore.pg.sql | ||
---|---|---|
270 | 270 |
PRIMARY KEY ("id"), |
271 | 271 |
/*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true), |
272 | 272 |
/*KEY "fk_geovalidation_geoplace2_idx" ("scrubbed_geoplace")*/CHECK (true), |
273 |
/*CONSTRAINT "fk_geovalidation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
273 | 274 |
/*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
274 | 275 |
/*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
275 | 276 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/; |
Also available in: Unified diff
bugfix: schemas/VegCore/VegCore.ERD.mwb: geovalidation: need to inherit from record now that this is source-specific