appointments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
call_results.appointment_id ByRailsConventionConstraint R
communications.appointment_id ByRailsConventionConstraint R
treatment_group_memberships.appointment_id fk_rails_4b8f85a6e7 R
patient_id uuid 2147483647 null
patients.id ByRailsConventionConstraint R
facility_id uuid 2147483647 null
facilities.id fk_rails_81e897bb97 R
scheduled_date date 13 null
status varchar 2147483647 √ null
cancel_reason varchar 2147483647 √ null
device_created_at timestamp 29,6 null
device_updated_at timestamp 29,6 null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
remind_on date 13 √ null
agreed_to_visit bool 1 √ null
deleted_at timestamp 29,6 √ null
appointment_type varchar 2147483647 null
user_id uuid 2147483647 √ null
users.id ByRailsConventionConstraint R
creation_facility_id uuid 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
appointments_pkey Primary key Asc id
index_appointments_on_facility_id Performance Asc facility_id
index_appointments_on_patient_id Performance Asc patient_id
index_appointments_on_patient_id_and_scheduled_date Performance Asc/Desc patient_id + scheduled_date
index_appointments_on_patient_id_and_updated_at Performance Asc/Asc patient_id + updated_at
index_appointments_on_updated_at Performance Asc updated_at
index_appointments_on_user_id Performance Asc user_id
index_device_created_at_on_appts Performance Asc device_created_at

Relationships

Close relationships within degrees of separation