icd_diagnosis_hierarchy

ICD diagnosis code hierarchy.

Primary Key:

• icd_diagnosis_id

Foreign Keys:

• icd_diagnosis_hierarchy_level1_id => icd_diagnosis_hierarchy_level1_lookup.icd_diagnosis_hierarchy_level1_id
• icd_diagnosis_hierarchy_level2_id => icd_diagnosis_hierarchy_level2_lookup.icd_diagnosis_hierarchy_level2_id
• icd_diagnosis_hierarchy_level3_id => icd_diagnosis_hierarchy_level3_lookup.icd_diagnosis_hierarchy_level3_id
• icd_diagnosis_hierarchy_level4_id => icd_diagnosis_hierarchy_level4_lookup.icd_diagnosis_hierarchy_level4_id

Indexes:

• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy_level1_id_idx - icd_diagnosis_hierarchy_level1_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy_level2_id_idx - icd_diagnosis_hierarchy_level2_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy_level3_id_idx - icd_diagnosis_hierarchy_level3_id
• icd_diagnosis_hierarchy_icd_diagnosis_hierarchy_level4_id_idx - icd_diagnosis_hierarchy_level4_id

Column	Data Type	Nullable	Indexed	Description
icd_diagnosis_id	bigint	No	Yes	-
icd_diagnosis_hierarchy_level1_id	bigint	No	Yes	-
icd_diagnosis_hierarchy_level2_id	bigint	No	Yes	-
icd_diagnosis_hierarchy_level3_id	bigint	No	Yes	-
icd_diagnosis_hierarchy_level4_id	bigint	Yes	Yes	-