common.interface_status

Field Type Null Default Key Extra Comment
ifs_id int(11) NO PRI auto_increment
ifs_if_id int(11) YES MUL ID of interface this deals with. Must be NULL if `ifs_lif_id` is filled.
ifs_lif_id int(11) YES ID of lab interface this deals with. Must be NULL if `ifs_if_id` is filled.
ifs_last_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ifs_last_started timestamp YES Timestamp of last time this interface began processing.
ifs_last_finished timestamp YES Timestamp of last time this interface finished processing.
ifs_last_message varchar(100) YES String describing status of last execution of this interface.
ifs_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ifs_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References