Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1026:d77178ccbcbc schema-update
Added FK to probe and messprogramm.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 14:31:06 +0200 |
| parents | c1e00e1fe5c8 |
| children | 434b46ead134 |
comparison
equal
deleted
inserted
replaced
| 1025:8e5dcf7156c5 | 1026:d77178ccbcbc |
|---|---|
| 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 character varying(1), | 122 ba_id integer 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, |
| 162 test boolean DEFAULT false NOT NULL, | 162 test boolean DEFAULT false NOT NULL, |
| 163 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 163 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 164 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 164 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 165 hauptproben_nr character varying(20), | 165 hauptproben_nr character varying(20), |
| 166 datenbasis_id smallint REFERENCES stammdaten.datenbasis, | 166 datenbasis_id smallint REFERENCES stammdaten.datenbasis, |
| 167 ba_id character varying(1), | 167 ba_id integer REFERENCES stammdaten.betriebsart, |
| 168 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, | 168 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, |
| 169 media_desk character varying(100), | 169 media_desk character varying(100), |
| 170 media character varying(100), | 170 media character varying(100), |
| 171 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 171 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 172 probeentnahme_beginn timestamp with time zone, | 172 probeentnahme_beginn timestamp with time zone, |