app_approval_workflow_version

0 rows


Description

Table to store workflow configuration

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_workflow_version_id_seq'::regclass)
app_approval_application.workflow_version_id Defined in XMLR
app_approval_workflow_stage.workflow_version_id Defined in XMLR
workflow_id int8 19 null
app_approval_workflow.id Defined in XMLR
form_version_id int8 19 null
app_approval_form_version.id Defined in XMLR
status int2 5 null
created int8 19 null
updated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_apprworkvers_id_pk Primary key Asc id
app_apprworkvers_for_ix Performance Asc form_version_id
app_apprworkvers_sta_ix Performance Asc status
app_apprworkvers_wor_ix Performance Asc workflow_id

Relationships

Close relationships within degrees of separation