Capabilities Table Schema (capabilities)


Description

this defines all capabilities

capabilities table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
name VARCHAR 255
role_capabilities.capability rolecapa_cap2_fk R
captype VARCHAR 50
contextlevel BIGINT 19 0
component VARCHAR 100
riskbitmask BIGINT 19 0

Table contained -1 rows

capabilities table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
capa_nam_uix Must be unique Asc name

capabilities table relationships