ecmevent


Description

Parent table for ECM data,no events should be stored here, children tables should be used instead: ecmevent_parameter,ecmevent_incidence,ecmevent_rpmspeed, ecmevent_errorcode depending on idecmeventtype

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_idunit R
idecmeventtype int4 10 null
ecmeventtype.idecmeventtype fk_ecmevent_idecmeventtype R
idecmperiodicity int4 10 null
idecmreason int4 10 null
ecmreason.idecmreason fk_ecmevent_idecmreason R
idecmbus int4 10 null
ecmbus.idecmbus fk_ecmevent_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)
ecmevent_pkey Primary key Asc idecmevent

Relationships

Close relationships within degrees of separation