users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
encounter_participants.user_id fk_encounter_participants_user N
encounters.rendering_user_id fk_encounters_rendering_user R
encounters.supervising_user_id fk_encounters_supervising_user N
user_credentials.user_id user_credentials_ibfk_1 C
user_hr_documents.user_id fk_user_hr_documents_user C
user_rates.user_id user_rates_ibfk_2 C
user_signatures.user_id fk_user_signatures_user C
email VARCHAR 255 null
phone VARCHAR 50 √ null
npi VARCHAR 20 √ null
medicaid_number VARCHAR 50 √ null
caqh_number VARCHAR 50 √ null
chart_id VARCHAR 50 √ null
title VARCHAR 100 √ null
hiring_date DATE 10 √ null
driver_license_number VARCHAR 50 √ null
ssn VARCHAR 255 √ null
is_contractor BIT 1 √ 0
company_name VARCHAR 255 √ null
shedlock.name Implied Constraint R
company_ein VARCHAR 20 √ null
profile_image_url VARCHAR 500 √ null
first_name VARCHAR 100 null
last_name VARCHAR 100 null
birth_date DATE 10 √ null
preferred_language VARCHAR 50 √ null
languages TEXT 65535 √ null
gender VARCHAR 20 √ null
timezone VARCHAR 100 √ null
color VARCHAR 7 √ null
role VARCHAR 20 null
credential_type VARCHAR 50 √ null
cognito_sub VARCHAR 255 √ null
is_active BIT 1 √ 1
status VARCHAR 20 √ ACTIVE
has_alert BIT 1 √ 0
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ null
created_by VARCHAR 255 √ system
updated_by VARCHAR 255 √ system
location_business_line_id VARCHAR 36 √ null
location_business_lines.id fk_users_location_business_line R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_cognito_sub Performance Asc cognito_sub
idx_email Performance Asc email
idx_users_location_business_line_id Performance Asc location_business_line_id
uk_tenant_email Must be unique Asc email

Relationships

Close relationships within degrees of separation