Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mycar:software:db [2019/03/30 21:46] – time column admin
+++ mycar:software:db [2019/03/30 22:37] (aktuell) – added table for trackid and gps admin
@@ Zeile 9: / Zeile 9: @@
 ===== Tables =====
+<flow>
+graph TD;
+ obd.time-->trip;
+ gps.time-->trip;
+</flow>
 ==== trip ====
+^ Spalte   ^ Beschreibung ^ unit ^
+| tripid | incremented trip number | integer |
+| start | start time | unknown timestamp |
+| end | end time | unknown timestamp |
 ==== obd ====
 ^ Spalte   ^ Beschreibung ^ unit ^
 | load_pct | Calculated LOAD Value | % |
@@ Zeile 22: / Zeile 30: @@
 | time | Tiem of dataset | unknown timestamp |
 ==== gps ====
+^ Spalte   ^ Beschreibung ^ unit ^
+| lat | Latitude |
+| lon | Longitude |
+| alt | Altitude | hight of device |
+| time | Tiem of dataset | unknown timestamp |
+====== SQL Statements ======
+<sxh sql>
+select * FROM obd LEFT JOIN gps ON obd.time=gps.time LEFT JOIN trip ON obd.time>trip.start AND obd.time<trip.end
+</sxh>

× iphelper toolbox

you see this when javscript or css is not working correct

Untested

Input