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 | ||
| entity_id | json | 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) | YES | NULL | STORED GENERATED | |
| referenced_version_id | binary(16) | YES | NULL | STORED GENERATED |
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 |