patient_phone_numbers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
exotel_phone_number_details.patient_phone_number_id fk_rails_b7da75c721 R
number varchar 2147483647 √ null
phone_type varchar 2147483647 √ null
active bool 1 √ null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
patient_id uuid 2147483647 √ null
patients.id fk_rails_0145dd0b05 R
device_created_at timestamp 29,6 null
device_updated_at timestamp 29,6 null
deleted_at timestamp 29,6 √ null
dnd_status bool 1 true

Indexes

Constraint Name Type Sort Column(s)
patient_phone_numbers_pkey Primary key Asc id
index_patient_phone_numbers_on_deleted_at Performance Asc deleted_at
index_patient_phone_numbers_on_dnd_status Performance Asc dnd_status
index_patient_phone_numbers_on_patient_id Performance Asc patient_id

Relationships

Close relationships within degrees of separation