Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung | |||
mycar:software:db [2019/03/30 22:23] – added diagram admin | mycar:software:db [2019/03/30 22:37] (aktuell) – added table for trackid and gps admin | ||
---|---|---|---|
Zeile 15: | Zeile 15: | ||
</ | </ | ||
==== trip ==== | ==== trip ==== | ||
+ | ^ Spalte | ||
+ | | tripid | incremented trip number | integer | | ||
+ | | start | start time | unknown timestamp | | ||
+ | | end | end time | unknown timestamp | | ||
==== obd ==== | ==== obd ==== | ||
^ Spalte | ^ Spalte | ||
Zeile 26: | Zeile 30: | ||
| time | Tiem of dataset | unknown timestamp | | | time | Tiem of dataset | unknown timestamp | | ||
==== gps ==== | ==== gps ==== | ||
+ | ^ Spalte | ||
+ | | lat | Latitude | | ||
+ | | lon | Longitude | | ||
+ | | alt | Altitude | hight of device | | ||
+ | | time | Tiem of dataset | unknown timestamp | | ||
====== SQL Statements ====== | ====== SQL Statements ====== | ||
<sxh sql> | <sxh sql> | ||
select * FROM obd LEFT JOIN gps ON obd.time=gps.time LEFT JOIN trip ON obd.time> | select * FROM obd LEFT JOIN gps ON obd.time=gps.time LEFT JOIN trip ON obd.time> | ||
</ | </ |
×
iphelper toolbox
you see this when javscript or css is not working correct
Untested