Table harbinger.public.visit_diagnoses
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('visit_diagnoses_id_seq'::regclass)
visit_id int8 19
visits.id visit_diagnoses_visit_fk R
icd_code_id int8 19
icd_codes.id visit_diagnoses_icd_code_fk R
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 visit_diagnoses_id
visit_id Performance Asc fki_visit_diagnoses_visit_fk
icd_code_id Performance Asc visit_diagonses_icd_code_idx

Close relationships  within of separation: