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