t18release
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
app_approval_approver
0
rows
Description
Table to store workflow assignment/override approvers
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
bigserial
19
√
nextval('app_approval_approver_id_seq'::regclass)
approval_id
int8
19
null
app_approval
.id
Defined in XML
R
workflow_stage_approval_level_id
int8
19
null
app_approval_workflow_stage_approval_level
.id
Defined in XML
R
type
int2
5
null
identifier
int8
19
null
active
int2
5
1
created
int8
19
null
updated
int8
19
null
ancestor_id
int8
19
√
null
Showing 1 to 9 of 9 entries
Previous
1
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
app_apprappr_id_pk
Primary key
Asc
id
app_apprappr_act_ix
Performance
Asc
active
app_apprappr_anc_ix
Performance
Asc
ancestor_id
app_apprappr_app_ix
Performance
Asc
approval_id
app_apprappr_appwortypide_uix
Must be unique
Asc
/
Asc
/
Asc
/
Asc
approval_id + workflow_stage_approval_level_id + type + identifier
app_apprappr_typide_ix
Performance
Asc
/
Asc
type + identifier
app_apprappr_wor_ix
Performance
Asc
workflow_stage_approval_level_id
Showing 1 to 7 of 7 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
