app_role_capabilities

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 7 of 7 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation