view db_schema/stammdaten_data_pflicht_messgroesse.sql @ 1231:32e27cb8cfef

Use validation rule on update as well.
author Tom Gottfried <tom@intevation.de>
date Fri, 09 Dec 2016 18:20:22 +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 4708 (class 0 OID 535805)
-- Dependencies: 274
-- Data for Name: pflicht_messgroesse; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY pflicht_messgroesse (id, messgroesse_id, mmt_id, umw_id, datenbasis_id) FROM stdin;
102	404	G1	A	2
103	369	G1	A	2
104	340	G1	A	2
105	220	G1	A	2
110	404	G1	F	2
111	369	G1	F	2
112	340	G1	F	2
113	220	G1	F	2
114	404	G1	G	2
115	369	G1	G	2
116	340	G1	G	2
117	220	G1	G	2
122	404	G1	L5	2
123	369	G1	L5	2
124	340	G1	L5	2
125	220	G1	L5	2
126	404	G1	N	2
127	369	G1	N	2
128	340	G1	N	2
129	220	G1	N	2
130	404	G1	Z	2
131	369	G1	Z	2
132	340	G1	Z	2
133	220	G1	Z	2
32	904	A2	A13	4
33	904	A3	B2	4
34	902	B3	B2	4
35	68	G1	B3	4
36	68	G1	F1	4
37	1	BH	F1	4
38	5	BC	F11	4
59	68	G1	G4	4
60	904	A2	G4	4
61	1	BH	G4	4
62	165	BS	G4	4
39	68	G1	F2	4
40	5	BC	F2	4
41	68	G1	F3	4
42	5	BC	F3	4
43	1	BH	F3	4
44	68	G1	F4	4
45	165	BS	F4	4
46	68	G1	F5	4
47	5	BC	F51	4
48	1	BH	F51	4
49	5	BC	F52	4
50	1	BH	F52	4
51	165	BS	F5Z	4
52	68	G1	G1	4
53	904	A2	G11	4
54	1	BH	G11	4
55	68	G1	G21	4
56	904	A2	G21	4
57	1	BH	G21	4
58	68	G1	G23	4
63	68	G1	G5	4
64	1	BH	G5	4
65	165	BS	G5	4
66	904	A2	G51	4
67	904	A2	G53	4
68	68	G1	GZ	4
69	904	A2	GZ	4
70	1	BH	GZ	4
80	930	O2	L22	4
83	68	G1	N11	4
84	340	GI	N11	4
85	165	BS	N11	4
86	68	G1	N12	4
87	340	GI	N12	4
88	165	BS	N12	4
89	68	G1	N2	4
90	165	BS	N2	4
91	68	G1	N31	4
92	165	BS	N31	4
93	68	G1	N4	4
94	165	BS	N4	4
95	68	G1	N55	4
96	373	G1	N55	4
97	68	G1	N61	4
98	68	G1	N62	4
99	68	G1	N7	4
100	1	BH	N7	4
101	165	BS	N7	4
71	68	G1	I13	4
72	5	BC	I13	4
73	1	BH	I13	4
76	928	D2	L21	4
77	68	G1	L31	4
78	904	A2	L31	4
79	340	GI	L41	4
81	68	G1	L5	4
82	904	A2	L5	4
1	28	G1	A	2
2	68	G1	A	2
3	373	G1	A	2
4	28	G1	B	2
5	68	G1	B	2
6	373	G1	B	2
7	28	G1	F	2
8	68	G1	F	2
9	373	G1	F	2
10	28	G1	G	2
11	68	G1	G	2
12	373	G1	G	2
13	28	G1	I	2
14	68	G1	I	2
15	373	G1	I	2
16	2	G1	L3	2
17	68	G1	L3	2
18	373	G1	L3	2
19	340	G1	L41	2
20	28	G1	L5	2
21	68	G1	L5	2
22	373	G1	L5	2
23	28	G1	N	2
24	68	G1	N	2
25	373	G1	N	2
26	28	G1	Z	2
27	68	G1	Z	2
28	373	G1	Z	2
29	369	G1	L3	2
30	672	G1	L3	2
31	673	G1	L3	2
106	404	G1	B	2
107	369	G1	B	2
108	340	G1	B	2
109	220	G1	B	2
118	404	G1	I	2
119	369	G1	I	2
120	340	G1	I	2
121	220	G1	I	2
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)