staff_payment_statement_status_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
statement_id VARCHAR 36 null
staff_payment_statements.id fk_sps_history_statement C
from_status VARCHAR 20 √ null
to_status VARCHAR 20 null
action VARCHAR 50 null
reason VARCHAR 255 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null
occurred_at DATETIME 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_sps_history_statement Performance Asc statement_id

Relationships

Close relationships within degrees of separation