Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 989:b943e956b767
Complement mandatory fields for messprogramm.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Jul 2016 14:18:00 +0200 |
| parents | 690b6506e0a2 |
| children | ce1ec3cbde54 9002ebe2a8af |
comparison
equal
deleted
inserted
replaced
| 988:5efb32a41b24 | 989:b943e956b767 |
|---|---|
| 573 labor_mst_id character varying(5) NOT NULL | 573 labor_mst_id character varying(5) NOT NULL |
| 574 REFERENCES stammdaten.mess_stelle, | 574 REFERENCES stammdaten.mess_stelle, |
| 575 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 575 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 576 ba_id character varying(1), | 576 ba_id character varying(1), |
| 577 gem_id character varying(8), | 577 gem_id character varying(8), |
| 578 ort_id integer REFERENCES stammdaten.ort, | 578 ort_id integer NOT NULL REFERENCES stammdaten.ort, |
| 579 media_desk character varying(100), | 579 media_desk character varying(100), |
| 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, | 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, |
| 582 probenintervall character varying(2), | 582 probenintervall character varying(2) NOT NULL, |
| 583 teilintervall_von integer, | 583 teilintervall_von integer NOT NULL, |
| 584 teilintervall_bis integer, | 584 teilintervall_bis integer NOT NULL, |
| 585 intervall_offset integer, | 585 intervall_offset integer, |
| 586 gueltig_von integer, | 586 gueltig_von integer NOT NULL, |
| 587 gueltig_bis integer, | 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 ); | 591 ); |
| 592 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 592 CREATE TRIGGER letzte_aenderung_messprogramm BEFORE UPDATE ON messprogramm FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |