1191
|
1 \set ON_ERROR_STOP on |
|
2 |
|
3 -- |
|
4 -- PostgreSQL database dump |
|
5 -- |
|
6 |
|
7 -- Dumped from database version 9.5.1 |
|
8 -- Dumped by pg_dump version 9.5.0 |
|
9 |
|
10 -- Started on 2016-03-31 11:38:13 |
|
11 |
|
12 SET statement_timeout = 0; |
|
13 SET lock_timeout = 0; |
|
14 SET client_encoding = 'UTF8'; |
|
15 SET standard_conforming_strings = on; |
|
16 SET check_function_bodies = false; |
|
17 SET client_min_messages = warning; |
|
18 |
|
19 SET search_path = stammdaten, pg_catalog; |
|
20 |
|
21 |
|
22 -- |
|
23 -- TOC entry 4697 (class 0 OID 535760) |
|
24 -- Dependencies: 262 |
|
25 -- Data for Name: messgroessen_gruppe; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
|
26 -- |
|
27 |
|
28 COPY messgroessen_gruppe (id, bezeichnung, ist_leitnuklidgruppe) FROM stdin; |
|
29 57 Messgrössen für nuklidspezifische Gammamessung 0 |
|
30 97 Gesamt-Alpha und Beta 0 |
|
31 30 Sr-Isotope (insbes. Sr 90) 0 |
|
32 31 Iod-Isotope (insbes. I 131) 0 |
|
33 32 Alpha-Teilchen emittierende Pu-Isotope (insbes. Pu 239, Am 241) 0 |
|
34 33 sonst. Nuklide mit Halbwertzeiten > 10d (insbes. Cs 134, Cs 137) 0 |
|
35 34 Cs-Isotope (Cs 134, Cs 137) 0 |
|
36 5 Alphaspektrometrie Messgrößen 0 |
|
37 6 Berechnete Größen 0 |
|
38 7 Beta Größen 0 |
|
39 8 Elementbestimmungsmessgrößen 0 |
|
40 10 Gamma-OD 0 |
|
41 11 Gamma-ODL 0 |
|
42 12 Gamma-Spektrometrie Iod 131 0 |
|
43 13 Gammaspektrometrie Messgrößen 0 |
|
44 14 Gesamt-Alpha-Aktivität 0 |
|
45 15 Gesamt-Alpha-Aktivität, Handmonitor 0 |
|
46 16 Gesamt-Alpha-Aktivität, verzögert 0 |
|
47 17 Gesamt-Beta-Aktivität 0 |
|
48 18 Gesamt-Beta-Aktivität, Handmonitor 0 |
|
49 19 Gesamt-Beta-Aktivität, verzögert / Künstlich Gesamt-Beta 0 |
|
50 20 Gesamt-Cäsium-Aktivität 0 |
|
51 21 Gesamt-Gamma-Aktivität 0 |
|
52 22 Neutronen-Dosisleistung 0 |
|
53 23 Neutronen-Ortsdosis 0 |
|
54 24 Niederschlagsintensität 0 |
|
55 25 Niederschlagsmenge 0 |
|
56 26 nuklidspezifische Dosisleistung 0 |
|
57 3 PARK - Alpha-Strahler 0 |
|
58 2 PARK - Beta-Strahler 0 |
|
59 4 PARK - Edelgase 0 |
|
60 1 PARK - Gamma-Strahler (aerosolgebunden vorkommend) 0 |
|
61 27 Rest-Beta 0 |
|
62 28 Schneehöhe 0 |
|
63 29 sonstige radiologische Meßmethode 0 |
|
64 35 Cs 137 0 |
|
65 36 I 131 0 |
|
66 37 Sr 89/90 0 |
|
67 55 H 3 0 |
|
68 56 C 14 0 |
|
69 77 Edelgas-Messgrößen 0 |
|
70 119 Gamma-ODL (Handmessung) 0 |
|
71 117 Alphaspektrometrie Uran 0 |
|
72 118 Alphaspektrometrie Plutonium 0 |
|
73 \. |
|
74 |
|
75 |
|
76 -- |
|
77 -- TOC entry 4701 (class 0 OID 535771) |
|
78 -- Dependencies: 266 |
|
79 -- Data for Name: mg_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
|
80 -- |
|
81 |
|
82 COPY mg_grp (messgroessengruppe_id, messgroesse_id) FROM stdin; |
|
83 1 2 |
|
84 1 10 |
|
85 1 28 |
|
86 1 51 |
|
87 1 56 |
|
88 1 60 |
|
89 1 64 |
|
90 1 66 |
|
91 1 68 |
|
92 1 85 |
|
93 1 166 |
|
94 1 167 |
|
95 1 176 |
|
96 1 177 |
|
97 1 184 |
|
98 1 185 |
|
99 1 193 |
|
100 1 196 |
|
101 1 201 |
|
102 1 214 |
|
103 1 220 |
|
104 1 222 |
|
105 1 250 |
|
106 1 303 |
|
107 1 304 |
|
108 1 307 |
|
109 1 310 |
|
110 1 316 |
|
111 1 321 |
|
112 1 322 |
|
113 1 323 |
|
114 1 325 |
|
115 1 340 |
|
116 1 342 |
|
117 1 343 |
|
118 1 345 |
|
119 1 369 |
|
120 1 372 |
|
121 1 373 |
|
122 1 384 |
|
123 1 393 |
|
124 1 394 |
|
125 1 402 |
|
126 1 403 |
|
127 1 404 |
|
128 1 423 |
|
129 1 437 |
|
130 1 543 |
|
131 1 658 |
|
132 1 670 |
|
133 1 672 |
|
134 1 673 |
|
135 1 684 |
|
136 1 686 |
|
137 1 725 |
|
138 1 739 |
|
139 1 749 |
|
140 1 761 |
|
141 2 1 |
|
142 2 164 |
|
143 2 165 |
|
144 3 732 |
|
145 3 746 |
|
146 3 747 |
|
147 3 750 |
|
148 3 759 |
|
149 3 768 |
|
150 3 769 |
|
151 3 781 |
|
152 3 793 |
|
153 3 795 |
|
154 4 26 |
|
155 4 140 |
|
156 4 142 |
|
157 4 143 |
|
158 4 354 |
|
159 4 355 |
|
160 4 356 |
|
161 4 357 |
|
162 5 717 |
|
163 5 727 |
|
164 5 728 |
|
165 5 730 |
|
166 5 732 |
|
167 5 744 |
|
168 5 745 |
|
169 5 746 |
|
170 5 747 |
|
171 5 750 |
|
172 5 759 |
|
173 5 766 |
|
174 5 768 |
|
175 5 769 |
|
176 5 770 |
|
177 5 781 |
|
178 5 793 |
|
179 5 794 |
|
180 5 795 |
|
181 5 850 |
|
182 5 978 |
|
183 6 950 |
|
184 7 1 |
|
185 7 5 |
|
186 7 164 |
|
187 7 165 |
|
188 7 215 |
|
189 7 717 |
|
190 8 28 |
|
191 8 958 |
|
192 10 925 |
|
193 10 926 |
|
194 11 900 |
|
195 11 909 |
|
196 11 910 |
|
197 11 911 |
|
198 11 998 |
|
199 11 999 |
|
200 12 259 |
|
201 12 273 |
|
202 12 338 |
|
203 12 340 |
|
204 12 860 |
|
205 12 870 |
|
206 12 880 |
|
207 13 2 |
|
208 13 10 |
|
209 13 26 |
|
210 13 28 |
|
211 13 40 |
|
212 13 51 |
|
213 13 56 |
|
214 13 60 |
|
215 13 64 |
|
216 13 66 |
|
217 13 67 |
|
218 13 68 |
|
219 13 85 |
|
220 13 90 |
|
221 13 92 |
|
222 13 117 |
|
223 13 140 |
|
224 13 141 |
|
225 13 142 |
|
226 13 143 |
|
227 13 144 |
|
228 13 162 |
|
229 13 166 |
|
230 13 167 |
|
231 13 171 |
|
232 13 176 |
|
233 13 177 |
|
234 13 184 |
|
235 13 185 |
|
236 13 193 |
|
237 13 196 |
|
238 13 201 |
|
239 13 214 |
|
240 13 220 |
|
241 13 221 |
|
242 13 222 |
|
243 13 247 |
|
244 13 248 |
|
245 13 250 |
|
246 13 251 |
|
247 13 252 |
|
248 13 257 |
|
249 13 267 |
|
250 13 281 |
|
251 13 303 |
|
252 13 304 |
|
253 13 307 |
|
254 13 310 |
|
255 13 316 |
|
256 13 321 |
|
257 13 322 |
|
258 13 323 |
|
259 13 325 |
|
260 13 335 |
|
261 13 338 |
|
262 13 340 |
|
263 13 342 |
|
264 13 343 |
|
265 13 345 |
|
266 13 354 |
|
267 13 355 |
|
268 13 356 |
|
269 13 357 |
|
270 13 358 |
|
271 13 359 |
|
272 13 369 |
|
273 13 372 |
|
274 13 373 |
|
275 13 380 |
|
276 13 384 |
|
277 13 392 |
|
278 13 393 |
|
279 13 394 |
|
280 13 401 |
|
281 13 402 |
|
282 13 403 |
|
283 13 404 |
|
284 13 423 |
|
285 13 432 |
|
286 13 435 |
|
287 13 437 |
|
288 13 445 |
|
289 13 456 |
|
290 13 457 |
|
291 13 458 |
|
292 13 529 |
|
293 13 543 |
|
294 13 560 |
|
295 13 582 |
|
296 13 644 |
|
297 13 653 |
|
298 13 654 |
|
299 13 657 |
|
300 13 658 |
|
301 13 670 |
|
302 13 671 |
|
303 13 672 |
|
304 13 673 |
|
305 13 683 |
|
306 13 684 |
|
307 13 686 |
|
308 13 705 |
|
309 13 714 |
|
310 13 715 |
|
311 13 717 |
|
312 13 719 |
|
313 13 720 |
|
314 13 724 |
|
315 13 725 |
|
316 13 727 |
|
317 13 728 |
|
318 13 730 |
|
319 13 731 |
|
320 13 732 |
|
321 13 733 |
|
322 13 737 |
|
323 13 739 |
|
324 13 740 |
|
325 13 741 |
|
326 13 747 |
|
327 13 749 |
|
328 13 750 |
|
329 13 761 |
|
330 13 781 |
|
331 13 860 |
|
332 13 861 |
|
333 13 862 |
|
334 13 955 |
|
335 14 904 |
|
336 14 905 |
|
337 14 923 |
|
338 15 904 |
|
339 16 915 |
|
340 16 916 |
|
341 16 917 |
|
342 16 918 |
|
343 17 902 |
|
344 17 903 |
|
345 17 924 |
|
346 18 902 |
|
347 19 919 |
|
348 19 920 |
|
349 19 921 |
|
350 19 922 |
|
351 20 906 |
|
352 21 901 |
|
353 21 908 |
|
354 22 914 |
|
355 22 929 |
|
356 22 930 |
|
357 22 1000 |
|
358 22 1001 |
|
359 23 913 |
|
360 23 927 |
|
361 23 928 |
|
362 25 950 |
|
363 25 951 |
|
364 25 952 |
|
365 26 2 |
|
366 26 10 |
|
367 26 26 |
|
368 26 28 |
|
369 26 51 |
|
370 26 56 |
|
371 26 60 |
|
372 26 64 |
|
373 26 66 |
|
374 26 68 |
|
375 26 85 |
|
376 26 140 |
|
377 26 141 |
|
378 26 142 |
|
379 26 143 |
|
380 26 144 |
|
381 26 166 |
|
382 26 167 |
|
383 26 176 |
|
384 26 177 |
|
385 26 184 |
|
386 26 185 |
|
387 26 193 |
|
388 26 196 |
|
389 26 201 |
|
390 26 214 |
|
391 26 220 |
|
392 26 222 |
|
393 26 250 |
|
394 26 303 |
|
395 26 304 |
|
396 26 307 |
|
397 26 310 |
|
398 26 316 |
|
399 26 321 |
|
400 26 322 |
|
401 26 323 |
|
402 26 325 |
|
403 26 340 |
|
404 26 342 |
|
405 26 343 |
|
406 26 345 |
|
407 26 354 |
|
408 26 355 |
|
409 26 356 |
|
410 26 357 |
|
411 26 358 |
|
412 26 359 |
|
413 26 369 |
|
414 26 372 |
|
415 26 373 |
|
416 26 384 |
|
417 26 393 |
|
418 26 394 |
|
419 26 402 |
|
420 26 403 |
|
421 26 404 |
|
422 26 423 |
|
423 26 437 |
|
424 26 543 |
|
425 26 658 |
|
426 26 670 |
|
427 26 672 |
|
428 26 673 |
|
429 26 684 |
|
430 26 686 |
|
431 26 717 |
|
432 26 725 |
|
433 26 739 |
|
434 26 747 |
|
435 26 749 |
|
436 26 761 |
|
437 27 907 |
|
438 28 951 |
|
439 29 2 |
|
440 29 28 |
|
441 29 59 |
|
442 29 68 |
|
443 29 74 |
|
444 29 165 |
|
445 29 222 |
|
446 29 340 |
|
447 29 369 |
|
448 29 373 |
|
449 29 670 |
|
450 29 715 |
|
451 29 717 |
|
452 29 719 |
|
453 29 725 |
|
454 29 728 |
|
455 29 740 |
|
456 29 746 |
|
457 29 747 |
|
458 29 750 |
|
459 29 900 |
|
460 29 902 |
|
461 29 904 |
|
462 29 909 |
|
463 29 955 |
|
464 30 164 |
|
465 30 165 |
|
466 30 166 |
|
467 30 167 |
|
468 31 340 |
|
469 31 342 |
|
470 31 343 |
|
471 31 345 |
|
472 32 769 |
|
473 32 781 |
|
474 32 850 |
|
475 33 369 |
|
476 33 373 |
|
477 33 384 |
|
478 34 369 |
|
479 34 373 |
|
480 35 373 |
|
481 36 340 |
|
482 37 164 |
|
483 37 165 |
|
484 55 1 |
|
485 56 5 |
|
486 57 340 |
|
487 57 369 |
|
488 57 373 |
|
489 77 141 |
|
490 77 353 |
|
491 77 355 |
|
492 77 357 |
|
493 97 902 |
|
494 97 904 |
|
495 8 750 |
|
496 8 769 |
|
497 8 781 |
|
498 8 747 |
|
499 8 746 |
|
500 12 342 |
|
501 13 353 |
|
502 13 531 |
|
503 117 745 |
|
504 117 750 |
|
505 117 746 |
|
506 117 747 |
|
507 117 744 |
|
508 118 768 |
|
509 118 850 |
|
510 118 766 |
|
511 118 769 |
|
512 118 770 |
|
513 119 900 |
|
514 \. |
|
515 |
|
516 |
|
517 -- |
|
518 -- TOC entry 4702 (class 0 OID 535774) |
|
519 -- Dependencies: 267 |
|
520 -- Data for Name: mmt_messgroesse_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada |
|
521 -- |
|
522 |
|
523 COPY mmt_messgroesse_grp (messgroessengruppe_id, mmt_id) FROM stdin; |
|
524 5 A1 |
|
525 6 S1 |
|
526 7 B1 |
|
527 8 E1 |
|
528 10 D1 |
|
529 11 O1 |
|
530 12 G3 |
|
531 12 GI |
|
532 13 G1 |
|
533 13 I1 |
|
534 13 I2 |
|
535 14 A2 |
|
536 15 A3 |
|
537 16 A4 |
|
538 17 B2 |
|
539 18 B3 |
|
540 19 B4 |
|
541 21 G4 |
|
542 22 O2 |
|
543 23 D2 |
|
544 24 M2 |
|
545 25 M1 |
|
546 26 I3 |
|
547 27 B5 |
|
548 28 M3 |
|
549 29 S4 |
|
550 37 BS |
|
551 37 BX |
|
552 55 BH |
|
553 56 BC |
|
554 57 G2 |
|
555 77 BE |
|
556 97 AB |
|
557 117 AU |
|
558 118 AP |
|
559 119 O3 |
|
560 \. |
|
561 |