app_role_capabilities

1717 rows


Description

permission has to be signed, overriding a capability for a particular role in a particular context

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_role_capabilities_id_seq'::regclass)
contextid int8 19 0
app_context.id Defined in XMLR
roleid int8 19 0
app_role.id Defined in XMLR
capability varchar 255 ''::character varying
app_capabilities.name Defined in XMLR
permission int8 19 0
timemodified int8 19 0
modifierid int8 19 0
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_rolecapa_id_pk Primary key Asc id
app_rolecapa_cap_ix Performance Asc capability
app_rolecapa_con_ix Performance Asc contextid
app_rolecapa_mod_ix Performance Asc modifierid
app_rolecapa_rol_ix Performance Asc roleid
app_rolecapa_rolcapper_ix Performance Asc/Asc/Asc roleid + capability + permission
app_rolecapa_rolconcap_uix Must be unique Asc/Asc/Asc roleid + contextid + capability

Relationships

Close relationships within degrees of separation