Role Names Table Schema (role_names)


Description

role names in native strings

role_names table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
roleid BIGINT 19 0
role.id rolename_rol2_fk R
contextid BIGINT 19 0
context.id rolename_con2_fk R
name VARCHAR 255

Table contained -1 rows

role_names table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolename_con_ix Performance Asc contextid
rolename_rol_ix Performance Asc roleid
rolename_rolcon_uix Must be unique Asc/Asc roleid + contextid

role_names table relationships

Close relationships within degrees of separation