diff db_schema/stammdaten_schema.sql @ 1208:9dda1237c756

Add missing FK constraint.
author Tom Gottfried <tom@intevation.de>
date Mon, 05 Dec 2016 12:20:10 +0100
parents 289edf060550
children df75a467d55a
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Fri Dec 02 20:22:56 2016 +0100
+++ b/db_schema/stammdaten_schema.sql	Mon Dec 05 12:20:10 2016 +0100
@@ -166,7 +166,7 @@
 
 CREATE TABLE verwaltungsgrenze (
     id serial PRIMARY KEY,
-    gem_id character varying(8) NOT NULL,
+    gem_id character varying(8) NOT NULL REFERENCES verwaltungseinheit,
     shape public.geometry(MultiPolygon, 4326)
 );
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)