icd_diagnosis_hierarchy_crosswalk
ICD diagnosis code hierarchy crosswalk.
Primary Key:Foreign Keys:icd_diagnosis_hierarchy1_id=>icd_diagnosis_hierarchy1_lookup.icd_diagnosis_hierarchy1_idicd_diagnosis_hierarchy2_id=>icd_diagnosis_hierarchy2_lookup.icd_diagnosis_hierarchy2_idicd_diagnosis_hierarchy3_id=>icd_diagnosis_hierarchy3_lookup.icd_diagnosis_hierarchy3_idicd_diagnosis_hierarchy4_id=>icd_diagnosis_hierarchy4_lookup.icd_diagnosis_hierarchy4_id
icd_diagnosis_hierarchy_crosswalk_icd_diagnosis_hierarchy1_idx-icd_diagnosis_hierarchy1_idicd_diagnosis_hierarchy_crosswalk_icd_diagnosis_hierarchy2_idx-icd_diagnosis_hierarchy2_idicd_diagnosis_hierarchy_crosswalk_icd_diagnosis_hierarchy3_idx-icd_diagnosis_hierarchy3_idicd_diagnosis_hierarchy_crosswalk_icd_diagnosis_hierarchy4_idx-icd_diagnosis_hierarchy4_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
code_prefix | text | No | Yes | - |
release_date | date | No | Yes | - |
icd_diagnosis_hierarchy1_id | bigint | No | Yes | - |
icd_diagnosis_hierarchy2_id | bigint | No | Yes | - |
icd_diagnosis_hierarchy3_id | bigint | No | Yes | - |
icd_diagnosis_hierarchy4_id | bigint | Yes | Yes | - |