user_role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
lib_library.role fk_lib_role R
user_role_authorization.role fk_role_authorization_role R
user_user.role fk_user_role R
code VARCHAR 191 √ NULL
label VARCHAR 191 √ NULL
description VARCHAR 2000 √ NULL
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
superuser BIT 1 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
uniq_user_role_code Must be unique Asc code
uniq_user_role_label Must be unique Asc label

Relationships

Close relationships within degrees of separation