Table harbinger.public.patients
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('patients_id_seq'::regclass)
card_case_facts.patient_id ByRailsConventionConstraint R
patient_mrns.patient_id patient_mrns_patient_fk R
rad_exam_facts.patient_id ByRailsConventionConstraint R
birthdate date 13  √  null
gender text 2147483647  √  null
name text 2147483647  √  null
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_id
birthdate Performance Asc patients_birthday
gender Performance Asc patients_gender
Performance patients_lowered_name
name Performance Asc patients_name

Close relationships  within of separation: