Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 924:34c04b0557ac
Added missing UNIQUE-Constraint.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2016 10:18:24 +0200 |
| parents | 54e83373bfae |
| children | 690b6506e0a2 |
comparison
equal
deleted
inserted
replaced
| 923:20547dfc436e | 924:34c04b0557ac |
|---|---|
| 376 media character varying(100), | 376 media character varying(100), |
| 377 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 377 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 378 probeentnahme_beginn timestamp with time zone, | 378 probeentnahme_beginn timestamp with time zone, |
| 379 probeentnahme_ende timestamp with time zone, | 379 probeentnahme_ende timestamp with time zone, |
| 380 mittelungsdauer bigint, | 380 mittelungsdauer bigint, |
| 381 letzte_aenderung timestamp without time zone DEFAULT now() | 381 letzte_aenderung timestamp without time zone DEFAULT now(), |
| 382 UNIQUE (mst_id, hauptproben_nr) | |
| 382 ); | 383 ); |
| 383 | 384 |
| 384 -- | 385 -- |
| 385 -- Name: COLUMN probe.id; Type: COMMENT; Schema: bund; Owner: - | 386 -- Name: COLUMN probe.id; Type: COMMENT; Schema: bund; Owner: - |
| 386 -- | 387 -- |