view db_schema/stammdaten_data_netzbetreiber.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
line wrap: on
line source
\set ON_ERROR_STOP on

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.1
-- Dumped by pg_dump version 9.5.0

-- Started on 2016-03-31 11:38:13

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = stammdaten, pg_catalog;

--
-- TOC entry 4703 (class 0 OID 535781)
-- Dependencies: 269
-- Data for Name: netz_betreiber; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY netz_betreiber (id, netzbetreiber, idf_netzbetreiber, is_bmn, mailverteiler, aktiv) FROM stdin;
X	ausländ. Messnetze	\N	t	X	t
PA	Park	R	t	PA	t
A	BfS (Spuren)	A	t	A	t
B	vTI	\N	t	B	t
D	BfS/ZdB	D	t	D	t
E	BfE	\N	t	E	t
F	FhG	\N	t	F	f
G	BfG	\N	t	G	t
H	BSH	\N	t	H	t
I	BfS (LSt. AB)	\N	t	I	t
L	BfS (LSt. TW ...)	\N	t	L	t
M	BMUB	\N	t	M	t
N	MRI	\N	t	N	t
S	Sonstige	\N	t	S	t
T	PTB	\N	t	T	t
U	BfS (ABI)	U	t	U	t
W	DWD	W	t	W	t
Z	BfS (ODL)	Z	t	Z	t
01	Schleswig-Holstein	a	f	01	t
02	Hamburg	b	f	02	t
03	Niedersachsen	c	f	03	t
04	Bremen	d	f	04	t
05	Nordrhein-Westfalen	e	f	05	t
06	Hessen	f	f	06	t
07	Rheinland-Pfalz	g	f	07	t
08	Baden-Württemberg	h	f	08	t
09	Bayern	i	f	09	t
10	Saarland	j	f	10	t
11	Berlin	k	f	11	t
12	Brandenburg	l	f	12	t
13	Mecklenburg-Vorpommern	m	f	13	t
14	Sachsen	n	f	14	t
15	Sachsen-Anhalt	o	f	15	t
16	Thüringen	p	f	16	t
18	Endlager (Bundesaufsicht)	r	f	18	t
19	ZdB-Testnetz	s	f	19	t
17	Bundeswehr	q	f	17	t
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)