workflow_participant_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
changed_type VARCHAR 255 null
completed DATETIME 23 null
new_value VARCHAR 100 √ null
old_value VARCHAR 100 √ null
participant_responsibility VARCHAR 255 null
participant_role VARCHAR 255 null
proxy_user_id INT 10 √ null
sys_users.user_id FK_nesa3b0lexo9uqotv96r9hiq3 R
user_id INT 10 null
sys_users.user_id FK_ldkprfuhkcyipyqnwj1iarxxm R
workflow_id BIGINT 19 null
workflow.id FK_qgwcel9i7037h9tbpldl0rbx1 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_ldkprfuhkcyipyqnwj1iarxxm Performance Asc user_id
FK_nesa3b0lexo9uqotv96r9hiq3 Performance Asc proxy_user_id
FK_qgwcel9i7037h9tbpldl0rbx1 Performance Asc workflow_id

Relationships

Close relationships within degrees of separation