Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1082:6499f2410c42
Fix validation of subintervall for yearly samples.
Validity and subintervall are actually redundant for yearly samples.
Giving a subintervall wider than validity will never result in
generation of samples because the start will never match validity.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 10 Oct 2016 17:23:39 +0200 |
| parents | 7143cd96d3de |
| children | 186d602e031a |
comparison
equal
deleted
inserted
replaced
| 1081:b782a10c5b28 | 1082:6499f2410c42 |
|---|---|
| 587 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365), | 587 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365), |
| 588 probe_nehmer_id integer, | 588 probe_nehmer_id integer, |
| 589 probe_kommentar character varying(80), | 589 probe_kommentar character varying(80), |
| 590 letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL, | 590 letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL, |
| 591 CHECK (probenintervall = 'J' | 591 CHECK (probenintervall = 'J' |
| 592 AND teilintervall_von BETWEEN 1 AND 365 | 592 AND teilintervall_von BETWEEN gueltig_von AND gueltig_bis |
| 593 AND teilintervall_bis BETWEEN 1 AND 365 | 593 AND teilintervall_bis BETWEEN gueltig_von AND gueltig_bis |
| 594 AND intervall_offset BETWEEN 0 AND 364 | 594 AND intervall_offset BETWEEN 0 AND 364 |
| 595 OR probenintervall = 'H' | 595 OR probenintervall = 'H' |
| 596 AND teilintervall_von BETWEEN 1 AND 184 | 596 AND teilintervall_von BETWEEN 1 AND 184 |
| 597 AND teilintervall_bis BETWEEN 1 AND 184 | 597 AND teilintervall_bis BETWEEN 1 AND 184 |
| 598 AND intervall_offset BETWEEN 0 AND 183 | 598 AND intervall_offset BETWEEN 0 AND 183 |