diff db_schema/stammdaten_schema.sql @ 1051:9615be7b1626 schema-update

Added new table for messprogramm mappings.
author Raimund Renkert <raimund.renkert@intevation.de>
date Tue, 20 Sep 2016 10:13:43 +0200
parents 1c6c83037b8c
children 1868bd3565bf
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Mon Sep 19 12:14:46 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Tue Sep 20 10:13:43 2016 +0200
@@ -639,6 +639,18 @@
 );
 -- Status workflow
 
+-- Mappings for import
+
+CREATE TABLE messprogramm_transfer (
+    id serial PRIMARY KEY,
+    messprogramm_s character varying(1) NOT NULL,
+    messprogramm_c character varying(100) NOT NULL,
+    ba_id integer NOT NULL REFERENCES betriebsart,
+    datenbasis_id integer NOT NULL REFERENCES datenbasis,
+    UNIQUE (messprogramm_s)
+);
+
+-- Mappings for import
 
 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom);
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)