app_approval_role_capability_map

0 rows


Description

Capability to role map

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_approval_role_capability_map_id_seq'::regclass)
instanceid int8 19 null
contextlevel int8 19 null
roleid int8 19 null
app_role.id Defined in XML R
capabilityid int8 19 null
app_capabilities.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_apprrolecapamap_id_pk Primary key Asc id
app_apprrolecapamap_cap_ix Performance Asc capabilityid
app_apprrolecapamap_inscon_ix Performance Asc/Asc instanceid + contextlevel
app_apprrolecapamap_inscon_uix Must be unique Asc/Asc/Asc/Asc instanceid + contextlevel + roleid + capabilityid
app_apprrolecapamap_rol_ix Performance Asc roleid

Relationships