annotate db_schema/stammdaten_data_query.sql @ 1321:f012a6240d76 release-2.5

remove postgres 9.6 option
author Michael Stanko <mstanko@bfs.de>
date Thu, 23 Mar 2017 11:57:06 +0100
parents bfbbd390c9a8
children 3fe0b22ebabe
rev   line source
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
1 \set ON_ERROR_STOP on
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
2 --
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
6 -- Dumped from database version 9.6.2
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
7 -- Dumped by pg_dump version 9.6.2
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_min_messages = warning;
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
15 SET row_security = off;
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 --
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
20 -- Data for Name: query; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 COPY query (id, name, type, sql, description) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 10 Orte 3 Abfrage der Orte
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 11 Probenehmer 4 Abfrage der Probenehmer
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 12 Datensatzerzeuger 5 Abfrage der Datensatzerzeuger
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27 14 Messprogrammkategorie 6 Abfrage der Messprogrammkategorien
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 7 Proben pro Land und UMW (Multiselect) 0 SELECT probe.id AS id, probe.hauptproben_nr AS hpNr, datenbasis.datenbasis AS dBasis, stammdaten.mess_stelle.netzbetreiber_id AS netzId, probe.mst_id AS mstId, probe.umw_id AS umwId, probenart.probenart AS pArt, to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin, to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd, ort.ort_id AS ortId, ort.gem_id AS eGemId, verwaltungseinheit.bezeichnung AS eGem, probe.id_alt AS probeId FROM land.probe LEFT JOIN stammdaten.mess_stelle ON (probe.mst_id = stammdaten.mess_stelle.id) LEFT JOIN stammdaten.datenbasis ON (probe.datenbasis_id = datenbasis.id) LEFT JOIN stammdaten.probenart ON (probe.probenart_id = probenart.id) LEFT OUTER JOIN land.ortszuordnung ON ( probe.id = ortszuordnung.probe_id AND ortszuordnung.ortszuordnung_typ = 'E' ) LEFT OUTER JOIN stammdaten.ort ON (ortszuordnung.ort_id = ort.id) LEFT OUTER JOIN stammdaten.verwaltungseinheit ON (ort.gem_id = verwaltungseinheit.id) WHERE (stammdaten.mess_stelle.netzbetreiber_id = :netzIdFilter OR '' =:netzIdFilter) AND (probe.umw_id SIMILAR TO (:umwIdFilter) OR '' = :umwIdFilter) Abfrage aller Proben gefiltert pro Land und Umweltbereich (mit Mehrfachauswahl)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 15 kein Filter 1 SELECT messung.id, probe.id AS probeId, probe.hauptproben_nr AS hpNr, messung.nebenproben_nr AS npNr, to_char(status_protokoll.datum, 'dd.mm.YYYY hh24:MI') AS statusD, stammdaten.status_stufe.stufe AS statusSt, stammdaten.status_wert.wert AS statusW, datenbasis.datenbasis AS dBasis, stammdaten.mess_stelle.netzbetreiber_id AS netzId, probe.mst_id AS mstId, probe.umw_id AS umwId, probenart.probenart AS pArt, to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin, to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd, ort.ort_id AS ortId, ort.gem_id AS eGemId, verwaltungseinheit.bezeichnung AS eGem FROM land.probe LEFT JOIN stammdaten.mess_stelle ON (probe.mst_id = stammdaten.mess_stelle.id) INNER JOIN land.messung ON probe.id = messung.probe_id INNER JOIN land.status_protokoll ON messung.STATUS = status_protokoll.id LEFT JOIN stammdaten.status_kombi ON status_protokoll.status_kombi = stammdaten.status_kombi.id LEFT JOIN stammdaten.status_wert ON stammdaten.status_wert.id = stammdaten.status_kombi.wert_id LEFT JOIN stammdaten.status_stufe ON stammdaten.status_stufe.id = stammdaten.status_kombi.stufe_id LEFT JOIN stammdaten.datenbasis ON (probe.datenbasis_id = datenbasis.id) LEFT JOIN stammdaten.probenart ON (probe.probenart_id = probenart.id) LEFT JOIN land.ortszuordnung ON ( probe.id = ortszuordnung.probe_id AND ortszuordnung.ortszuordnung_typ = 'E' ) LEFT JOIN stammdaten.ort ON (ortszuordnung.ort_id = ort.id) LEFT JOIN stammdaten.verwaltungseinheit ON (ort.gem_id = verwaltungseinheit.id) kein Filter
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 13 nach Status 1 SELECT messung.id, probe.id AS probeId, probe.hauptproben_nr AS hpNr, messung.nebenproben_nr AS npNr, to_char(status_protokoll.datum, 'dd.mm.YYYY hh24:MI') AS statusD, stammdaten.status_stufe.stufe AS statusSt, stammdaten.status_wert.wert AS statusW, datenbasis.datenbasis AS dBasis, stammdaten.mess_stelle.netzbetreiber_id AS netzId, probe.mst_id AS mstId, probe.umw_id AS umwId, probenart.probenart AS pArt, to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin, to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd, ort.ort_id AS ortId, ort.gem_id AS eGemId, verwaltungseinheit.bezeichnung AS eGem FROM land.probe LEFT JOIN stammdaten.mess_stelle ON (probe.mst_id = stammdaten.mess_stelle.id) INNER JOIN land.messung ON probe.id = messung.probe_id INNER JOIN land.status_protokoll ON messung.STATUS = status_protokoll.id LEFT JOIN stammdaten.status_kombi ON status_protokoll.status_kombi = stammdaten.status_kombi.id LEFT JOIN stammdaten.status_wert ON stammdaten.status_wert.id = stammdaten.status_kombi.wert_id LEFT JOIN stammdaten.status_stufe ON stammdaten.status_stufe.id = stammdaten.status_kombi.stufe_id LEFT JOIN stammdaten.datenbasis ON (probe.datenbasis_id = datenbasis.id) LEFT JOIN stammdaten.probenart ON (probe.probenart_id = probenart.id) LEFT JOIN land.ortszuordnung ON ( probe.id = ortszuordnung.probe_id AND ortszuordnung.ortszuordnung_typ = 'E' ) LEFT JOIN stammdaten.ort ON (ortszuordnung.ort_id = ort.id) LEFT JOIN stammdaten.verwaltungseinheit ON (ort.gem_id = verwaltungseinheit.id) WHERE CAST(stammdaten.status_wert.id AS text) SIMILAR TO CASE WHEN :statusFilter = '' THEN '%' ELSE :statusFilter END Messungen nach Status
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
31 1 Proben 0 SELECT probe.id AS id,\n probe.hauptproben_nr AS hpNr,\n datenbasis.datenbasis AS dBasis,\n stammdaten.mess_stelle.netzbetreiber_id AS netzId,\n probe.mst_id AS mstId,\n probe.umw_id AS umwId,\n probenart.probenart AS pArt,\n to_char(probe.probeentnahme_beginn, 'dd.mm.YYYY hh24:MI') AS peBegin,\n to_char(probe.probeentnahme_ende, 'dd.mm.YYYY hh24:MI') AS peEnd,\n ort.ort_id AS ortId,\n ort.gem_id AS eGemId,\n verwaltungseinheit.bezeichnung AS eGem,\n probe.id_alt AS probeId\nFROM land.probe\nLEFT JOIN stammdaten.mess_stelle\n ON (probe.mst_id = stammdaten.mess_stelle.id)\nLEFT JOIN stammdaten.datenbasis\n ON (probe.datenbasis_id = datenbasis.id)\nLEFT JOIN stammdaten.probenart\n ON (probe.probenart_id = probenart.id)\nLEFT JOIN land.ortszuordnung\n ON (\n probe.id = ortszuordnung.probe_id\n AND ortszuordnung.ortszuordnung_typ = 'E'\n )\nLEFT JOIN stammdaten.ort\n ON (ortszuordnung.ort_id = ort.id)\nLEFT JOIN stammdaten.verwaltungseinheit\n ON (ort.gem_id = verwaltungseinheit.id)\nWHERE (\n probe.id_alt LIKE CASE \n WHEN :probeIdFilter = ''\n THEN '%'\n ELSE :probeIdFilter\n END\n )\n AND (\n probe.hauptproben_nr LIKE CASE \n WHEN :hpNrFilter = ''\n THEN '%'\n ELSE :hpNrFilter\n END\n )\n AND (\n stammdaten.mess_stelle.netzbetreiber_id = :netzIdFilter\n OR '' = :netzIdFilter\n )\n AND (\n probe.mst_id = :mstIdFilter\n OR '' = :mstIdFilter\n )\n AND (\n probe.umw_id = :umwIdFilter\n OR '' = :umwIdFilter\n )\n Abfrage aller Proben ohne Filter
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
32 9 Messprogramm pro Land 2 SELECT messprogramm.id,\n messprogramm.id AS mpNr,\n stammdaten.mess_stelle.netzbetreiber_id AS netzId,\n CASE \n WHEN messprogramm.mst_id = messprogramm.labor_mst_id\n THEN messprogramm.mst_id\n ELSE messprogramm.mst_id || '-' || messprogramm.labor_mst_id\n END AS mstLaborId,\n datenbasis.datenbasis AS dBasis,\n CASE \n WHEN messprogramm.ba_id = '1'\n THEN 'RB'\n ELSE 'IB'\n END AS messRegime,\n probenart.probenart AS pArt,\n messprogramm.umw_id AS umwId,\n messprogramm.media_desk AS deskriptoren,\n messprogramm.probenintervall AS intervall,\n ort.ort_id AS ortId,\n ort.gem_id AS eGemId,\n verwaltungseinheit.bezeichnung AS eGem\nFROM land.messprogramm\nLEFT JOIN stammdaten.mess_stelle\n ON (messprogramm.mst_id = stammdaten.mess_stelle.id)\nLEFT JOIN stammdaten.datenbasis\n ON (messprogramm.datenbasis_id = datenbasis.id)\nLEFT JOIN stammdaten.probenart\n ON (messprogramm.probenart_id = probenart.id)\nLEFT JOIN land.ortszuordnung_mp\n ON (\n messprogramm.id = ortszuordnung_mp.messprogramm_id\n AND ortszuordnung_mp.ortszuordnung_typ = 'E'\n )\nLEFT JOIN stammdaten.ort\n ON (ortszuordnung_mp.ort_id = ort.id)\nLEFT JOIN stammdaten.verwaltungseinheit\n ON (ort.gem_id = verwaltungseinheit.id)\nWHERE (\n mess_stelle.netzbetreiber_id = :netzIdFilter\n OR '' = :netzIdFilter\n )\n AND (\n messprogramm.umw_id SIMILAR TO (:umwIdFilter)\n OR '' = :umwIdFilter\n ) Abfrage der Messprogramme ohne Filter
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 --
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
37 -- Data for Name: filter; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 COPY filter (id, query_id, data_index, type, label, multiselect) FROM stdin;
1317
3ac30d816c9a prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents: 1278
diff changeset
41 8 7 netzIdFilter 2 Land f
3ac30d816c9a prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents: 1278
diff changeset
42 9 7 umwIdFilter 3 Umweltbereich t
3ac30d816c9a prepare import of production data
Michael Stanko <mstanko@bfs.de>
parents: 1278
diff changeset
43 10 9 netzIdFilter 2 Land f
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 14 14 netzbetreiberId 2 Land t
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 15 13 statusFilter 4 Status t
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 16 10 netzbetreiberId 2 Land f
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 17 11 netzbetreiberId 2 Land f
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
48 18 12 netzbetreiberId 2 Land f
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
49 2 1 hpNrFilter 0 HP-Nr-Filter f
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
50 1 1 probeIdFilter 0 Probe_id-Filter f
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
51 3 1 netzIdFilter 2 Land f
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
52 4 1 mstIdFilter 1 Messstelle f
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
53 5 1 umwIdFilter 3 Umweltbereich f
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
54 11 9 umwIdFilter 3 Umweltbereich t
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
55 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
56
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
57
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
58 --
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
59 -- Name: filter_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
60 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
61
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
62 SELECT pg_catalog.setval('filter_id_seq', 19, true);
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
63
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
64
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
65 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
66 -- Name: query_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
67 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
68
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
69 SELECT pg_catalog.setval('query_id_seq', 15, true);
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
70
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
71
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
72 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
73 -- Data for Name: result; Type: TABLE DATA; Schema: stammdaten; Owner: postgres
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
74 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
75
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
76 COPY result (id, query_id, data_index, header, width, flex, index) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
77 1 1 hpNr Proben-Nr 100 f 0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
78 2 1 dBasis DB 50 f 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
79 3 1 netzId Land 50 f 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
80 4 1 mstId MST 60 f 3
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
81 5 1 umwId Umw-ID 55 f 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
82 6 1 pArt PA 50 f 5
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
83 7 1 peBegin Entnahme_von 120 f 6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
84 8 1 peEnd Entnahme_bis 120 f 7
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
85 9 1 ortId Ort_id 100 f 8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
86 10 1 eGemId E-Gem Id 80 f 9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
87 11 1 eGem E-Gemeinde 200 f 10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
88 12 1 probeId Probe_Id 100 f 11
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
89 128 9 mpNr MPR-ID 70 f 0
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
90 90 9 deskriptoren Deskriptoren 220 f 7
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
91 84 9 netzId Land 50 f 1
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
92 61 7 hpNr Proben-Nr 100 f 0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
93 64 7 dBasis DB 50 f 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
94 66 7 netzId Land 50 f 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
95 67 7 mstId MST 60 f 3
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
96 70 7 umwId Umw-ID 55 f 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
97 71 7 pArt PA 50 f 5
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
98 73 7 peBegin Entnahme_von 120 f 6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
99 76 7 peEnd Entnahme_bis 120 f 7
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
100 77 7 ortId Ort_id 100 f 8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
101 80 7 eGemId E-Gem Id 80 f 9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
102 81 7 eGem E-Gemeinde 200 f 10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
103 82 7 probeId Probe Id 100 f 11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
104 85 9 mstLaborId MST/Labor 80 f 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
105 86 9 dBasis DB 50 f 3
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
106 87 9 messRegime MR 50 f 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
107 88 9 pArt PA 50 f 5
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
108 89 9 umwId Umw-ID 50 f 6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
109 91 9 intervall PI 50 f 8
1274
69042c56944d Fixed query form messprogramme.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1273
diff changeset
110 92 9 ortId Ort_id 100 f 9
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
111 93 9 eGemId Gem-Id 80 f 10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
112 94 9 eGem Gemeinde 200 f 11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
113 95 13 hpNr Proben-Nr 100 f 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
114 96 13 npNr NP-Nr 50 f 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
115 97 13 statusD Status-Zeit 120 f 3
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
116 98 13 statusSt Stufe 40 f 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
117 99 13 statusW Status 100 f 5
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
118 100 13 dBasis DB 50 f 6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
119 101 13 netzId Land 50 f 7
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
120 102 13 mstId MST 60 f 8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
121 103 13 umwId Umw-ID 55 f 9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
122 104 13 pArt PA 50 f 10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
123 105 13 peBegin Entnahme_von 120 f 11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
124 106 13 peEnd Entnahme_bis 120 f 12
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
125 107 13 ortId Ort_id 100 f 13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
126 108 13 eGemId E-Gem Id 80 f 14
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
127 109 13 eGem E-Gemeinde 200 f 15
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
128 110 13 probeId Probe_Id 100 f 0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
129 111 15 hpNr Proben-Nr 100 f 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
130 112 15 npNr NP-Nr 50 f 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
131 113 15 statusD Status-Zeit 120 f 3
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
132 114 15 statusSt Stufe 40 f 4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
133 115 15 statusW Status 100 f 5
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
134 116 15 dBasis DB 50 f 6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
135 117 15 netzId Land 50 f 7
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
136 118 15 mstId MST 60 f 8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
137 119 15 umwId Umw-ID 55 f 9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
138 120 15 pArt PA 50 f 10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
139 121 15 peBegin Entnahme_von 120 f 11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
140 122 15 peEnd Entnahme_bis 120 f 12
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
141 123 15 ortId Ort_id 100 f 13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
142 124 15 eGemId E-Gem Id 80 f 14
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
143 125 15 eGem E-Gemeinde 200 f 15
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
144 126 15 probeId Probe_Id 100 f 0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
145 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
146
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
147
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
148 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
149 -- Name: result_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
150 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
151
1320
bfbbd390c9a8 update queries
Michael Stanko <mstanko@bfs.de>
parents: 1319
diff changeset
152 SELECT pg_catalog.setval('result_id_seq', 128, true);
1319
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
153
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
154
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
155 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
156 -- PostgreSQL database dump complete
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
157 --
512616ea3228 fix somme test data
Michael Stanko <mstanko@bfs.de>
parents: 1317
diff changeset
158
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)