component_statuslog

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

ID for each log entry, unique index

component_id INT UNSIGNED 10 null
component.id component_statuslog_ibfk_1C

id from the component table

status BIT 3 0

The status that the component was changed TO

message TEXT 65535 NULL
timestamp TIMESTAMP 19 current_timestamp()

When the status of the component was changed

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
component_statuslog_component_id_index Performance Asc component_id

Relationships