ecmevent_parameter


Description

ECM data related with operative parameters or readings such as Odometer, Total Consumed Fuel, Coolant temperature

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_parameter_idunit R
idecmeventtype int4 10 null
ecmeventtype.idecmeventtype fk_ecmevent_parameter_idecmeventtype R
idecmperiodicity int4 10 null
ecmperiodicity.idecmperiodicity fk_ecmevent_parameter_idecmperiodicity R
idecmreason int4 10 null
ecmreason.idecmreason fk_ecmevent_parameter_idecmreason R
idecmbus int4 10 null
ecmbus.idecmbus fk_ecmevent_parameter_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
iddevice int4 10 null

Indexes

Constraint Name Type Sort Column(s)
pk_ecmevent_parameter Primary key Asc idecmevent
idx_ecmevent_parameter_receivedate Performance Asc receivedate
idx_ecmevent_parameter_senddate Performance Asc senddate

Relationships

Close relationships within degrees of separation