rbac_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
rbac_user_locations.user_id rbac_user_locations_user_id_fkey C
rbac_user_roles.user_id rbac_user_roles_user_id_fkey C
practice_id text 2147483647 null
schema_migrations.id Implied Constraint R
legacy_user_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
user_name text 2147483647 null
normalized_user_name text 2147483647 null
user_type int4 10 √ null
first_name text 2147483647 √ null
last_name text 2147483647 √ null
email text 2147483647 √ null
phone text 2147483647 √ null
is_active bool 1 true
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
rbac_users_pkey Primary key Asc id
rbac_users_legacy_user_idx Performance Asc/Asc practice_id + legacy_user_id
rbac_users_practice_active_idx Performance Asc/Asc/Asc practice_id + is_active + normalized_user_name
rbac_users_practice_id_normalized_user_name_key Must be unique Asc/Asc practice_id + normalized_user_name

Check Constraints

Constraint Name Constraint
rbac_users_normalized_user_name_check ((normalized_user_name <> ''::text))
rbac_users_user_name_check ((user_name <> ''::text))

Relationships

Close relationships within degrees of separation