program_workflow_type_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
completed DATETIME 23 null
event_type VARCHAR 30 √ null
new_value VARCHAR 100 √ null
old_value VARCHAR 100 √ null
property VARCHAR 255 null
proxy_user_id INT 10 √ null
sys_users.user_id FK_692v62ie46mebyc1kq3w8r6a9 R
responsibility_name VARCHAR 100 √ null
user_id INT 10 null
sys_users.user_id FK_lxmo578rqafhent5ng933brg8 R
workflow_type_id BIGINT 19 null
program_workflow_type.id FK_9htg2o1x8iasgep9ux22wxixj R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_692v62ie46mebyc1kq3w8r6a9 Performance Asc proxy_user_id
FK_9htg2o1x8iasgep9ux22wxixj Performance Asc workflow_type_id
FK_lxmo578rqafhent5ng933brg8 Performance Asc user_id

Relationships

Close relationships within degrees of separation