view db_schema/stammdaten_data_mess_einheit.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 4691 (class 0 OID 535743)
-- Dependencies: 256
-- Data for Name: mess_einheit; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY mess_einheit (id, beschreibung, einheit, eudf_messeinheit_id, umrechnungs_faktor_eudf) FROM stdin;
207	Becquerel pro Stunde	Bq/h	\N	\N
227	Megawatt	MW	\N	\N
120	Dezimeter	dm	\N	\N
139	Kilo-Becquerel pro Kilogramm Trockenmasse	kBq/kg(TM)	KBQ/KG	\N
99	Milli-Becquerel pro Liter	mBq/l	MBQ/L	\N
59	Kilogramm pro Person	kg/Person	\N	\N
84	Nano-Sievert pro Stunde	nSv/h	NSV/H	\N
88	Milli-Bequerel pro Kubikmeter	mBq/	MBQ/M3	\N
71	Mikro-Sievert	µSv	\N	\N
72	Milli-Sievert	mSv	\N	\N
73	Nano-Gray	nGy	\N	\N
74	Mikro-Gray	µGy	\N	\N
75	Milli-Gray	mGy	\N	\N
76	Mikro-Sievert pro Stunde	µSv/h	USV/H	\N
1	Millimeter	mm	MM	\N
2	Zentimeter	cm	CM	\N
3	Meter	m	M	\N
4	Kilometer	km	\N	\N
6	Quadratzentimeter	cm²	\N	\N
7	Quadratmeter		M2	\N
8	Quadratkilometer	km²	\N	\N
9	Hektar	ha	\N	\N
10	Kubikzentimeter	cm³	\N	\N
11	Kubikmeter		\N	\N
13	Sekunde	s	\N	\N
14	Minute	min	\N	\N
15	Stunde	h	\N	\N
16	Tag	d	\N	\N
17	Woche	Wo	\N	\N
18	Monat	Mo	\N	\N
19	Jahr	a	\N	\N
20	Gramm	g	G	\N
21	Kilogramm	kg	KG	\N
22	Tonne	t	\N	\N
25	Milliliter	ml	\N	\N
26	Zentiliter	cl	\N	\N
27	Liter	l	L	\N
28	Hektoliter	hl	\N	\N
30	Kubikmeter pro Sekunde	/s	\N	\N
31	Kubikmeter pro Minute	/min	\N	\N
32	Kubikmeter pro Stunde	/h	\N	\N
33	Kubikmeter pro Tag	/d	\N	\N
35	Zentimeter pro Sekunde	cm/s	\N	\N
36	Meter pro Sekunde	m/s	\N	\N
37	Meter pro Minute	m/min	\N	\N
69	Becquerel pro Tag und Person	Bq/(d*p)	BQ/D.P	\N
70	Nano-Sievert	nSv	\N	\N
98	Becquerel pro Quadratmeter und Tag	Bq/(*d)	BQ/M2/D	\N
40	Liter pro Quadratmeter	l/	L/M2	\N
42	Liter pro Minute	l/min	\N	\N
43	Liter pro Stunde	l/h	\N	\N
44	Liter pro Tag	l/d	\N	\N
45	Kilogramm pro Quadratmeter	kg/	KG/M2	\N
46	Kilogramm pro Kubikmeter	kg/	KG/M3	\N
47	Milligramm pro Liter	mg/l	MG/L	\N
48	Tonne pro Hektar	t/ha	\N	\N
49	Kilogramm pro Tag	kg/d	\N	\N
53	Tonnen pro Tag	t/d	\N	\N
54	Tonnen pro Jahr	t/a	\N	\N
55	Kilogramm pro Tag und Person	kg/(d*p)	\N	\N
50	Kilogramm Trockenmasse	kg(TM)	\N	\N
51	Kilogramm Feuchtmasse	kg(FM)	\N	\N
52	Kilogramm Trockenmasse pro Kubikmeter	kg(TM)/	\N	\N
60	Becquerel	Bq	BQ	\N
61	Becquerel pro Quadratmeter	Bq/	BQ/M2	\N
62	Becquerel pro Kubikmeter	Bq/	BQ/M3	\N
63	Becquerel pro Liter	Bq/l	BQ/L	\N
64	Becquerel pro Kilogramm	Bq/kg	BQ/KG	\N
65	Becquerel pro Kilogramm Trockenmasse	Bq/kg(TM)	\N	\N
66	Becquerel pro Kilogramm Glührückstand	Bq/kg(GR)	\N	\N
67	Becquerel pro Kilogramm Feuchtmasse	Bq/kg(FM)	KBQ/KG	\N
38	Millimeter pro Tag	mm/d	\N	\N
77	Mikro-Sievert pro Tag	µSv/d	\N	\N
78	Mikro-Gray pro Stunde	µGy/h	\N	\N
79	Mikro-Gray pro Tag	µGy/d	\N	\N
80	Sievert	Sv	\N	\N
81	Gray	Gy	\N	\N
82	Sievert pro Stunde	Sv/h	\N	\N
83	Gray pro Stunde	Gy/h	\N	\N
85	Impulse pro Sekunde	Ips	\N	\N
90	Prozent	%	%	\N
91	Kurs in Winkelgraden	Grad	\N	\N
92	Grad Celsius	Grad C	\N	\N
93	Windstärke in Beaufort	Bft	\N	\N
94	Salinität	So/oo	\N	\N
95	Anzahl der Personen/Einwohner	PERS	\N	\N
96	Milli-Siemens pro Zentimeter	mS/cm	\N	\N
97	Kilo-Becquerel pro Quadratmeter	kBq/	KBQ/M2	\N
68	Becquerel pro Tag	Bq/d	BQ/D	\N
86	Milli-Sievert pro Jahr	mSv/a	\N	\N
100	Nano-Gray pro Stunde	nGy/h	\N	\N
101	Becquerel pro Gramm Feuchtmasse	Bq/g(FM)	\N	\N
102	Kilo-Becquerel pro Kubikmeter	kBq/	KBQ/M3	\N
103	Kilo-Becquerel pro Liter	kBq/l	KBQ/L	\N
104	Kilo-Becquerel pro Kilogramm Feuchtmasse	kBq/kg(FM)	\N	\N
105	Mikro-Becquerel pro Kubikmeter	µBq/	UBQ/M3	\N
106	Mikro-Becquerel pro Kilogramm Feuchtmasse 	µBq/kg(FM)	\N	\N
107	Nano-Becquerel pro Kubikmeter	nBq/	NBQ/M3	\N
108	Nano-Becquerel pro Liter	nBq/l	NBQ/L	\N
109	Milli-Becquerel pro Kilogramm Feuchtmasse	mBq/kg(FM)	\N	\N
110	Milli-Becquerel pro Quadratmeter	mBq/	MBQ/M2	\N
111	Mega-Becquerel pro Quadratmeter	MBq/	KKBQ/M2	\N
112	Mega-Becquerel pro Quadratkilometer	MBq/km²	KKBQ/KM2	\N
113	Pico-Curie pro Gramm	pCi/g(FM)	PCI/G	\N
114	Pico-Curie pro Kubikmeter	pCi/	PCI/M3	\N
115	Pico-Curie pro Liter	pCi/l	PCI/L	\N
116	Nano-Curie pro Kilogramm	nCi/kg(FM)	\N	\N
117	Nano-Curie pro Quadratmeter	nCi/	NCI/M2	\N
118	Curie pro Quadratmeter	Ci/	\N	\N
159	Mikro-Becquerel pro Kilogramm	µBq/kg	UBQ/KG	\N
160	Becquerel pro Gramm	Bq/g	BQ/G	\N
161	Kilo-Becquerel pro Kilogramm	kBq/kg	KBQ/KG	\N
162	Milli-Becquerel pro Kilogramm	mBq/kg	MBQ/KG	\N
163	Mikro-Becquerel pro Kilogramm Trockenmasse	µBq/kg(TM)	\N	\N
164	Becquerel pro Gramm Trockenmasse	Bq/g(TM)	\N	\N
166	Milli-Becquerel pro Kilogramm Trockenmasse	mBq/kg(TM)	\N	\N
187	Hekto-Pascal	hPa	\N	\N
188	Millimeter pro Stunde	mm/h	\N	\N
247	Becquerel pro Quadratzentimeter	Bq/cm²	\N	\N
269	Probe	Probe	\N	\N
268	Becquerel pro Probe	Bq/Probe	\N	\N
267	Becquerel  pro Milliliter	Bq/ml	\N	\N
270	Becquerel pro Impulse pro Sekunde	Bq/Ips	\N	\N
271	Watt pro Quadratmeter	W/	\N	\N
272	Millimeter pro Minute	mm/min	\N	\N
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)