ecmerrorcode_history


Description

When a record is deleted from ecmerrorcode_active, it should be stored here, for reporting purposes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idunit int4 10 null
unit.idunit fk_ecmerrorcode_history_idunit R
midsrc int4 10 null
sidspn int4 10 null
fmi int4 10 null
ocurrencecount int4 10 null
activationdate timestamptz 35,6 null
deactivationdate timestamptz 35,6 null
ispid bool 1 null
idecmerrorcode_history bigserial 19 nextval('ecmerrorcode_history_idecmerrorcode_history_seq'::regclass)
iddevice int4 10 null

Indexes

Constraint Name Type Sort Column(s)
ecmerrorcode_history_pkey Primary key Asc idecmerrorcode_history
idx_ecmerrorcode_history_idunit Performance Asc idunit

Relationships