users

66 rows


Description

User Information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('users_id_seq'::regclass)
dashboard.user_id fk_dashboard_user_id C
user_permission.user_id fk_user_permission_user_id C
user_property.user_id fk_user_property_user_id C
work_log.user_id fk_work_log_user_id N
user_name citext 2147483647 √ null
password text 2147483647 √ null
active bool 1 true
user_group_id int4 10 √ null
user_group.id fk_users_group R
full_name citext 2147483647 √ null
job_position text 2147483647 √ null
email text 2147483647 √ null
mobile text 2147483647 √ null
telephone text 2147483647 √ null
image bytea 2147483647 √ null
image_type text 2147483647 √ null
language_id int4 10 √ null
language.id fk_user_language N
image_url text 2147483647 √ null
image_bin bytea 2147483647 √ null
image_expire date 13 √ null
lang text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
idx_user_email Performance Asc email
idx_user_name Performance Asc user_name

Relationships

Close relationships within degrees of separation