ecmevent_rpmspeed


Description

ECM data depicting how many seconds were spent by the unit at a particular speed / rpm cuadrant (columns: speed 0-100+ 20km ranges, rows: rpm 0-2500+ 500rpm ranges)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idecmevent int8 19 null
idevent int8 19 null
idunit int4 10 √ null
unit.idunit fk_ecmevent_rpmspeed_idunit R
idecmeventtype int4 10 null
ecmeventtype.idecmeventtype fk_ecmevent_rpmspeed_idecmeventtype R
idecmperiodicity int4 10 null
ecmperiodicity.idecmperiodicity fk_ecmevent_rpmspeed_idecmperiodicity R
idecmreason int4 10 null
ecmreason.idecmreason fk_ecmevent_rpmspeed_idecmreason R
idecmbus int4 10 null
ecmbus.idecmbus fk_ecmevent_rpmspeed_idecmbus R
rawstring varchar 2147483647 null
clid int4 10 √ null
senddate timestamptz 35,6 null
receivedate timestamptz 35,6 null
latitude numeric 10,7 null
longitude numeric 10,7 null
ignition_on bool 1 √ null
rpmspeedmatrix _float8 17,17 √ null
iddevice int4 10 null

Indexes

Constraint Name Type Sort Column(s)
pk_ecmevent_rpmspeed Primary key Asc idecmevent

Relationships

Close relationships within degrees of separation