mycar:software:db

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
mycar:software:db [2019/03/30 22:23] – added diagram adminmycar:software:db [2019/03/30 22:37] (aktuell) – added table for trackid and gps admin
Zeile 15: Zeile 15:
 </flow> </flow>
 ==== trip ==== ==== trip ====
 +^ Spalte   ^ Beschreibung ^ unit ^
 +| tripid | incremented trip number | integer |
 +| start | start time | unknown timestamp |
 +| end | end time | unknown timestamp |
 ==== obd ==== ==== obd ====
 ^ Spalte   ^ Beschreibung ^ unit ^ ^ Spalte   ^ Beschreibung ^ unit ^
Zeile 26: Zeile 30:
 | time | Tiem of dataset | unknown timestamp | | time | Tiem of dataset | unknown timestamp |
 ==== gps ==== ==== gps ====
 +^ Spalte   ^ Beschreibung ^ unit ^
 +| 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>trip.start AND obd.time<trip.end 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> </sxh>
× iphelper toolbox

you see this when javscript or css is not working correct

Untested
IP Address:
First usable:
Subnet:
Last usable:
CIDR:
Amount of usable:
Network address:
Reverse address:
Broadcast address:

 

  • mycar/software/db.1553984624.txt.gz
  • Zuletzt geändert: 2019/03/30 22:23
  • von admin