user_authorization


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
user_role_authorization.user_authorization fk_role_authorization_authorization R
code VARCHAR 191 √ NULL
label VARCHAR 191 √ NULL
description VARCHAR 2000 √ NULL
module VARCHAR 255 √ 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()

Indexes

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

Relationships

Close relationships within degrees of separation