Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1077:7143cd96d3de
Calendar.DAY_OF_YEAR is 1-based.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 30 Sep 2016 18:41:12 +0200 |
| parents | daca5c62356f |
| children | 6499f2410c42 |
comparison
equal
deleted
inserted
replaced
| 1076:4ce4bd48c260 | 1077:7143cd96d3de |
|---|---|
| 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, | 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, |
| 582 probenintervall character varying(2) NOT NULL, | 582 probenintervall character varying(2) NOT NULL, |
| 583 teilintervall_von integer NOT NULL, | 583 teilintervall_von integer NOT NULL, |
| 584 teilintervall_bis integer NOT NULL, | 584 teilintervall_bis integer NOT NULL, |
| 585 intervall_offset integer NOT NULL DEFAULT 0, | 585 intervall_offset integer NOT NULL DEFAULT 0, |
| 586 gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 0 AND 364), | 586 gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 1 AND 365), |
| 587 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 0 AND 364), | 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 1 AND 365 |