Einzelmessungen
- Messung_Datum
- Datum der Messung
- Messung_Timestamp
- Zeitpunkt der Messung
- Messung_Zeit
- Uhrzeit der Messung
- Phase
- Phase der Messung (Vormessung, Betrieb, Nachmessung oder nach Ende)
- V_Ausfahrt
- Ausfahrtsgeschwindigkeit in km/h
- V_Delta
- Differenz zwischen Einfahrts- und Ausfahrtsgeschwindigkeit in km/h
- V_Einfahrt
- Einfahrtsgeschwindigkeit in km/h
- Zyklus
- Messzyklus
- id_standort
- Eindeutige Standortkennung
>10,000 rows count all where ID = "1-57" sorted by Messung_Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Messung_Datum, Messung_Datum (date), Messung_Timestamp (date)
| Link | rowid | ID | id_standort | Zyklus | Phase | Messung_Datum | Messung_Zeit | V_Einfahrt | V_Ausfahrt | Messung_Timestamp ▲ | V_Delta |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 17155245 | 17155245 | Erlenmattstrasse 1-57 | 57 | 1 | Nach Ende | 2023-07-10 | 12:51:34.000000 | 15 | 14 | 2023-07-10 12:51:34+02:00 | -1 |
| 17155244 | 17155244 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:36:45.000000 | 27 | 26 | 2023-07-10 12:36:45+02:00 | -1 |
| 17155243 | 17155243 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:29:02.000000 | 16 | 20 | 2023-07-10 12:29:02+02:00 | 4 |
| 17155242 | 17155242 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:14:48.000000 | 25 | 23 | 2023-07-10 12:14:48+02:00 | -2 |
| 17155241 | 17155241 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:12:13.000000 | 17 | 22 | 2023-07-10 12:12:13+02:00 | 5 |
| 17155240 | 17155240 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 12:04:04.000000 | 25 | 27 | 2023-07-10 12:04:04+02:00 | 2 |
| 17155239 | 17155239 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:57:32.000000 | 14 | 12 | 2023-07-10 11:57:32+02:00 | -2 |
| 17155238 | 17155238 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:09:14.000000 | 30 | 28 | 2023-07-10 11:09:14+02:00 | -2 |
| 17155237 | 17155237 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:06:09.000000 | 23 | 30 | 2023-07-10 11:06:09+02:00 | 7 |
| 17155236 | 17155236 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 11:04:07.000000 | 18 | 12 | 2023-07-10 11:04:07+02:00 | -6 |
| 17155235 | 17155235 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 10:39:59.000000 | 24 | 32 | 2023-07-10 10:39:59+02:00 | 8 |
| 17155234 | 17155234 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 10:30:00.000000 | 23 | 25 | 2023-07-10 10:30:00+02:00 | 2 |
| 17155233 | 17155233 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:55:37.000000 | 19 | 15 | 2023-07-10 09:55:37+02:00 | -4 |
| 17155232 | 17155232 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:50:13.000000 | 25 | 31 | 2023-07-10 09:50:13+02:00 | 6 |
| 17155231 | 17155231 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:27:37.000000 | 17 | 18 | 2023-07-10 09:27:37+02:00 | 1 |
| 17155230 | 17155230 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:18:13.000000 | 16 | 13 | 2023-07-10 09:18:13+02:00 | -3 |
| 17155229 | 17155229 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 09:00:31.000000 | 24 | 26 | 2023-07-10 09:00:31+02:00 | 2 |
| 17155228 | 17155228 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 08:50:31.000000 | 10 | 13 | 2023-07-10 08:50:31+02:00 | 3 |
| 17155227 | 17155227 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 08:00:19.000000 | 30 | 25 | 2023-07-10 08:00:19+02:00 | -5 |
| 17155226 | 17155226 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:54:25.000000 | 20 | 18 | 2023-07-10 07:54:25+02:00 | -2 |
| 17155225 | 17155225 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:53:24.000000 | 15 | 18 | 2023-07-10 07:53:24+02:00 | 3 |
| 17155224 | 17155224 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:51:30.000000 | 17 | 15 | 2023-07-10 07:51:30+02:00 | -2 |
| 17155223 | 17155223 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:34:31.000000 | 20 | 14 | 2023-07-10 07:34:31+02:00 | -6 |
| 17155222 | 17155222 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:27:43.000000 | 13 | 16 | 2023-07-10 07:27:43+02:00 | 3 |
| 17155221 | 17155221 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:21:23.000000 | 16 | 11 | 2023-07-10 07:21:23+02:00 | -5 |
| 17155220 | 17155220 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:17:55.000000 | 12 | 17 | 2023-07-10 07:17:55+02:00 | 5 |
| 17155219 | 17155219 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 07:04:34.000000 | 20 | 19 | 2023-07-10 07:04:34+02:00 | -1 |
| 17155218 | 17155218 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 06:57:29.000000 | 19 | 19 | 2023-07-10 06:57:29+02:00 | 0 |
| 17155217 | 17155217 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 06:38:47.000000 | 10 | 13 | 2023-07-10 06:38:47+02:00 | 3 |
| 17155216 | 17155216 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 05:21:34.000000 | 32 | 24 | 2023-07-10 05:21:34+02:00 | -8 |
| 17155215 | 17155215 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 05:19:27.000000 | 30 | 34 | 2023-07-10 05:19:27+02:00 | 4 |
| 17155214 | 17155214 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 03:23:02.000000 | 13 | 10 | 2023-07-10 03:23:02+02:00 | -3 |
| 17155213 | 17155213 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 00:54:05.000000 | 19 | 26 | 2023-07-10 00:54:05+02:00 | 7 |
| 17155212 | 17155212 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-10 | 00:14:59.000000 | 23 | 27 | 2023-07-10 00:14:59+02:00 | 4 |
| 17155211 | 17155211 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 23:25:58.000000 | 12 | 10 | 2023-07-09 23:25:58+02:00 | -2 |
| 17155210 | 17155210 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 22:07:50.000000 | 31 | 25 | 2023-07-09 22:07:50+02:00 | -6 |
| 17155209 | 17155209 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 20:49:58.000000 | 20 | 22 | 2023-07-09 20:49:58+02:00 | 2 |
| 17155208 | 17155208 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 20:36:43.000000 | 27 | 27 | 2023-07-09 20:36:43+02:00 | 0 |
| 17155207 | 17155207 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:59:15.000000 | 32 | 16 | 2023-07-09 19:59:15+02:00 | -16 |
| 17155206 | 17155206 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:50:53.000000 | 18 | 16 | 2023-07-09 19:50:53+02:00 | -2 |
| 17155205 | 17155205 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:40:40.000000 | 35 | 23 | 2023-07-09 19:40:40+02:00 | -12 |
| 17155204 | 17155204 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:27:51.000000 | 26 | 20 | 2023-07-09 19:27:51+02:00 | -6 |
| 17155203 | 17155203 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:22:05.000000 | 20 | 18 | 2023-07-09 19:22:05+02:00 | -2 |
| 17155202 | 17155202 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:16:09.000000 | 15 | 20 | 2023-07-09 19:16:09+02:00 | 5 |
| 17155201 | 17155201 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:13:22.000000 | 15 | 19 | 2023-07-09 19:13:22+02:00 | 4 |
| 17155200 | 17155200 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:05:43.000000 | 25 | 29 | 2023-07-09 19:05:43+02:00 | 4 |
| 17155199 | 17155199 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 19:02:40.000000 | 17 | 31 | 2023-07-09 19:02:40+02:00 | 14 |
| 17155198 | 17155198 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 18:33:07.000000 | 23 | 35 | 2023-07-09 18:33:07+02:00 | 12 |
| 17155197 | 17155197 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:41:13.000000 | 27 | 29 | 2023-07-09 17:41:13+02:00 | 2 |
| 17155196 | 17155196 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:19:17.000000 | 26 | 32 | 2023-07-09 17:19:17+02:00 | 6 |
| 17155195 | 17155195 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 17:19:05.000000 | 23 | 25 | 2023-07-09 17:19:05+02:00 | 2 |
| 17155194 | 17155194 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:48:28.000000 | 30 | 23 | 2023-07-09 16:48:28+02:00 | -7 |
| 17155193 | 17155193 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:32:54.000000 | 27 | 26 | 2023-07-09 16:32:54+02:00 | -1 |
| 17155192 | 17155192 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:31:35.000000 | 18 | 12 | 2023-07-09 16:31:35+02:00 | -6 |
| 17155191 | 17155191 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:30:21.000000 | 15 | 12 | 2023-07-09 16:30:21+02:00 | -3 |
| 17155190 | 17155190 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 16:24:57.000000 | 19 | 22 | 2023-07-09 16:24:57+02:00 | 3 |
| 17155189 | 17155189 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 15:50:29.000000 | 15 | 9 | 2023-07-09 15:50:29+02:00 | -6 |
| 17155188 | 17155188 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 15:05:47.000000 | 23 | 19 | 2023-07-09 15:05:47+02:00 | -4 |
| 17155187 | 17155187 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 13:48:41.000000 | 12 | 15 | 2023-07-09 13:48:41+02:00 | 3 |
| 17155186 | 17155186 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 12:43:41.000000 | 12 | 14 | 2023-07-09 12:43:41+02:00 | 2 |
| 17155185 | 17155185 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 12:37:58.000000 | 27 | 24 | 2023-07-09 12:37:58+02:00 | -3 |
| 17155184 | 17155184 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:23:19.000000 | 15 | 24 | 2023-07-09 11:23:19+02:00 | 9 |
| 17155183 | 17155183 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:03:46.000000 | 17 | 20 | 2023-07-09 11:03:46+02:00 | 3 |
| 17155182 | 17155182 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 11:01:03.000000 | 32 | 25 | 2023-07-09 11:01:03+02:00 | -7 |
| 17155181 | 17155181 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 10:27:18.000000 | 23 | 31 | 2023-07-09 10:27:18+02:00 | 8 |
| 17155180 | 17155180 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 10:05:18.000000 | 17 | 11 | 2023-07-09 10:05:18+02:00 | -6 |
| 17155179 | 17155179 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:29:25.000000 | 28 | 33 | 2023-07-09 09:29:25+02:00 | 5 |
| 17155178 | 17155178 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:18:18.000000 | 12 | 4 | 2023-07-09 09:18:18+02:00 | -8 |
| 17155177 | 17155177 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 09:02:15.000000 | 14 | 12 | 2023-07-09 09:02:15+02:00 | -2 |
| 17155176 | 17155176 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:53:04.000000 | 16 | 20 | 2023-07-09 08:53:04+02:00 | 4 |
| 17155175 | 17155175 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:43:37.000000 | 20 | 25 | 2023-07-09 08:43:37+02:00 | 5 |
| 17155174 | 17155174 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 08:41:46.000000 | 14 | 12 | 2023-07-09 08:41:46+02:00 | -2 |
| 17155173 | 17155173 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 07:38:39.000000 | 14 | 12 | 2023-07-09 07:38:39+02:00 | -2 |
| 17155172 | 17155172 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 06:11:25.000000 | 26 | 17 | 2023-07-09 06:11:25+02:00 | -9 |
| 17155171 | 17155171 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 05:52:10.000000 | 16 | 13 | 2023-07-09 05:52:10+02:00 | -3 |
| 17155170 | 17155170 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 04:18:05.000000 | 20 | 20 | 2023-07-09 04:18:05+02:00 | 0 |
| 17155169 | 17155169 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 03:38:21.000000 | 17 | 18 | 2023-07-09 03:38:21+02:00 | 1 |
| 17155168 | 17155168 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:43:32.000000 | 19 | 13 | 2023-07-09 02:43:32+02:00 | -6 |
| 17155167 | 17155167 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:29:28.000000 | 20 | 13 | 2023-07-09 02:29:28+02:00 | -7 |
| 17155166 | 17155166 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 02:17:28.000000 | 25 | 22 | 2023-07-09 02:17:28+02:00 | -3 |
| 17155165 | 17155165 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 01:25:39.000000 | 7 | 8 | 2023-07-09 01:25:39+02:00 | 1 |
| 17155164 | 17155164 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:45:47.000000 | 12 | 17 | 2023-07-09 00:45:47+02:00 | 5 |
| 17155163 | 17155163 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:37:03.000000 | 20 | 15 | 2023-07-09 00:37:03+02:00 | -5 |
| 17155162 | 17155162 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-09 | 00:24:32.000000 | 20 | 18 | 2023-07-09 00:24:32+02:00 | -2 |
| 17155161 | 17155161 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 23:46:04.000000 | 3 | 3 | 2023-07-08 23:46:04+02:00 | 0 |
| 17155160 | 17155160 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:59:13.000000 | 19 | 16 | 2023-07-08 22:59:13+02:00 | -3 |
| 17155159 | 17155159 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:47:58.000000 | 26 | 24 | 2023-07-08 22:47:58+02:00 | -2 |
| 17155158 | 17155158 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 22:17:45.000000 | 27 | 26 | 2023-07-08 22:17:45+02:00 | -1 |
| 17155157 | 17155157 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 21:20:22.000000 | 13 | 12 | 2023-07-08 21:20:22+02:00 | -1 |
| 17155156 | 17155156 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 21:17:57.000000 | 7 | 3 | 2023-07-08 21:17:57+02:00 | -4 |
| 17155155 | 17155155 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:46:48.000000 | 23 | 28 | 2023-07-08 20:46:48+02:00 | 5 |
| 17155154 | 17155154 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:24:16.000000 | 13 | 20 | 2023-07-08 20:24:16+02:00 | 7 |
| 17155153 | 17155153 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 20:06:39.000000 | 14 | 15 | 2023-07-08 20:06:39+02:00 | 1 |
| 17155152 | 17155152 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 19:48:48.000000 | 23 | 19 | 2023-07-08 19:48:48+02:00 | -4 |
| 17155151 | 17155151 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 19:17:15.000000 | 14 | 12 | 2023-07-08 19:17:15+02:00 | -2 |
| 17155150 | 17155150 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:40:44.000000 | 19 | 20 | 2023-07-08 18:40:44+02:00 | 1 |
| 17155149 | 17155149 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:33:16.000000 | 7 | 4 | 2023-07-08 18:33:16+02:00 | -3 |
| 17155148 | 17155148 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:27:30.000000 | 11 | 13 | 2023-07-08 18:27:30+02:00 | 2 |
| 17155147 | 17155147 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:15:01.000000 | 16 | 23 | 2023-07-08 18:15:01+02:00 | 7 |
| 17155146 | 17155146 | Erlenmattstrasse 1-57 | 57 | 1 | Nachmessung | 2023-07-08 | 18:11:36.000000 | 23 | 28 | 2023-07-08 18:11:36+02:00 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen (
ID TEXT,
id_standort INTEGER,
Zyklus INTEGER,
Phase TEXT,
Messung_Datum TEXT,
Messung_Zeit TEXT,
V_Einfahrt INTEGER,
V_Ausfahrt INTEGER,
Messung_Timestamp TEXT,
V_Delta INTEGER,
FOREIGN KEY (ID) REFERENCES Einsatzplan (ID) ON DELETE CASCADE
);
CREATE INDEX idx_Einzelmessungen_id ON "Einzelmessungen" ("ID");
CREATE INDEX idx_Einzelmessungen_id_standort ON "Einzelmessungen" ("id_standort");
CREATE INDEX idx_Einzelmessungen_zyklus ON "Einzelmessungen" ("Zyklus");
CREATE INDEX idx_Einzelmessungen_phase ON "Einzelmessungen" ("Phase");
CREATE INDEX idx_Einzelmessungen_messung_datum ON "Einzelmessungen" ("Messung_Datum");
CREATE INDEX idx_Einzelmessungen_messung_timestamp ON "Einzelmessungen" ("Messung_Timestamp");