Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1066:daca5c62356f
A period with end before start is meaningless.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 29 Sep 2016 16:48:29 +0200 |
| parents | 7d87ddba5520 |
| children | 7143cd96d3de |
comparison
equal
deleted
inserted
replaced
| 1065:7d87ddba5520 | 1066:daca5c62356f |
|---|---|
| 743 mp_kat character(1), | 743 mp_kat character(1), |
| 744 mpl_id character varying(3), | 744 mpl_id character varying(3), |
| 745 mpr_id integer, | 745 mpr_id integer, |
| 746 solldatum_beginn timestamp without time zone, | 746 solldatum_beginn timestamp without time zone, |
| 747 solldatum_ende timestamp without time zone, | 747 solldatum_ende timestamp without time zone, |
| 748 tree_modified timestamp without time zone DEFAULT now() | 748 tree_modified timestamp without time zone DEFAULT now(), |
| 749 CHECK(solldatum_beginn <= solldatum_ende) | |
| 749 ) | 750 ) |
| 750 INHERITS (bund.probe); | 751 INHERITS (bund.probe); |
| 751 | 752 |
| 752 ALTER TABLE ONLY probe | 753 ALTER TABLE ONLY probe |
| 753 ADD CONSTRAINT probe_pkey PRIMARY KEY (id); | 754 ADD CONSTRAINT probe_pkey PRIMARY KEY (id); |