Mercurial > lada > lada-server
comparison db_schema/stammdaten_data_mess_einheit.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 -- TOC entry 4691 (class 0 OID 535743) | |
| 23 -- Dependencies: 256 | |
| 24 -- Data for Name: mess_einheit; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 25 -- | |
| 26 | |
| 27 COPY mess_einheit (id, beschreibung, einheit, eudf_messeinheit_id, umrechnungs_faktor_eudf) FROM stdin; | |
| 28 207 Becquerel pro Stunde Bq/h \N \N | |
| 29 227 Megawatt MW \N \N | |
| 30 120 Dezimeter dm \N \N | |
| 31 139 Kilo-Becquerel pro Kilogramm Trockenmasse kBq/kg(TM) KBQ/KG \N | |
| 32 99 Milli-Becquerel pro Liter mBq/l MBQ/L \N | |
| 33 59 Kilogramm pro Person kg/Person \N \N | |
| 34 84 Nano-Sievert pro Stunde nSv/h NSV/H \N | |
| 35 88 Milli-Bequerel pro Kubikmeter mBq/m³ MBQ/M3 \N | |
| 36 71 Mikro-Sievert µSv \N \N | |
| 37 72 Milli-Sievert mSv \N \N | |
| 38 73 Nano-Gray nGy \N \N | |
| 39 74 Mikro-Gray µGy \N \N | |
| 40 75 Milli-Gray mGy \N \N | |
| 41 76 Mikro-Sievert pro Stunde µSv/h USV/H \N | |
| 42 1 Millimeter mm MM \N | |
| 43 2 Zentimeter cm CM \N | |
| 44 3 Meter m M \N | |
| 45 4 Kilometer km \N \N | |
| 46 6 Quadratzentimeter cm² \N \N | |
| 47 7 Quadratmeter m² M2 \N | |
| 48 8 Quadratkilometer km² \N \N | |
| 49 9 Hektar ha \N \N | |
| 50 10 Kubikzentimeter cm³ \N \N | |
| 51 11 Kubikmeter m³ \N \N | |
| 52 13 Sekunde s \N \N | |
| 53 14 Minute min \N \N | |
| 54 15 Stunde h \N \N | |
| 55 16 Tag d \N \N | |
| 56 17 Woche Wo \N \N | |
| 57 18 Monat Mo \N \N | |
| 58 19 Jahr a \N \N | |
| 59 20 Gramm g G \N | |
| 60 21 Kilogramm kg KG \N | |
| 61 22 Tonne t \N \N | |
| 62 25 Milliliter ml \N \N | |
| 63 26 Zentiliter cl \N \N | |
| 64 27 Liter l L \N | |
| 65 28 Hektoliter hl \N \N | |
| 66 30 Kubikmeter pro Sekunde m³/s \N \N | |
| 67 31 Kubikmeter pro Minute m³/min \N \N | |
| 68 32 Kubikmeter pro Stunde m³/h \N \N | |
| 69 33 Kubikmeter pro Tag m³/d \N \N | |
| 70 35 Zentimeter pro Sekunde cm/s \N \N | |
| 71 36 Meter pro Sekunde m/s \N \N | |
| 72 37 Meter pro Minute m/min \N \N | |
| 73 69 Becquerel pro Tag und Person Bq/(d*p) BQ/D.P \N | |
| 74 70 Nano-Sievert nSv \N \N | |
| 75 98 Becquerel pro Quadratmeter und Tag Bq/(m²*d) BQ/M2/D \N | |
| 76 40 Liter pro Quadratmeter l/m² L/M2 \N | |
| 77 42 Liter pro Minute l/min \N \N | |
| 78 43 Liter pro Stunde l/h \N \N | |
| 79 44 Liter pro Tag l/d \N \N | |
| 80 45 Kilogramm pro Quadratmeter kg/m² KG/M2 \N | |
| 81 46 Kilogramm pro Kubikmeter kg/m³ KG/M3 \N | |
| 82 47 Milligramm pro Liter mg/l MG/L \N | |
| 83 48 Tonne pro Hektar t/ha \N \N | |
| 84 49 Kilogramm pro Tag kg/d \N \N | |
| 85 53 Tonnen pro Tag t/d \N \N | |
| 86 54 Tonnen pro Jahr t/a \N \N | |
| 87 55 Kilogramm pro Tag und Person kg/(d*p) \N \N | |
| 88 50 Kilogramm Trockenmasse kg(TM) \N \N | |
| 89 51 Kilogramm Feuchtmasse kg(FM) \N \N | |
| 90 52 Kilogramm Trockenmasse pro Kubikmeter kg(TM)/m³ \N \N | |
| 91 60 Becquerel Bq BQ \N | |
| 92 61 Becquerel pro Quadratmeter Bq/m² BQ/M2 \N | |
| 93 62 Becquerel pro Kubikmeter Bq/m³ BQ/M3 \N | |
| 94 63 Becquerel pro Liter Bq/l BQ/L \N | |
| 95 64 Becquerel pro Kilogramm Bq/kg BQ/KG \N | |
| 96 65 Becquerel pro Kilogramm Trockenmasse Bq/kg(TM) \N \N | |
| 97 66 Becquerel pro Kilogramm Glührückstand Bq/kg(GR) \N \N | |
| 98 67 Becquerel pro Kilogramm Feuchtmasse Bq/kg(FM) KBQ/KG \N | |
| 99 38 Millimeter pro Tag mm/d \N \N | |
| 100 77 Mikro-Sievert pro Tag µSv/d \N \N | |
| 101 78 Mikro-Gray pro Stunde µGy/h \N \N | |
| 102 79 Mikro-Gray pro Tag µGy/d \N \N | |
| 103 80 Sievert Sv \N \N | |
| 104 81 Gray Gy \N \N | |
| 105 82 Sievert pro Stunde Sv/h \N \N | |
| 106 83 Gray pro Stunde Gy/h \N \N | |
| 107 85 Impulse pro Sekunde Ips \N \N | |
| 108 90 Prozent % % \N | |
| 109 91 Kurs in Winkelgraden Grad \N \N | |
| 110 92 Grad Celsius Grad C \N \N | |
| 111 93 Windstärke in Beaufort Bft \N \N | |
| 112 94 Salinität So/oo \N \N | |
| 113 95 Anzahl der Personen/Einwohner PERS \N \N | |
| 114 96 Milli-Siemens pro Zentimeter mS/cm \N \N | |
| 115 97 Kilo-Becquerel pro Quadratmeter kBq/m² KBQ/M2 \N | |
| 116 68 Becquerel pro Tag Bq/d BQ/D \N | |
| 117 86 Milli-Sievert pro Jahr mSv/a \N \N | |
| 118 100 Nano-Gray pro Stunde nGy/h \N \N | |
| 119 101 Becquerel pro Gramm Feuchtmasse Bq/g(FM) \N \N | |
| 120 102 Kilo-Becquerel pro Kubikmeter kBq/m³ KBQ/M3 \N | |
| 121 103 Kilo-Becquerel pro Liter kBq/l KBQ/L \N | |
| 122 104 Kilo-Becquerel pro Kilogramm Feuchtmasse kBq/kg(FM) \N \N | |
| 123 105 Mikro-Becquerel pro Kubikmeter µBq/m³ UBQ/M3 \N | |
| 124 106 Mikro-Becquerel pro Kilogramm Feuchtmasse µBq/kg(FM) \N \N | |
| 125 107 Nano-Becquerel pro Kubikmeter nBq/m³ NBQ/M3 \N | |
| 126 108 Nano-Becquerel pro Liter nBq/l NBQ/L \N | |
| 127 109 Milli-Becquerel pro Kilogramm Feuchtmasse mBq/kg(FM) \N \N | |
| 128 110 Milli-Becquerel pro Quadratmeter mBq/m² MBQ/M2 \N | |
| 129 111 Mega-Becquerel pro Quadratmeter MBq/m² KKBQ/M2 \N | |
| 130 112 Mega-Becquerel pro Quadratkilometer MBq/km² KKBQ/KM2 \N | |
| 131 113 Pico-Curie pro Gramm pCi/g(FM) PCI/G \N | |
| 132 114 Pico-Curie pro Kubikmeter pCi/m³ PCI/M3 \N | |
| 133 115 Pico-Curie pro Liter pCi/l PCI/L \N | |
| 134 116 Nano-Curie pro Kilogramm nCi/kg(FM) \N \N | |
| 135 117 Nano-Curie pro Quadratmeter nCi/m² NCI/M2 \N | |
| 136 118 Curie pro Quadratmeter Ci/m² \N \N | |
| 137 159 Mikro-Becquerel pro Kilogramm µBq/kg UBQ/KG \N | |
| 138 160 Becquerel pro Gramm Bq/g BQ/G \N | |
| 139 161 Kilo-Becquerel pro Kilogramm kBq/kg KBQ/KG \N | |
| 140 162 Milli-Becquerel pro Kilogramm mBq/kg MBQ/KG \N | |
| 141 163 Mikro-Becquerel pro Kilogramm Trockenmasse µBq/kg(TM) \N \N | |
| 142 164 Becquerel pro Gramm Trockenmasse Bq/g(TM) \N \N | |
| 143 166 Milli-Becquerel pro Kilogramm Trockenmasse mBq/kg(TM) \N \N | |
| 144 187 Hekto-Pascal hPa \N \N | |
| 145 188 Millimeter pro Stunde mm/h \N \N | |
| 146 247 Becquerel pro Quadratzentimeter Bq/cm² \N \N | |
| 147 269 Probe Probe \N \N | |
| 148 268 Becquerel pro Probe Bq/Probe \N \N | |
| 149 267 Becquerel pro Milliliter Bq/ml \N \N | |
| 150 270 Becquerel pro Impulse pro Sekunde Bq/Ips \N \N | |
| 151 271 Watt pro Quadratmeter W/m² \N \N | |
| 152 272 Millimeter pro Minute mm/min \N \N | |
| 153 \. |