app_approval_dashboard_pending_application_user

0 rows


Description

Table to index users where user has view_in_dashboard_pending_application_user capability

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_dashboard_pending_application_user_id_seq'::regclass)
applicant_id int8 19 null
app_user.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_apprdashpendappluser_id_pk Primary key Asc id
app_apprdashpendappluser_a2_ix Performance Asc applicant_id
app_apprdashpendappluser_ap_ix Performance Asc/Asc/Asc applicant_id + workflow_stage_approval_level_id + user_id
app_apprdashpendappluser_us_ix Performance Asc user_id
app_apprdashpendappluser_wo_ix Performance Asc workflow_stage_approval_level_id

Relationships

Close relationships within degrees of separation