public.vw_ecm_snapshot

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

int8

√

null

gps

text

2147483647

√

null

num_satelites

text

2147483647

√

null

rssi

text

2147483647

√

null

serialnumber

varchar

√

null

device_rnt.serialnumber

Implied Constraint

script_version

varchar

2147483647

√

null

firmware

varchar

√

null

latitude

numeric

10,7

√

null

longitude

numeric

10,7

√

null

description

varchar

2147483647

√

null

iddevice

int4

√

null

lastgpsdate

timestamptz

35,6

√

null

j1939_odometer

text

2147483647

√

null

j1939_speed

text

2147483647

√

null

j1939_rpm

text

2147483647

√

null

j1939_oil_temperature

text

2147483647

√

null

j1939_coolant_temperature

text

2147483647

√

null

j1939_consumed_fuel

text

2147483647

√

null

j1939_total_idle_fuel

text

2147483647

√

null

j1939_total_engine_hours

text

2147483647

√

null

j1939_total_idle_hours

text

2147483647

√

null

j1708_total_distance

text

2147483647

√

null

j1708_speed

text

2147483647

√

null

j1708_rpm

text

2147483647

√

null

j1708_oil_temperature

text

2147483647

√

null

j1708_coolant_temperature

text

2147483647

√

null

j1708_consumed_fuel

text

2147483647

√

null

j1708_total_idle_fuel

text

2147483647

√

null

j1708_total_engine_hours

text

2147483647

√

null

j1708_total_idle_hours

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT row_number() OVER () AS id,
        CASE
            WHEN ("substring"((((((d.others -> 'UNIT_STATUS'::text))::integer)::bit(8))::character varying(10))::text, 7, 1) = '0'::text) THEN 'OK'::text
            ELSE 'ERROR'::text
        END AS gps,
    (d.others -> 'satellites'::text) AS num_satelites,
    (d.others -> 'rssi'::text) AS rssi,
    d.serialnumber,
    d.script_version,
    d.firmware,
    d.latitude,
    d.longitude,
    pr.description,
    d.iddevice,
    d.lastgpsdate,
    (d.others -> 'j1939_Odometer'::text) AS j1939_odometer,
    (d.others -> 'j1939_EngineSpeed'::text) AS j1939_speed,
    (d.others -> 'j1939_rpm'::text) AS j1939_rpm,
    (d.others -> 'j1939_EngineOilTemp'::text) AS j1939_oil_temperature,
    (d.others -> 'j1939_EngineCoolantTemp'::text) AS j1939_coolant_temperature,
    (d.others -> 'j1939_TotalFuel'::text) AS j1939_consumed_fuel,
    (d.others -> 'j1939_TotalIdleFuel'::text) AS j1939_total_idle_fuel,
    (d.others -> 'j1939_TotalEngineHours'::text) AS j1939_total_engine_hours,
    (d.others -> 'j1939_TotalIdleHours'::text) AS j1939_total_idle_hours,
    (d.others -> 'j1708_Odometer'::text) AS j1708_total_distance,
    (d.others -> 'j1708_EngineSpeed'::text) AS j1708_speed,
    (d.others -> 'j1708_rpm'::text) AS j1708_rpm,
    (d.others -> 'j1708_EngineOilTemp'::text) AS j1708_oil_temperature,
    (d.others -> 'j1708_EngineCoolantTemp'::text) AS j1708_coolant_temperature,
    (d.others -> 'j1708_TotalFuel'::text) AS j1708_consumed_fuel,
    (d.others -> 'j1708_TotalIdleFuel'::text) AS j1708_total_idle_fuel,
    (d.others -> 'j1708_TotalEngineHours'::text) AS j1708_total_engine_hours,
    (d.others -> 'j1708_TotalIdleHours'::text) AS j1708_total_idle_hours
   FROM ((device d
     JOIN technicalaccount tec ON ((d.idtechnicalaccount = tec.idtechnicalaccount)))
     JOIN product pr ON ((pr.idproduct = tec.idproduct)));

public.vw_ecm_snapshot

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views