Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1044:a796e68da1cf
A period with end before start is not meaningful.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 07 Sep 2016 18:17:48 +0200 |
| parents | e192feaf916f |
| children | 61b94641cf99 |
comparison
equal
deleted
inserted
replaced
| 1019:e192feaf916f | 1044:a796e68da1cf |
|---|---|
| 585 intervall_offset integer, | 585 intervall_offset integer, |
| 586 gueltig_von integer NOT NULL, | 586 gueltig_von integer NOT NULL, |
| 587 gueltig_bis integer NOT NULL, | 587 gueltig_bis integer NOT NULL, |
| 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 (gueltig_von <= gueltig_bis) | |
| 591 ); | 592 ); |
| 592 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 593 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 593 | 594 |
| 594 -- | 595 -- |
| 595 -- Name: messprogramm_id_seq; Type: SEQUENCE OWNED BY; Schema: land; Owner: - | 596 -- Name: messprogramm_id_seq; Type: SEQUENCE OWNED BY; Schema: land; Owner: - |