Table harbinger.public.patient_demos_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_demos_history_id_seq'::regclass)
patient_mrn_id int8 19
patient_mrns.id patient_demos_history_patient_mrn_fk R
visit_id int8 19  √  null
visits.id visit_fk R
demographic_type_id int8 19
demographic_types.id demo_types_fk R
demographic text 2147483647
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_demos_history_id
demographic_type_id Performance Asc patient_demos_history_demographic_type_id_idx
patient_mrn_id + demographic_type_id Performance Asc/Asc patient_demos_history_dm_idx
patient_mrn_id Performance Asc patient_demos_history_patient_mrn_id_idx
visit_id Performance Asc patient_demos_history_visit_id_idx

Close relationships  within of separation: