program_workflow_participant


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_workflow_log.owner_id FK_edpf3gt9atu0auf7j6oge36un R
version BIGINT 19 0
anybody BIT 1 b'0'
archived BIT 1 √ null
company_id INT 10 √ null
sys_companies.company_id FK_pxic3r88936136qqla6s1kup4 R
company_email_id BIGINT 19 √ null
company_email.id FK_jll0h8k70vvyma7wkjsoo7ubj R
type_id BIGINT 19 null
program_workflow_participant_type.id FK_h36kpkb5t3k9aynqeq339k8uo R
user_id INT 10 √ null
sys_users.user_id FK_su2pap5il1sqrd3xu3bqr44gk R
workflow_id BIGINT 19 null
program_workflow.id FK_thxhdci6kj1keylwun9fw479b R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_h36kpkb5t3k9aynqeq339k8uo Performance Asc type_id
FK_jll0h8k70vvyma7wkjsoo7ubj Performance Asc company_email_id
FK_pxic3r88936136qqla6s1kup4 Performance Asc company_id
FK_su2pap5il1sqrd3xu3bqr44gk Performance Asc user_id
FK_thxhdci6kj1keylwun9fw479b Performance Asc workflow_id

Relationships

Close relationships within degrees of separation