Table harbinger.public.visits
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('visits_id_seq'::regclass)
card_cases.visit_id card_cases_visit_fk R
claims.visit_id claim_visit_fk R
orders.visit_id visits_orders_fk R
patient_demos.visit_id visit_fk R
patient_demos_history.visit_id visit_fk R
patient_events.visit_id patient_events_visit_fk R
patient_events_history.visit_id patient_events_history_visit_fk R
rad_exams.visit_id rad_exam_visit_fk R
radonc_cases.visit_id radonc_cases_visit_fk R
visit_diagnoses.visit_id visit_diagnoses_visit_fk R
visit_insurance_policies.visit_id visit_insurance_policies_visit_fk R
visit_number text 2147483647  √  null
external_system_id int8 19 external_system_id_fk R
patient_mrn_id int8 19 patient_mrn_id_fk R
site_id int8 19  √  null visits_site_fk R
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc visit_id
external_system_id + visit_number Performance Asc/Asc visits_dm_idx
external_system_id Performance Asc visits_extsys_idx
patient_mrn_id Performance Asc visits_patient_mrn_id_idx
site_id Performance Asc visits_site_id_idx
visit_number Performance Asc visits_visit_idx

Close relationships  within of separation: