comparison db_schema/lada_schema.sql @ 1120:7061388e0af7

Rev d1d7d684800c missed to adapt default FK value.
author Tom Gottfried <tom@intevation.de>
date Fri, 28 Oct 2016 16:49:47 +0200
parents 186d602e031a
children 1ef08710aaeb
comparison
equal deleted inserted replaced
1119:d1d7d684800c 1120:7061388e0af7
117 kommentar character varying(1000), 117 kommentar character varying(1000),
118 test boolean DEFAULT false NOT NULL, 118 test boolean DEFAULT false NOT NULL,
119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle,
120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle,
121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis,
122 ba_id integer DEFAULT 0 REFERENCES stammdaten.betriebsart, 122 ba_id integer DEFAULT 1 REFERENCES stammdaten.betriebsart,
123 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, 123 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit,
124 ort_id integer NOT NULL REFERENCES stammdaten.ort, 124 ort_id integer NOT NULL REFERENCES stammdaten.ort,
125 media_desk character varying(100), 125 media_desk character varying(100),
126 umw_id character varying(3) REFERENCES stammdaten.umwelt, 126 umw_id character varying(3) REFERENCES stammdaten.umwelt,
127 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, 127 probenart_id integer NOT NULL REFERENCES stammdaten.probenart,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)