user_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
lot_lot.provider fk_lot_provider R
proj_project.provider fk_project_provider R
proj_project_user.proj_user fk_proj_user_project_user R
workflow_group_user.workflow_user fk_workflow_group_user_user R
login VARCHAR 191 √ NULL
password VARCHAR 191 √ NULL
firstname VARCHAR 255 √ NULL
surname VARCHAR 255 √ NULL
function VARCHAR 255 √ NULL
category VARCHAR 255 √ NULL
role VARCHAR 191 null
user_role.identifier fk_user_role R
library VARCHAR 191 null
lib_library.identifier fk_user_library R
dashboard VARCHAR 191 √ NULL
user_dashboard.identifier fk_user_dashboard R
address VARCHAR 191 √ NULL
user_address.identifier fk_user_address R
email VARCHAR 255 null
phone_number VARCHAR 255 √ NULL
active BIT 1 √ NULL
lang VARCHAR 191 √ NULL
company_name 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()
superuser BIT 1 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_user_address Performance Asc address
fk_user_dashboard Performance Asc dashboard
fk_user_library Performance Asc library
fk_user_role Performance Asc role
idx_user_user_login Must be unique Asc login
uniq_user_user_login Must be unique Asc login

Relationships

Close relationships within degrees of separation