Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1045:61b94641cf99
A period with end before start is not meaningful.
This is true for the subintervall, too.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 08 Sep 2016 12:03:43 +0200 |
| parents | a796e68da1cf |
| children | 3c9616e5439f |
comparison
equal
deleted
inserted
replaced
| 1044:a796e68da1cf | 1045:61b94641cf99 |
|---|---|
| 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 (teilintervall_von <= teilintervall_bis), | |
| 591 CHECK (gueltig_von <= gueltig_bis) | 592 CHECK (gueltig_von <= gueltig_bis) |
| 592 ); | 593 ); |
| 593 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 594 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 594 | 595 |
| 595 -- | 596 -- |