ecmevent_incidence


Description

ECM data depicting acceleration, speed and break pedal pushing depth on the last seconds of harsh break event

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_incidence_idunit R
idecmeventtype int4 10 null
ecmeventtype.idecmeventtype fk_ecmevent_incidence_idecmeventtype R
idecmperiodicity int4 10 null
ecmperiodicity.idecmperiodicity fk_ecmevent_incidence_idecmperiodicity R
idecmreason int4 10 null
ecmreason.idecmreason fk_ecmevent_incidence_idecmreason R
idecmbus int4 10 null
ecmbus.idecmbus fk_ecmevent_incidence_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
incidencebuffer _float8 17,17 √ null
iddevice int4 10 null

Indexes

Constraint Name Type Sort Column(s)
pk_ecmevent_incidence Primary key Asc idecmevent
idx_incidence_iddevice Performance Asc iddevice
idx_incidence_senddate Performance Asc senddate

Relationships

Close relationships within degrees of separation