transition_id int(11) not_null auto_increment comment(Auto-incrementing transition ID)
objective_id varchar(36) not_null comment(Objective that transitioned)
old_status varchar(20) default null comment(Previous status (NULL for initial creation))
new_status varchar(20) not_null comment(New status after transition)
transition_reason text not_null comment(Explanation for the state change)
transitioned_at timestamp NULL default(current_timestamp) comment(When the transition occurred)

--
primary transition_id
idx_objective_id objective_id
idx_new_status new_status
idx_transitioned_at transitioned_at
idx_objective_transition objective_id transitioned_at

##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
