app_approval_dashboard_pending_application_any

0 rows


Description

Table to index assignments where user has view_in_dashboard_pending_application_any capability

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_dashboard_pending_application_any_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
user_id int8 19 null
app_user.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_apprdashpendapplany_id_pk Primary key Asc id
app_apprdashpendapplany_ap2_ix Performance Asc approval_id
app_apprdashpendapplany_app_ix Performance Asc/Asc/Asc approval_id + workflow_stage_approval_level_id + user_id
app_apprdashpendapplany_use_ix Performance Asc user_id
app_apprdashpendapplany_wor_ix Performance Asc workflow_stage_approval_level_id

Relationships

Close relationships within degrees of separation