users

86 rows


Description

User Information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('users_id_seq'::regclass)
login_challenge.user_id fk_login_challenge_user C
service_client.created_by service_client_created_by_fkey N
service_client.revoked_by service_client_revoked_by_fkey N
service_client.rotated_by service_client_rotated_by_fkey N
service_grant.created_by service_grant_created_by_fkey N
service_grant.updated_by service_grant_updated_by_fkey N
user_session.user_id fk_user_session_user C
dashboard.user_id fk_dashboard_user_id C
user_app_access.user_id fk_user_app_access_user_id C
user_permission.user_id fk_user_permission_user_id C
user_permission_override.user_id fk_user_permission_override_user_id C
user_property.user_id fk_user_property_user_id C
user_roles.user_id fk_user_roles_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
image_url text 2147483647 √ null
image_bin bytea 2147483647 √ null
image_expire date 13 √ null
lang text 2147483647 √ null
uid uuid 2147483647 uuidv7()
policy_accepted bool 1 false

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
idx_users_active_email Must be unique Asc email

Check Constraints

Constraint Name Constraint
chk_users_email_canonical ((email IS NULL) OR (email = NULLIF(lower(btrim(email)), ''::text)))

Relationships

Close relationships within degrees of separation