ecmevent_errorcode


Description

ECM data related to operative error codes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idecmevent int8 19 null
ecmerrorcode_active.idecmevent fk_ecmerrorcode_active_idecmevent R
idevent int8 19 null
idunit int4 10 √ null
unit.idunit fk_ecmevent_errorcode_idunit R
idecmeventtype int4 10 null
ecmeventtype.idecmeventtype fk_ecmevent_errorcode_idecmeventtype R
idecmperiodicity int4 10 null
ecmperiodicity.idecmperiodicity fk_ecmevent_errorcode_idecmperiodicity R
idecmreason int4 10 null
ecmreason.idecmreason fk_ecmevent_errorcode_idecmreason R
idecmbus int4 10 null
ecmbus.idecmbus fk_ecmevent_errorcode_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
midsrc int4 10 √ null
sidspn int4 10 null
fmi int4 10 null
ocurrencecount int4 10 √ null
isactive bool 1 √ null
lampstatus int4 10 √ null
ispid bool 1 √ null
iddevice int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_ecmevent_errorcode Primary key Asc idecmevent
ecmevent_errorcode_senddate_idx Performance Asc senddate

Relationships

Close relationships within degrees of separation