Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1059:a435b9fd1d85
Set default in data model instead of on generation of Probe objects.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 23 Sep 2016 19:13:40 +0200 |
| parents | 3c9616e5439f |
| children | 7788a805a98d |
comparison
equal
deleted
inserted
replaced
| 1058:0d0362fe7619 | 1059:a435b9fd1d85 |
|---|---|
| 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 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, | 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 0 AND 364), |
| 587 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 0 AND 364), | 587 gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 0 AND 364), |
| 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, |