users

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.users_id_seq'::regclass)
action_plan_users.user_id fk_action_plan_users_usersC
action_plans.owner_id fk_action_plans_authorsC
checkin_summaries.changer_id fk_checkin_summaries_usersN
checkin_summary_reactions.user_id fk_checkin_summary_reactions_usersC
checkin_users.user_id fk_checkin_users_usersN
group_members.user_id fk_group_members_usersC
key_result_confidences.user_id fk_key_result_confidences_usersC
key_result_events.user_id fk_key_result_events_usersC
key_result_members.user_id fk_key_result_members_usersC
note_comment_reactions.user_id fk_note_comment_reactions_user_idC
note_comments.user_id fk_note_comments_usersC
note_reactions.user_id fk_note_reactions_usersC
note_users.user_id fk_note_users_usersC
notes.last_updated_user_id fk_notes_last_updated_user_idC
notes.user_id fk_notes_usersC
notifications.triggered_user_id fk_notifications_triggered_user_idC
notifications.user_id fk_notifications_user_idC
objective_confidences.user_id fk_objective_confidences_usersC
objective_events.user_id fk_objective_events_usersC
objective_members.user_id fk_objective_members_usersC
personal_note_comment_reactions.user_id fk_personal_note_comment_reactions_user_idC
personal_note_comments.user_id fk_personal_note_comments_usersC
personal_note_reactions.user_id fk_personal_note_reactions_usersC
personal_note_users.user_id fk_personal_note_users_usersC
personal_notes.author_id fk_personal_notes_authorsC
personal_notes.last_updated_user_id fk_personal_notes_last_updated_user_idC
personal_notes.user_id fk_personal_notes_usersC
smart_hr_employees.user_id fk_smart_hr_employees_usersR
user_bookmarks.user_id fk_user_bookmarks_usersC
user_oauths.user_id fk_user_oauths_usersC
user_organizations.user_id fk_user_organizations_usersC
user_settings.user_id fk_user_settings_usersC
last_name varchar 255 null
first_name varchar 255 null
email varchar 255 ''::character varying
encrypted_password varchar 255 ''::character varying
reset_password_token varchar 255 √ null
reset_password_sent_at timestamptz 35,6 √ null
current_sign_in_at timestamptz 35,6 √ null
current_sign_in_ip varchar 255 √ null
confirmation_token varchar 255 √ null
confirmed_at timestamptz 35,6 √ null
confirmation_sent_at timestamptz 35,6 √ null
unconfirmed_email varchar 255 √ null
failed_attempts int8 19 '0'::bigint
unlock_token varchar 255 √ null
locked_at timestamptz 35,6 √ null
admin bool 1 false
avatar varchar 255 √ null
disabled_at timestamptz 35,6 √ null
encrypted_otp_secret varchar 255 √ null
otp_required_for_login bool 1 false
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
saml_enabled bool 1 false
tenant_id int8 19 null
tenants.id fk_users_tenantsC
internal_use bool 1 false
display_order int4 10 0
last_updated_at timestamptz 35,6 √ null
phone_number varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
idx_users_on_confirmation_sent_at Performance Asc confirmation_sent_at
idx_users_on_confirmation_token Must be unique Asc confirmation_token
idx_users_on_email Must be unique
idx_users_on_reset_password_token Must be unique Asc reset_password_token
idx_users_on_tenant_id Performance Asc tenant_id
idx_users_on_unlock_token Must be unique Asc unlock_token

Check Constraints

Constraint Name Constraint
check_avatar_path (((avatar)::text ~ (('^avatars/'::text || id) || '/(.+)$'::text)))

Relationships

Close relationships within degrees of separation