Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1019:e192feaf916f
Introduce default value vor Messregime in Messprogramm.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 05 Jul 2016 18:24:55 +0200 |
| parents | ce1ec3cbde54 |
| children | a796e68da1cf |
comparison
equal
deleted
inserted
replaced
| 991:ce1ec3cbde54 | 1019:e192feaf916f |
|---|---|
| 571 REFERENCES stammdaten.netz_betreiber, | 571 REFERENCES stammdaten.netz_betreiber, |
| 572 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 572 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 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 integer, | 576 ba_id integer DEFAULT 1, |
| 577 gem_id character varying(8), | 577 gem_id character varying(8), |
| 578 ort_id integer NOT NULL 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, |