Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 991:ce1ec3cbde54
Make ID for Messregime an integer.
Using VARCHAR(1) has drawbacks such as an empty string being
a valid value.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Jul 2016 17:36:06 +0200 |
| parents | b943e956b767 |
| children | e192feaf916f |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Fri Jul 01 16:55:16 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Jul 01 17:36:06 2016 +0200 @@ -391,7 +391,7 @@ REFERENCES stammdaten.mess_stelle, hauptproben_nr character varying(20), datenbasis_id smallint REFERENCES stammdaten.datenbasis, - ba_id character varying(1), + ba_id integer, probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, media_desk character varying(100), media character varying(100), @@ -573,7 +573,7 @@ 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, gem_id character varying(8), ort_id integer NOT NULL REFERENCES stammdaten.ort, media_desk character varying(100),