annotate db_schema/stammdaten_data_probenehmer.sql @ 1290:14876c62f692

Push down refreshing of persisted objects deeper into the stack. There are more places besides creation of Probe objects where it is useful to return within the response what has been really written to the database (including modifications by the database itself) instead of merely the request data, e.g. creation of Ort objects, which includes database generated ort_ids.
author Tom Gottfried <tom@intevation.de>
date Wed, 08 Feb 2017 18:02:05 +0100
parents 3923b41f8783
children 739ad8e78fca
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
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 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
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 -- TOC entry 4713 (class 0 OID 535818)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Dependencies: 279
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 -- Data for Name: probenehmer; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 COPY probenehmer (id, netzbetreiber_id, prn_id, bearbeiter, bemerkung, betrieb, bezeichnung, kurz_bezeichnung, ort, plz, strasse, telefon, tp, typ, letzte_aenderung) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 724 06 AV18 \N \N \N Stadt Kassel - Veterinärdienst und Lebensmittelüberwachung AVV Kassel Kassel 34117 Kurt Schumacher Straße 31 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 726 06 AV24 \N \N \N Stadt Wiesbaden - Amt f. Veterinärwesen u. Verbraucherschutz AVV Wiesb Wiesbaden 65187 Teutonenstraße 1 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31 727 06 AV0 \N \N \N Rheingau-Taunus Kreis - RD III.8 Verbraucherschutz u. Veterinärwesen AVV RhgTns Bad Schwalbach 65307 Heimbacher Straße 7 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32 729 06 AV17 \N \N \N Landkreis Fulda - Sachgebiet Veterinärwesen u. Verbraucherschutz AVV Fulda Fulda 36037 Wörthstraße 15 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 734 06 AV16 \N \N \N Schwalm-Eder Kreis - Fachbereich 39, Veterinärwesen und Verbraucherschutz AVV Homber Homberg (Efze) 34576 Waßmuthshäuser Str. 52, Geb. 5 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 60 06 001 \N \N \N HLUG Wiesbaden - Dezernat W2, Probenahme HLUG-W2 WI Wiesbaden 65203 Rheingaustraße 186 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 78 06 LL2 \N \N \N LLH Gartenbauberatungsschwerpunkt Friedberg LLH Fb Friedberg (Hessen) 61169 Homburger Straße 17 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 92 06 LL5 \N \N \N LLH Gartenbauberatungsschwerpunkt Kassel LLH Ks Kassel 34117 Kölnische Straße 48-50 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 714 06 AV1 \N \N \N LK Darmstadt-Dieburg - Amt f. Veterinärwesen u. Verbraucherschutz AVV DaDieb Darmstadt 64295 Haardtring 369 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 784 12 V05 \N \N \N VLÜA FF Frankfurt (Oder) VLÜA FF \N \N \N \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 813 06 001b \N \N \N HLUG Kassel - Dezernat W2, Probenahme HLUG-W2 KS Kassel 34121 Ludwig-Mond-Straße 33 \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 977 06 LH1 \N \N \N Landesbetrieb Hessisches Landeslabor LHL \N \N \N \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 1859 12 PR3 Jan Schmidt \N LVLF Zentraler Technischer Prüfdienst - Luckau ZTPD3 \N \N \N \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 1199 12 V15 \N \N \N VLÜA PR Perleberg VLÜA PR \N \N \N \N \N \N 2000-01-01 00:00:00
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)