Mercurial > lada > lada-server

diff db_schema/lada_schema.sql @ 1189:4ee336c65ab3
Add MPL to Messprogramm
author: Evi Huber <ehuber@bfs.de>
date: Fri, 25 Nov 2016 10:24:22 +0100
parents: cd9bf2430eef
children: 6e393b614edf
--- a/db_schema/lada_schema.sql	Mon Nov 21 14:54:09 2016 +0100
+++ b/db_schema/lada_schema.sql	Fri Nov 25 10:24:22 2016 +0100
@@ -162,6 +162,7 @@
     gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 1 AND 365),
     gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365),
     probe_nehmer_id integer REFERENCES stammdaten.probenehmer,
+    mpl_id integer REFERENCES stammdaten.messprogramm_kategorie,
     probe_kommentar character varying(80),
     letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL,
     CHECK (probenintervall = 'J'