users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
entity_user_grants.users_id entity_user_grants_fk_2 C
external_identifiers.users_id external_identifiers_fk_1 R
families.users_id families_fk_1 R
group_members.users_id group_members_fk_1 R
identities.users_id identities_fk_2 R
identity_provider_links.users_id identity_provider_links_fk_3 R
previous_passwords.users_id previous_passwords_fk_1 R
raw_logins.users_id raw_logins_fk_2 R
refresh_tokens.users_id refresh_tokens_fk_1 R
scim_external_id_users.users_id scim_external_id_users_fk_2 R
user_action_logs.actionee_users_id user_action_logs_fk_2 R
user_action_logs.actioner_users_id user_action_logs_fk_1 R
user_comments.commenter_id user_comments_fk_2 R
user_comments.users_id user_comments_fk_1 R
user_consents.giver_users_id user_consents_fk_2 R
user_consents.users_id user_consents_fk_3 R
user_registrations.users_id user_registrations_fk_2 R
webauthn_credentials.users_id webauthn_credentials_fk_2 R
active bool 1 null
breached_password_last_checked_instant int8 19 √ null
breached_password_status int2 5 √ null
birth_date bpchar 10 √ null
clean_speak_id uuid 2147483647 √ null
connectors_id uuid 2147483647 √ null
data text 2147483647 √ null
expiry int8 19 √ null
first_name varchar 255 √ null
full_name varchar 255 √ null
image_url text 2147483647 √ null
insert_instant int8 19 null
last_name varchar 255 √ null
last_login_instant int8 19 √ null
last_update_instant int8 19 null
middle_name varchar 255 √ null
mobile_phone varchar 255 √ null
parent_email varchar 255 √ null
password varchar 2048 √ null
password_change_reason int2 5 √ null
password_change_required bool 1 √ null
password_encryption_scheme varchar 255 √ null
password_factor int4 10 √ null
password_last_update_instant int8 19 √ null
password_salt varchar 255 √ null
tenants_id uuid 2147483647 null
tenants.id users_fk_1 R
timezone varchar 255 √ null
verified_instant int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
users_i_1 Performance Asc clean_speak_id
users_i_2 Performance Asc parent_email

Relationships

Close relationships within degrees of separation