Table harbinger.public.patient_events_history
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_history_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_history_visit_fk R
external_system_status_id int8 19
external_system_statuses.id patient_events_history_universal_event_type_fk R
site_class_id int8 19  √  null
site_classes.id patient_events_history_site_class_fk R
postevent_site_sublocation_id int8 19  √  null
site_sublocations.id patient_events_history_postevent_site_sublocation_fk R
operator_employee_id int8 19  √  null
employees.id patient_events_history_operator_employee_id R
event_reason_id int8 19  √  null
reasons.id patient_events_history_event_reason_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_events_history_id
patient_mrn_id + visit_id Performance Asc/Asc patient_events_history_dm_idx
operator_employee_id Performance Asc patient_events_history_employee_idx
event_reason_id Performance Asc patient_events_history_event_reason_idx
external_system_status_id Performance Asc patient_events_history_external_system_status_idx
patient_mrn_id Performance Asc patient_events_history_extsys_idx
patient_mrn_id Performance Asc patient_events_history_patient_mrn_idx
site_class_id Performance Asc patient_events_history_site_class_idx
postevent_site_sublocation_id Performance Asc patient_events_history_site_sublocation_idx
visit_id Performance Asc patient_events_history_visit_idx

Close relationships  within of separation: