changeset 1208:9dda1237c756

Add missing FK constraint.
author Tom Gottfried <tom@intevation.de>
date Mon, 05 Dec 2016 12:20:10 +0100
parents 6692b3bdc49d
children df75a467d55a
files db_schema/stammdaten_schema.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
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)