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 = "3-52" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4231853 | 4231853 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:10:32.000000 | 13 | 18 | 2024-05-06 05:10:32+02:00 | 5 |
| 4231852 | 4231852 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:10:19.000000 | 24 | 24 | 2024-05-06 05:10:19+02:00 | 0 |
| 4231851 | 4231851 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:09:15.000000 | 26 | 22 | 2024-05-06 05:09:15+02:00 | -4 |
| 4231850 | 4231850 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:08:04.000000 | 37 | 39 | 2024-05-06 05:08:04+02:00 | 2 |
| 4231849 | 4231849 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:07:54.000000 | 29 | 26 | 2024-05-06 05:07:54+02:00 | -3 |
| 4231848 | 4231848 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:07:43.000000 | 34 | 27 | 2024-05-06 05:07:43+02:00 | -7 |
| 4231847 | 4231847 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:06:40.000000 | 28 | 28 | 2024-05-06 05:06:40+02:00 | 0 |
| 4231846 | 4231846 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:06:29.000000 | 28 | 27 | 2024-05-06 05:06:29+02:00 | -1 |
| 4231845 | 4231845 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:05:09.000000 | 20 | 35 | 2024-05-06 05:05:09+02:00 | 15 |
| 4231844 | 4231844 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 05:00:55.000000 | 24 | 26 | 2024-05-06 05:00:55+02:00 | 2 |
| 4231843 | 4231843 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:57:44.000000 | 24 | 23 | 2024-05-06 04:57:44+02:00 | -1 |
| 4231842 | 4231842 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:55:20.000000 | 32 | 33 | 2024-05-06 04:55:20+02:00 | 1 |
| 4231841 | 4231841 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:55:11.000000 | 26 | 31 | 2024-05-06 04:55:11+02:00 | 5 |
| 4231840 | 4231840 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:50:17.000000 | 23 | 25 | 2024-05-06 04:50:17+02:00 | 2 |
| 4231839 | 4231839 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:50:07.000000 | 24 | 19 | 2024-05-06 04:50:07+02:00 | -5 |
| 4231838 | 4231838 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:47:32.000000 | 23 | 25 | 2024-05-06 04:47:32+02:00 | 2 |
| 4231837 | 4231837 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:43:55.000000 | 27 | 27 | 2024-05-06 04:43:55+02:00 | 0 |
| 4231836 | 4231836 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:43:07.000000 | 28 | 26 | 2024-05-06 04:43:07+02:00 | -2 |
| 4231835 | 4231835 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:42:34.000000 | 11 | 10 | 2024-05-06 04:42:34+02:00 | -1 |
| 4231834 | 4231834 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:41:18.000000 | 24 | 28 | 2024-05-06 04:41:18+02:00 | 4 |
| 4231833 | 4231833 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:39:19.000000 | 25 | 30 | 2024-05-06 04:39:19+02:00 | 5 |
| 4231832 | 4231832 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:38:19.000000 | 18 | 28 | 2024-05-06 04:38:19+02:00 | 10 |
| 4231831 | 4231831 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:36:53.000000 | 19 | 27 | 2024-05-06 04:36:53+02:00 | 8 |
| 4231830 | 4231830 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:34:54.000000 | 15 | 30 | 2024-05-06 04:34:54+02:00 | 15 |
| 4231829 | 4231829 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:29:54.000000 | 20 | 22 | 2024-05-06 04:29:54+02:00 | 2 |
| 4231828 | 4231828 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:29:48.000000 | 20 | 30 | 2024-05-06 04:29:48+02:00 | 10 |
| 4231827 | 4231827 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:29:42.000000 | 24 | 23 | 2024-05-06 04:29:42+02:00 | -1 |
| 4231826 | 4231826 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:28:40.000000 | 23 | 26 | 2024-05-06 04:28:40+02:00 | 3 |
| 4231825 | 4231825 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:27:00.000000 | 18 | 23 | 2024-05-06 04:27:00+02:00 | 5 |
| 4231824 | 4231824 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:26:54.000000 | 16 | 26 | 2024-05-06 04:26:54+02:00 | 10 |
| 4231823 | 4231823 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:23:08.000000 | 20 | 25 | 2024-05-06 04:23:08+02:00 | 5 |
| 4231822 | 4231822 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:19:36.000000 | 18 | 27 | 2024-05-06 04:19:36+02:00 | 9 |
| 4231821 | 4231821 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:17:37.000000 | 29 | 29 | 2024-05-06 04:17:37+02:00 | 0 |
| 4231820 | 4231820 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:15:46.000000 | 26 | 24 | 2024-05-06 04:15:46+02:00 | -2 |
| 4231819 | 4231819 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:15:44.000000 | 20 | 27 | 2024-05-06 04:15:44+02:00 | 7 |
| 4231818 | 4231818 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:15:05.000000 | 26 | 19 | 2024-05-06 04:15:05+02:00 | -7 |
| 4231817 | 4231817 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:14:43.000000 | 25 | 25 | 2024-05-06 04:14:43+02:00 | 0 |
| 4231816 | 4231816 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:14:40.000000 | 17 | 22 | 2024-05-06 04:14:40+02:00 | 5 |
| 4231815 | 4231815 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:11:50.000000 | 16 | 29 | 2024-05-06 04:11:50+02:00 | 13 |
| 4231814 | 4231814 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:10:45.000000 | 30 | 32 | 2024-05-06 04:10:45+02:00 | 2 |
| 4231813 | 4231813 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:08:54.000000 | 25 | 26 | 2024-05-06 04:08:54+02:00 | 1 |
| 4231812 | 4231812 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:06:54.000000 | 29 | 37 | 2024-05-06 04:06:54+02:00 | 8 |
| 4231811 | 4231811 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:05:46.000000 | 27 | 25 | 2024-05-06 04:05:46+02:00 | -2 |
| 4231810 | 4231810 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:05:05.000000 | 18 | 27 | 2024-05-06 04:05:05+02:00 | 9 |
| 4231809 | 4231809 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 04:01:05.000000 | 31 | 22 | 2024-05-06 04:01:05+02:00 | -9 |
| 4231808 | 4231808 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:58:00.000000 | 23 | 26 | 2024-05-06 03:58:00+02:00 | 3 |
| 4231807 | 4231807 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:57:10.000000 | 13 | 24 | 2024-05-06 03:57:10+02:00 | 11 |
| 4231806 | 4231806 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:56:59.000000 | 18 | 20 | 2024-05-06 03:56:59+02:00 | 2 |
| 4231805 | 4231805 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:56:10.000000 | 16 | 27 | 2024-05-06 03:56:10+02:00 | 11 |
| 4231804 | 4231804 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:56:06.000000 | 26 | 26 | 2024-05-06 03:56:06+02:00 | 0 |
| 4231803 | 4231803 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:54:18.000000 | 16 | 28 | 2024-05-06 03:54:18+02:00 | 12 |
| 4231802 | 4231802 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:52:49.000000 | 25 | 30 | 2024-05-06 03:52:49+02:00 | 5 |
| 4231801 | 4231801 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:52:44.000000 | 24 | 31 | 2024-05-06 03:52:44+02:00 | 7 |
| 4231800 | 4231800 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:51:31.000000 | 28 | 29 | 2024-05-06 03:51:31+02:00 | 1 |
| 4231799 | 4231799 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:50:43.000000 | 20 | 25 | 2024-05-06 03:50:43+02:00 | 5 |
| 4231798 | 4231798 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:46:05.000000 | 29 | 24 | 2024-05-06 03:46:05+02:00 | -5 |
| 4231797 | 4231797 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:45:38.000000 | 27 | 24 | 2024-05-06 03:45:38+02:00 | -3 |
| 4231796 | 4231796 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:44:18.000000 | 17 | 26 | 2024-05-06 03:44:18+02:00 | 9 |
| 4231795 | 4231795 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:41:55.000000 | 24 | 27 | 2024-05-06 03:41:55+02:00 | 3 |
| 4231794 | 4231794 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:38:03.000000 | 24 | 22 | 2024-05-06 03:38:03+02:00 | -2 |
| 4231793 | 4231793 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:37:11.000000 | 31 | 33 | 2024-05-06 03:37:11+02:00 | 2 |
| 4231792 | 4231792 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:36:21.000000 | 29 | 26 | 2024-05-06 03:36:21+02:00 | -3 |
| 4231791 | 4231791 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:32:51.000000 | 27 | 31 | 2024-05-06 03:32:51+02:00 | 4 |
| 4231790 | 4231790 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:31:24.000000 | 28 | 26 | 2024-05-06 03:31:24+02:00 | -2 |
| 4231789 | 4231789 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:31:20.000000 | 26 | 20 | 2024-05-06 03:31:20+02:00 | -6 |
| 4231788 | 4231788 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:29:22.000000 | 14 | 20 | 2024-05-06 03:29:22+02:00 | 6 |
| 4231787 | 4231787 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:27:47.000000 | 24 | 20 | 2024-05-06 03:27:47+02:00 | -4 |
| 4231786 | 4231786 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:24:52.000000 | 29 | 28 | 2024-05-06 03:24:52+02:00 | -1 |
| 4231785 | 4231785 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:23:44.000000 | 24 | 8 | 2024-05-06 03:23:44+02:00 | -16 |
| 4231784 | 4231784 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:22:54.000000 | 32 | 25 | 2024-05-06 03:22:54+02:00 | -7 |
| 4231783 | 4231783 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:20:58.000000 | 26 | 22 | 2024-05-06 03:20:58+02:00 | -4 |
| 4231782 | 4231782 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:20:22.000000 | 29 | 25 | 2024-05-06 03:20:22+02:00 | -4 |
| 4231781 | 4231781 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:15:07.000000 | 18 | 17 | 2024-05-06 03:15:07+02:00 | -1 |
| 4231780 | 4231780 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:13:29.000000 | 27 | 28 | 2024-05-06 03:13:29+02:00 | 1 |
| 4231779 | 4231779 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:09:51.000000 | 33 | 32 | 2024-05-06 03:09:51+02:00 | -1 |
| 4231778 | 4231778 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:07:51.000000 | 27 | 27 | 2024-05-06 03:07:51+02:00 | 0 |
| 4231777 | 4231777 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:07:41.000000 | 23 | 33 | 2024-05-06 03:07:41+02:00 | 10 |
| 4231776 | 4231776 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:05:07.000000 | 31 | 25 | 2024-05-06 03:05:07+02:00 | -6 |
| 4231775 | 4231775 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 03:03:44.000000 | 34 | 33 | 2024-05-06 03:03:44+02:00 | -1 |
| 4231774 | 4231774 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:57:04.000000 | 26 | 23 | 2024-05-06 02:57:04+02:00 | -3 |
| 4231773 | 4231773 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:56:27.000000 | 40 | 36 | 2024-05-06 02:56:27+02:00 | -4 |
| 4231772 | 4231772 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:56:19.000000 | 20 | 23 | 2024-05-06 02:56:19+02:00 | 3 |
| 4231771 | 4231771 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:56:04.000000 | 19 | 20 | 2024-05-06 02:56:04+02:00 | 1 |
| 4231770 | 4231770 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:55:42.000000 | 23 | 19 | 2024-05-06 02:55:42+02:00 | -4 |
| 4231769 | 4231769 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:54:31.000000 | 31 | 30 | 2024-05-06 02:54:31+02:00 | -1 |
| 4231768 | 4231768 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:53:10.000000 | 28 | 29 | 2024-05-06 02:53:10+02:00 | 1 |
| 4231767 | 4231767 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:49:30.000000 | 25 | 19 | 2024-05-06 02:49:30+02:00 | -6 |
| 4231766 | 4231766 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:47:27.000000 | 30 | 35 | 2024-05-06 02:47:27+02:00 | 5 |
| 4231765 | 4231765 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:47:15.000000 | 26 | 35 | 2024-05-06 02:47:15+02:00 | 9 |
| 4231764 | 4231764 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:45:16.000000 | 28 | 24 | 2024-05-06 02:45:16+02:00 | -4 |
| 4231763 | 4231763 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:44:12.000000 | 25 | 22 | 2024-05-06 02:44:12+02:00 | -3 |
| 4231762 | 4231762 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:43:50.000000 | 17 | 22 | 2024-05-06 02:43:50+02:00 | 5 |
| 4231761 | 4231761 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:41:54.000000 | 28 | 26 | 2024-05-06 02:41:54+02:00 | -2 |
| 4231760 | 4231760 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:41:18.000000 | 20 | 27 | 2024-05-06 02:41:18+02:00 | 7 |
| 4231759 | 4231759 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:38:32.000000 | 24 | 23 | 2024-05-06 02:38:32+02:00 | -1 |
| 4231758 | 4231758 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:37:47.000000 | 29 | 30 | 2024-05-06 02:37:47+02:00 | 1 |
| 4231757 | 4231757 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:37:27.000000 | 28 | 26 | 2024-05-06 02:37:27+02:00 | -2 |
| 4231756 | 4231756 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:36:50.000000 | 25 | 26 | 2024-05-06 02:36:50+02:00 | 1 |
| 4231755 | 4231755 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:33:00.000000 | 29 | 30 | 2024-05-06 02:33:00+02:00 | 1 |
| 4231754 | 4231754 | Hegenheimerstrasse 3-52 | 52 | 3 | Nachmessung | 2024-05-06 | 02:32:25.000000 | 19 | 22 | 2024-05-06 02:32:25+02:00 | 3 |
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");