vw_ecm_snapshot


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
gps text 2147483647 √ null
num_satelites text 2147483647 √ null
rssi text 2147483647 √ null
serialnumber varchar 64 √ null
device_rnt.serialnumber Implied Constraint R
script_version varchar 2147483647 √ null
firmware varchar 50 √ null
latitude numeric 10,7 √ null
longitude numeric 10,7 √ null
description varchar 2147483647 √ null
iddevice int4 10 √ null
senddate timestamptz 35,6 √ null
j1939_odometer float8 17,17 √ null
j1939_speed float8 17,17 √ null
j1939_rpm float8 17,17 √ null
j1939_oil_temperature float8 17,17 √ null
j1939_coolant_temperature float8 17,17 √ null
j1939_consumed_fuel float8 17,17 √ null
j1939_total_idle_fuel float8 17,17 √ null
j1939_total_engine_hours float8 17,17 √ null
j1939_total_idle_hours float8 17,17 √ null
j1708_total_distance float8 17,17 √ null
j1708_speed float8 17,17 √ null
j1708_rpm float8 17,17 √ null
j1708_oil_temperature float8 17,17 √ null
j1708_coolant_temperature float8 17,17 √ null
j1708_consumed_fuel float8 17,17 √ null
j1708_total_idle_fuel float8 17,17 √ null
j1708_total_engine_hours float8 17,17 √ null
j1708_total_idle_hours float8 17,17 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views