Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1187:3c24d33bf0db | 1189:4ee336c65ab3 |
|---|---|
| 160 teilintervall_bis integer NOT NULL, | 160 teilintervall_bis integer NOT NULL, |
| 161 intervall_offset integer NOT NULL DEFAULT 0, | 161 intervall_offset integer NOT NULL DEFAULT 0, |
| 162 gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 1 AND 365), | 162 gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 1 AND 365), |
| 163 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365), | 163 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365), |
| 164 probe_nehmer_id integer REFERENCES stammdaten.probenehmer, | 164 probe_nehmer_id integer REFERENCES stammdaten.probenehmer, |
| 165 mpl_id integer REFERENCES stammdaten.messprogramm_kategorie, | |
| 165 probe_kommentar character varying(80), | 166 probe_kommentar character varying(80), |
| 166 letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL, | 167 letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL, |
| 167 CHECK (probenintervall = 'J' | 168 CHECK (probenintervall = 'J' |
| 168 AND teilintervall_von BETWEEN gueltig_von AND gueltig_bis | 169 AND teilintervall_von BETWEEN gueltig_von AND gueltig_bis |
| 169 AND teilintervall_bis BETWEEN gueltig_von AND gueltig_bis | 170 AND teilintervall_bis BETWEEN gueltig_von AND gueltig_bis |