users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
accesses.user_id fk_rails_e47574ce84 R
appointments.user_id ByRailsConventionConstraint R
blood_pressures.user_id ByRailsConventionConstraint R
blood_sugars.user_id fk_rails_7c63b0ef2d R
call_results.user_id ByRailsConventionConstraint R
deduplication_logs.user_id ByRailsConventionConstraint R
drug_stocks.user_id fk_rails_8eb7cdedd2 R
facilities_teleconsultation_medical_officers.user_id ByRailsConventionConstraint R
medical_histories.user_id ByRailsConventionConstraint R
observations.user_id fk_rails_60d667a791 R
patient_attributes.user_id fk_rails_565c8c1260 R
prescription_drugs.user_id ByRailsConventionConstraint R
teleconsultations.medical_officer_id fk_rails_3e1ccaa4cb R
teleconsultations.requested_medical_officer_id fk_rails_4aa89bd48e R
teleconsultations.requester_id fk_rails_c436ea0008 R
user_authentications.user_id ByRailsConventionConstraint R
full_name varchar 2147483647 √ null
sync_approval_status varchar 2147483647 null
sync_approval_status_reason varchar 2147483647 √ null
device_updated_at timestamp 29,6 null
device_created_at timestamp 29,6 null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
deleted_at timestamp 29,6 √ null
role varchar 2147483647 √ null
organization_id uuid 2147483647 √ null
organizations.id ByRailsConventionConstraint R
access_level varchar 2147483647 √ null
teleconsultation_phone_number varchar 2147483647 √ null
teleconsultation_isd_code varchar 2147483647 √ null
receive_approval_notifications bool 1 true

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
index_gin_users_on_full_name Performance
index_users_on_access_level Performance Asc access_level
index_users_on_deleted_at Performance Asc deleted_at
index_users_on_organization_id Performance Asc organization_id
index_users_on_teleconsultation_phone_number Performance Asc teleconsultation_phone_number

Relationships

Close relationships within degrees of separation