Mercurial > lada > lada-server
comparison db_schema/stammdaten_data_messmethode.sql @ 1191:3923b41f8783
reorganize db setup
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Fri, 25 Nov 2016 22:25:13 +0100 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| 1190:69865fa2292f | 1191:3923b41f8783 |
|---|---|
| 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 4693 (class 0 OID 535748) | |
| 24 -- Dependencies: 258 | |
| 25 -- Data for Name: mess_methode; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 26 -- | |
| 27 | |
| 28 COPY mess_methode (id, beschreibung, messmethode) FROM stdin; | |
| 29 GI \N Iod, Gamma-Spektrometrie | |
| 30 AB \N Gesamt-Alpha und Beta | |
| 31 A2 \N Gesamt-Alpha | |
| 32 A3 \N Gesamt-Alpha (Handmonitor) | |
| 33 A4 \N Gesamt-Alpha verzögert | |
| 34 B1 \N nukl.-spez. Beta-Messung | |
| 35 B2 \N Gesamt-Beta | |
| 36 B3 \N Gesamt-Beta (Handmonitor) | |
| 37 B4 \N Gesamt-Beta verzögert | |
| 38 B5 \N Rest-Beta | |
| 39 D1 \N Gamma-OD | |
| 40 D2 \N Neutronen-OD | |
| 41 E1 \N Elementbestimmung | |
| 42 G1 \N Gamma-Spektrometrie | |
| 43 G2 \N nuklidspezifische Gammamessung | |
| 44 G3 \N Iod-Messung (Monitor) | |
| 45 G4 \N Gesamt-Gamma | |
| 46 I1 \N in-situ Spektrometrie brutto | |
| 47 I2 \N in-situ Spektrometrie netto | |
| 48 I3 \N nuklidspezifische Dosisleistung brutto | |
| 49 M1 \N Niederschlagsmenge | |
| 50 M2 \N Niederschlagsintensität | |
| 51 M3 \N Schneehöhe | |
| 52 O1 \N Gamma-ODL | |
| 53 O2 \N Neutronen-ODL | |
| 54 S1 \N Berechneter Wert | |
| 55 S4 \N sonstige radiologische Messmethode | |
| 56 A1 \N Alpha-Spektrometrie | |
| 57 BS \N Sr 90-Bestimmung | |
| 58 BH \N H3-Bestimmung | |
| 59 BC \N C14-Bestimmung | |
| 60 M0 Markiert eine Messung als Meteo-Messung Meteo-Messung | |
| 61 BE \N Beta-Messung Edelgase | |
| 62 BX \N Sr-Schnellbestimmung | |
| 63 AP \N Plutonium-Bestimmung | |
| 64 AU \N Uran-Bestimmung | |
| 65 O3 \N Gamma-ODL (Handmessung) | |
| 66 \. |