Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1120:7061388e0af7
Rev d1d7d684800c missed to adapt default FK value.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 28 Oct 2016 16:49:47 +0200 |
| parents | 186d602e031a |
| children | 1ef08710aaeb |
comparison
equal
deleted
inserted
replaced
| 1119:d1d7d684800c | 1120:7061388e0af7 |
|---|---|
| 117 kommentar character varying(1000), | 117 kommentar character varying(1000), |
| 118 test boolean DEFAULT false NOT NULL, | 118 test boolean DEFAULT false NOT NULL, |
| 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 122 ba_id integer DEFAULT 0 REFERENCES stammdaten.betriebsart, | 122 ba_id integer DEFAULT 1 REFERENCES stammdaten.betriebsart, |
| 123 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, | 123 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, |
| 124 ort_id integer NOT NULL REFERENCES stammdaten.ort, | 124 ort_id integer NOT NULL REFERENCES stammdaten.ort, |
| 125 media_desk character varying(100), | 125 media_desk character varying(100), |
| 126 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 126 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 127 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, | 127 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, |