dim_diagnosis

23434 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_diagnosis_key int identity 4 √ null
fact_patient_diagnosis.dim_diagnosis_key Implied ConstraintR
fact_patient_facility_stay.dim_diagnosis_key Implied ConstraintR
stage_patient_diagnosis.dim_diagnosis_key Implied ConstraintR
stage_patient_stay_4.dim_diagnosis_key Implied ConstraintR
diagnosiscode varchar 15 √ null
diagnosisdesc varchar 255 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_diagnosis_idx_0 Primary key Asc dim_diagnosis_key

Relationships

Close relationships within degrees of separation