Mercurial > lada > lada-server
view db_schema/stammdaten_data_pflicht_messgroesse.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 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 \.