Table harbinger.public.icd_codes
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('icd_codes_id_seq'::regclass)
claim_transaction_diagnoses.icd_code_id claim_transaction_diagnoses_icd_code_fk R
visit_diagnoses.icd_code_id visit_diagnoses_icd_code_fk R
code text 2147483647
description text 2147483647  √  null
icd_code_revision_id int8 19 icd_code_revision_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 icd_code_id
icd_code_revision_id Performance Asc fki_icd_code_revision_fk
code Performance Asc icd_code_code_idx

Close relationships  within of separation: