Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 1006:599bd9462e62 schema-update
Removed duplicated netzbetreiber column. (mst_id already contains the
netzbetreiber)
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 08:52:13 +0200 |
| parents | e9116ec4eb40 |
| children | 6a313cb77fda |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Fri Jul 01 19:53:56 2016 +0200 +++ b/db_schema/lada_schema.sql Mon Jul 04 08:52:13 2016 +0200 @@ -116,11 +116,8 @@ id serial PRIMARY KEY, name character varying(256), test boolean DEFAULT false NOT NULL, - netzbetreiber_id character varying(2) NOT NULL - REFERENCES stammdaten.netz_betreiber, mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, - labor_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), gem_id character varying(8), @@ -163,11 +160,8 @@ id serial PRIMARY KEY, id_alt character varying(20) DEFAULT (('sss'::text || lpad(((nextval('land.probe_probe_id_seq'::regclass))::character varying)::text, 12, '0'::text)) || 'Y'::text) NOT NULL, test boolean DEFAULT false NOT NULL, - netzbetreiber_id character varying(2) REFERENCES stammdaten.netz_betreiber, - mst_id character varying(5) NOT NULL - REFERENCES stammdaten.mess_stelle, - labor_mst_id character varying(5) NOT NULL - REFERENCES stammdaten.mess_stelle, + mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, + 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),