Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Mon Jul 04 14:30:40 2016 +0200 +++ b/db_schema/lada_schema.sql Mon Jul 04 14:31:06 2016 +0200 @@ -119,7 +119,7 @@ mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, - ba_id character varying(1), + ba_id integer REFERENCES stammdaten.betriebsart, gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, ort_id integer NOT NULL REFERENCES stammdaten.ort, media_desk character varying(100), @@ -164,7 +164,7 @@ labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, hauptproben_nr character varying(20), datenbasis_id smallint REFERENCES stammdaten.datenbasis, - ba_id character varying(1), + ba_id integer REFERENCES stammdaten.betriebsart, probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, media_desk character varying(100), media character varying(100),