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,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)