Mercurial > lada > lada-server
changeset 901:56c9fb1d37c8
probe and messprogramm always need a mst_id and labor_mst_id.
Otherwise no owner can be determined.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 23 Mar 2016 18:52:09 +0100 |
| parents | 26d57ae6dd2f |
| children | d465094946ef |
| files | db_schema/lada_schema.sql |
| diffstat | 1 files changed, 6 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Wed Mar 23 13:07:11 2016 +0100 +++ b/db_schema/lada_schema.sql Wed Mar 23 18:52:09 2016 +0100 @@ -364,8 +364,10 @@ id integer PRIMARY KEY DEFAULT nextval('probe_id_seq'::regclass), test boolean DEFAULT false NOT NULL, netzbetreiber_id character varying(2) REFERENCES stammdaten.netz_betreiber, - mst_id character varying(5) REFERENCES stammdaten.mess_stelle, - labor_mst_id character varying(5) 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), @@ -543,7 +545,8 @@ 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) 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),