ecmerrorcode_active


Description

To store only currently active ecm error codes, for alerts generation purposes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idecmevent int4 10 null
ecmevent_errorcode.idecmevent fk_ecmerrorcode_active_idecmevent R
idunit int4 10 √ null
unit.idunit fk_ecmerrorcode_active_idunit R
midsrc int4 10 √ null
sidspn int4 10 null
fmi int4 10 null
ocurrencecount int4 10 √ null
activationdate timestamptz 35,6 null
lastmodificationdate timestamptz 35,6 null
ispid bool 1 √ null
iddevice int4 10 null

Indexes

Constraint Name Type Sort Column(s)
ecmerrorcode_active_pkey Primary key Asc/Asc/Asc iddevice + sidspn + fmi

Relationships

Close relationships within degrees of separation