diff db_schema/stammdaten_schema.sql @ 968:69b954343acc

Add missing FK-constraint.
author Tom Gottfried <tom@intevation.de>
date Thu, 02 Jun 2016 18:04:44 +0200
parents ad69878b7280
children 35878d9b4321
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Thu Jun 02 11:43:16 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Thu Jun 02 18:04:44 2016 +0200
@@ -140,7 +140,7 @@
 
 CREATE TABLE mess_stelle (
     id character varying(5) PRIMARY KEY,
-    netzbetreiber_id character varying(2) NOT NULL,
+    netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber,
     beschreibung character varying(300),
     mess_stelle character varying(60),
     mst_typ character varying(1),
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)