Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 990:ff07474b65e0 | 991:ce1ec3cbde54 |
|---|---|
| 389 REFERENCES stammdaten.mess_stelle, | 389 REFERENCES stammdaten.mess_stelle, |
| 390 labor_mst_id character varying(5) NOT NULL | 390 labor_mst_id character varying(5) NOT NULL |
| 391 REFERENCES stammdaten.mess_stelle, | 391 REFERENCES stammdaten.mess_stelle, |
| 392 hauptproben_nr character varying(20), | 392 hauptproben_nr character varying(20), |
| 393 datenbasis_id smallint REFERENCES stammdaten.datenbasis, | 393 datenbasis_id smallint REFERENCES stammdaten.datenbasis, |
| 394 ba_id character varying(1), | 394 ba_id integer, |
| 395 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, | 395 probenart_id smallint NOT NULL REFERENCES stammdaten.probenart, |
| 396 media_desk character varying(100), | 396 media_desk character varying(100), |
| 397 media character varying(100), | 397 media character varying(100), |
| 398 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 398 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 399 probeentnahme_beginn timestamp with time zone, | 399 probeentnahme_beginn timestamp with time zone, |
| 571 REFERENCES stammdaten.netz_betreiber, | 571 REFERENCES stammdaten.netz_betreiber, |
| 572 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 572 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 573 labor_mst_id character varying(5) NOT NULL | 573 labor_mst_id character varying(5) NOT NULL |
| 574 REFERENCES stammdaten.mess_stelle, | 574 REFERENCES stammdaten.mess_stelle, |
| 575 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 575 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 576 ba_id character varying(1), | 576 ba_id integer, |
| 577 gem_id character varying(8), | 577 gem_id character varying(8), |
| 578 ort_id integer NOT NULL REFERENCES stammdaten.ort, | 578 ort_id integer NOT NULL REFERENCES stammdaten.ort, |
| 579 media_desk character varying(100), | 579 media_desk character varying(100), |
| 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 580 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, | 581 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, |