Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mycar:software:db [2019/03/08 08:37] – [schema] 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 | % |
+| temp | Engine Coolant Temperature | Celsius |
+| rpm | Engine RPM | rev/min (rpm)|
+| vss | vehicle speed sensor | km/h |
+| iat | Intake Air Temperature | Celsius |
+| maf | mass air flow sensor | g/s |
+| throttlepos | Absolute Throttle Position | % |
+| 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