program_workflow


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_workflow_log.workflow_id FK_a0x2yfm3m1b9qeqtt93spgpou R
program_workflow_participant.workflow_id FK_thxhdci6kj1keylwun9fw479b R
program_workflow_participant_history.workflow_id FK_98y2nj9ap0b7ydf9aaigt56k9 R
version BIGINT 19 null
completed DATETIME 19 √ null
created DATETIME 19 √ null
current_id BIGINT 19 √ null
program_workflow_log.id FK_qyngqr9lfx0avxpcets7l1add R
iteration INT 10 null
program_id BIGINT 19 null
program.id FK_1ufc40kbcsjgayxmf6ywfmpgn R
published_file_id BIGINT 19 √ null
program_file.id FK_gasdkt7mql4ca7c13i3gtyq7l R
type_id BIGINT 19 null
program_workflow_type.id FK_rn2em56rgem4gubwcihfnqyva R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1ufc40kbcsjgayxmf6ywfmpgn Performance Asc program_id
FK_gasdkt7mql4ca7c13i3gtyq7l Performance Asc published_file_id
FK_qyngqr9lfx0avxpcets7l1add Performance Asc current_id
FK_rn2em56rgem4gubwcihfnqyva Performance Asc type_id

Relationships

Close relationships within degrees of separation