Table harbinger.public.patient_events
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('patient_events_id_seq'::regclass)
patient_mrn_id int8 19
patient_mrns.id patient_events_patient_mrn_fk R
visit_id int8 19  √  null
visits.id patient_events_visit_fk R
external_system_status_id int8 19
external_system_statuses.id patient_events_universal_event_type_fk R
site_class_id int8 19  √  null
site_classes.id patient_events_site_class_fk R
postevent_site_sublocation_id int8 19  √  null
site_sublocations.id patient_events_site_sublocation_after_event_fk R
operator_employee_id int8 19  √  null
employees.id patient_events_operator_employee_id R
event_reason_id int8 19  √  null
reasons.id patient_events_event_reason_id_fk R
event_time timestamptz 35,6
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc patient_event_id
patient_mrn_id + visit_id Performance Asc/Asc patient_events_dm_idx
event_reason_id Performance Asc patient_events_event_reason_id_idx
external_system_status_id Performance Asc patient_events_external_system_status_id_idx
patient_mrn_id Performance Asc patient_events_extsys_idx
operator_employee_id Performance Asc patient_events_operator_employee_id_idx
patient_mrn_id Performance Asc patient_events_patient_mrn_id_idx
site_class_id Performance Asc patient_events_site_class_idx
postevent_site_sublocation_id Performance Asc patient_events_site_sublocation_idx
visit_id Performance Asc patient_events_visit_id_idx

Close relationships  within of separation: