app_approval_workflow_stage

0 rows


Description

Table to store workflow stage configuration

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_workflow_stage_id_seq'::regclass)
app_approval_application_action.workflow_stage_id Defined in XML R
app_approval_application_activity.workflow_stage_id Defined in XML R
app_approval_application_submission.workflow_stage_id Defined in XML R
app_approval_workflow_stage_approval_level.workflow_stage_id Defined in XML R
app_approval_workflow_stage_formview.workflow_stage_id Defined in XML R
app_approval_workflow_stage_interaction.workflow_stage_id Defined in XML R
workflow_version_id int8 19 null
app_approval_workflow_version.id Defined in XML R
name varchar 255 ''::character varying
type_code int8 19 null
sortorder int8 19 0
active int2 5 1
created int8 19 null
updated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_apprworkstag_id_pk Primary key Asc id
app_apprworkstag_act_ix Performance Asc active
app_apprworkstag_nam_ix Performance Asc name
app_apprworkstag_wor_ix Performance Asc workflow_version_id

Relationships

Close relationships within degrees of separation