ICD10


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
Diagnosis.ICD10Id FK_dbo.Diagnosis_dbo.ICD10_ICD10IdR
SNOMEDICD10Link.ICD10Id FK_dbo.SNOMEDICD10Link_dbo.ICD10_ICD10IdC
Code nvarchar 1073741823 null
Description nvarchar 1073741823 null
ICD10GroupId int 4 null
ICD10Group.Id FK_dbo.ICD10_dbo.ICD10Group_ICD10GroupIdC
IsDeleted bit 1 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.ICD10 Primary key Asc Id
IX_ICD10GroupId Performance Asc ICD10GroupId

Relationships