Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 927:690b6506e0a2
merged.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 29 Apr 2016 16:40:26 +0200 |
| parents | 9121d99a471e 34c04b0557ac |
| children | b943e956b767 |
comparison
equal
deleted
inserted
replaced
| 926:9121d99a471e | 927:690b6506e0a2 |
|---|---|
| 397 media character varying(100), | 397 media character varying(100), |
| 398 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 398 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 399 probeentnahme_beginn timestamp with time zone, | 399 probeentnahme_beginn timestamp with time zone, |
| 400 probeentnahme_ende timestamp with time zone, | 400 probeentnahme_ende timestamp with time zone, |
| 401 mittelungsdauer bigint, | 401 mittelungsdauer bigint, |
| 402 letzte_aenderung timestamp without time zone DEFAULT now() | 402 letzte_aenderung timestamp without time zone DEFAULT now(), |
| 403 UNIQUE (mst_id, hauptproben_nr) | |
| 403 ); | 404 ); |
| 404 | 405 |
| 405 CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 406 CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 406 | 407 |
| 407 -- | 408 -- |