Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Nächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
mycar:software:db [2019/03/07 08:51] – angelegt admin | mycar:software:db [2019/03/30 22:23] – added diagram admin | ||
---|---|---|---|
Zeile 5: | Zeile 5: | ||
====== schema ====== | ====== schema ====== | ||
{{ : | {{ : | ||
+ | |||
+ | As you can see here, there are no direct conections between the tables. Its quite flat. Therfor the logi is in the application (somehow). | ||
+ | |||
+ | ===== Tables ===== | ||
+ | < | ||
+ | graph TD; | ||
+ | | ||
+ | | ||
+ | </ | ||
+ | ==== trip ==== | ||
+ | ==== obd ==== | ||
+ | ^ Spalte | ||
+ | | 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 ==== | ||
+ | ====== SQL Statements ====== | ||
+ | <sxh sql> | ||
+ | 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