rbac_subject_roles

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
SUBJECT_ID BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_SUB_ID_USER_IDR
ROLE_ID BIGINT 19 null
rbac_roles.IDENTIFIER FK_OS_SUB_ROLES_TO_ROLESR
SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_OS_SUB_ROLES_TO_SITER
CP_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK_OS_SUB_ROLES_TO_CPR
SYSTEM_ROLE BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_SUB_ID_USER_ID Performance Asc SUBJECT_ID
FK_OS_SUB_ROLES_TO_CP Performance Asc CP_ID
FK_OS_SUB_ROLES_TO_ROLES Performance Asc ROLE_ID
FK_OS_SUB_ROLES_TO_SITE Performance Asc SITE_ID

Relationships

Close relationships within degrees of separation