rbac_roles

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
rbac_role_access_list.ROLE_ID FK_OS_ACL_ROLER
rbac_roles.PARENT_ROLE_ID FK_OS_PARENT_ROLER
rbac_subject_roles.ROLE_ID FK_OS_SUB_ROLES_TO_ROLESR
NAME VARCHAR 64 null
PARENT_ROLE_ID BIGINT 19 √ null
rbac_roles.IDENTIFIER FK_OS_PARENT_ROLER
DESCRIPTION VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_PARENT_ROLE Performance Asc PARENT_ROLE_ID
NAME Must be unique Asc NAME

Relationships

Close relationships within degrees of separation