program_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_1x00qjf60alcfyegwhf6adkj2 R
user_id INT 10 null
sys_users.user_id FK_75ds9xcr7w00pt5d3filw04cj R
workflow_id BIGINT 19 null
program_workflow.id FK_98y2nj9ap0b7ydf9aaigt56k9 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1x00qjf60alcfyegwhf6adkj2 Performance Asc proxy_user_id
FK_75ds9xcr7w00pt5d3filw04cj Performance Asc user_id
FK_98y2nj9ap0b7ydf9aaigt56k9 Performance Asc workflow_id

Relationships

Close relationships within degrees of separation