Capabilities Table Schema (capabilities)


Description

this defines all capabilities

capabilities table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
name varchar 255
role_capabilities.capability rolecapa_cap2_fk R
captype varchar 50
contextlevel bigint 10 0
component varchar 100
riskbitmask bigint 10 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