SWDB
← Versions / 6.3.2.1 /

state_machine_history

Fields (10)

Name Type Null Key Default Extra
id binary(16) NO PRI NULL
state_machine_id binary(16) NO MUL NULL
entity_name varchar(100) NO NULL
entity_id longtext NO NULL
from_state_id binary(16) NO MUL NULL
to_state_id binary(16) NO MUL NULL
action_name varchar(255) NO NULL
user_id binary(16) YES MUL NULL
created_at datetime(3) NO NULL
updated_at datetime(3) YES NULL

Indexes (5)

Name Columns Unique
fk.state_machine_history.from_state_id from_state_id No
fk.state_machine_history.state_machine_id state_machine_id No
fk.state_machine_history.to_state_id to_state_id No
fk.state_machine_history.user_id user_id No
PRIMARY id Yes

Relations From (4)

from_state_id state_machine_state . id
state_machine_id state_machine . id
to_state_id state_machine_state . id
user_id user . id