SWDB
← Versions / 6.7.7.1 /

state_machine_history

Fields (12)

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
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
referenced_id binary(16) NO MUL NULL
referenced_version_id binary(16) NO NULL
integration_id binary(16) YES MUL NULL

Indexes (7)

Name Columns Unique
fk.state_machine_history.from_state_id from_state_id No
fk.state_machine_history.integration_id integration_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
idx.state_machine_history.referenced_entity referenced_id,referenced_version_id No
PRIMARY id Yes

Relations From (5)

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