Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1262:9dfb52db6a0f
Make use of the ort factory in ort service.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 27 Jan 2017 15:10:01 +0100 |
| parents | 6e393b614edf |
| children |
comparison
equal
deleted
inserted
replaced
| 1261:dc7dde59bb54 | 1262:9dfb52db6a0f |
|---|---|
| 149 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 149 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 150 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 150 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 151 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 151 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 152 ba_id integer DEFAULT 1 REFERENCES stammdaten.betriebsart, | 152 ba_id integer DEFAULT 1 REFERENCES stammdaten.betriebsart, |
| 153 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, | 153 gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit, |
| 154 ort_id integer NOT NULL REFERENCES stammdaten.ort, | |
| 155 media_desk character varying(100) CHECK(media_desk LIKE '% %'), | 154 media_desk character varying(100) CHECK(media_desk LIKE '% %'), |
| 156 umw_id character varying(3) REFERENCES stammdaten.umwelt, | 155 umw_id character varying(3) REFERENCES stammdaten.umwelt, |
| 157 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, | 156 probenart_id integer NOT NULL REFERENCES stammdaten.probenart, |
| 158 probenintervall character varying(2) NOT NULL, | 157 probenintervall character varying(2) NOT NULL, |
| 159 teilintervall_von integer NOT NULL, | 158 teilintervall_von integer NOT NULL, |
| 283 EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E') | 282 EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E') |
| 284 ); | 283 ); |
| 285 CREATE TRIGGER letzte_aenderung_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 284 CREATE TRIGGER letzte_aenderung_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 286 CREATE TRIGGER tree_modified_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_tree_modified(); | 285 CREATE TRIGGER tree_modified_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_tree_modified(); |
| 287 | 286 |
| 287 -- | |
| 288 -- Name: ortszuordnung_mp; Type: TABLE; Schema: land; Owner: -; Tablespace: | |
| 289 -- | |
| 290 | |
| 291 CREATE TABLE ortszuordnung_mp ( | |
| 292 id serial PRIMARY KEY, | |
| 293 messprogramm_id integer NOT NULL REFERENCES messprogramm ON DELETE CASCADE, | |
| 294 ort_id integer NOT NULL REFERENCES stammdaten.ort, | |
| 295 ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ, | |
| 296 ortszusatztext character varying(100), | |
| 297 letzte_aenderung timestamp without time zone DEFAULT now(), | |
| 298 tree_modified timestamp without time zone DEFAULT now(), | |
| 299 EXCLUDE (messprogramm_id WITH =) WHERE (ortszuordnung_typ = 'E') | |
| 300 ); | |
| 301 CREATE TRIGGER letzte_aenderung_ortszuordnung_mp BEFORE UPDATE ON ortszuordnung_mp FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | |
| 288 | 302 |
| 289 -- | 303 -- |
| 290 -- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace: | 304 -- Name: zusatz_wert; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 291 -- | 305 -- |
| 292 | 306 |
| 360 UNIQUE (messungs_id, messgroesse_id) | 374 UNIQUE (messungs_id, messgroesse_id) |
| 361 ); | 375 ); |
| 362 CREATE TRIGGER letzte_aenderung_messwert BEFORE UPDATE ON messwert FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 376 CREATE TRIGGER letzte_aenderung_messwert BEFORE UPDATE ON messwert FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 363 CREATE TRIGGER tree_modified_messwert BEFORE UPDATE ON messwert FOR EACH ROW EXECUTE PROCEDURE update_tree_modified(); | 377 CREATE TRIGGER tree_modified_messwert BEFORE UPDATE ON messwert FOR EACH ROW EXECUTE PROCEDURE update_tree_modified(); |
| 364 | 378 |
| 365 | |
| 366 -- | 379 -- |
| 367 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: | 380 -- Name: status_protokoll; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 368 -- | 381 -- |
| 369 | 382 |
| 370 CREATE TABLE status_protokoll ( | 383 CREATE TABLE status_protokoll ( |