program_workflow_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_workflow.current_id FK_qyngqr9lfx0avxpcets7l1add R
version BIGINT 19 null
action VARCHAR 255 √ null
actor_id INT 10 √ null
sys_users.user_id FK_croe3r4g0q4yt2g5ie53dr39 R
assigned DATETIME 19 √ null
completed DATETIME 19 √ null
due DATETIME 19 √ null
error VARCHAR 255 √ null
file_id BIGINT 19 √ null
program_file.id FK_bf5r00hkf89qhvsa0mjhyk1vm R
iteration INT 10 null
notes LONGTEXT 2147483647 √ null
owner_id BIGINT 19 √ null
program_workflow_participant.id FK_edpf3gt9atu0auf7j6oge36un R
owner_role_id INT 10 √ null
sys_roles.role_id FK_ovsj67dje3wmrxr73p9wjsoes R
proxy_user_id INT 10 √ null
sys_users.user_id FK_k0ryptxgmp5wpo2qqato40s62 R
round INT 10 null
status VARCHAR 255 null
timeout INT 10 null
triggered BIT 1 null
workflow_id BIGINT 19 null
program_workflow.id FK_a0x2yfm3m1b9qeqtt93spgpou R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_a0x2yfm3m1b9qeqtt93spgpou Performance Asc workflow_id
FK_bf5r00hkf89qhvsa0mjhyk1vm Performance Asc file_id
FK_croe3r4g0q4yt2g5ie53dr39 Performance Asc actor_id
FK_edpf3gt9atu0auf7j6oge36un Performance Asc owner_id
FK_k0ryptxgmp5wpo2qqato40s62 Performance Asc proxy_user_id
FK_ovsj67dje3wmrxr73p9wjsoes Performance Asc owner_role_id

Relationships

Close relationships within degrees of separation