app_approval_dashboard_draft_application_any

0 rows


Description

Table to index assignments where user has view_draft_in_dashboard_application_any capability

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_approval_dashboard_draft_application_any_id_seq'::regclass)
approval_id int8 19 null
app_approval.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_apprdashdrafapplany_id_pk Primary key Asc id
app_apprdashdrafapplany_ap2_ix Performance Asc approval_id
app_apprdashdrafapplany_app_ix Performance Asc/Asc approval_id + user_id
app_apprdashdrafapplany_use_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation