Diagnosis


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
DiagnosisMets.DiagnosisId FK_dbo.DiagnosisMets_dbo.Diagnosis_DiagnosisIdC
Staging.DiagnosisId FK_dbo.Staging_dbo.Diagnosis_DiagnosisIdR
ReferralId int 4 null
Referrals.Id FK_dbo.Diagnosis_dbo.Referrals_ReferralIdC
ConsultantAtDiagnosisId int 4 √ null
Consultants.Id FK_dbo.Diagnosis_dbo.Consultants_ConsultantAtDiagnosisIdR
TumourStatusId int 4 √ null
TumourStatus.Id FK_dbo.Diagnosis_dbo.TumourStatus_TumourStatusIdR
MorphologyId int 4 √ null
SNOMED_CT.Id FK_dbo.Diagnosis_dbo.SNOMED_CT_MorphologyIdR
ICD10GroupId int 4 √ null
ICD10Group.Id FK_dbo.Diagnosis_dbo.ICD10Group_ICD10GroupIdR
ICD10Id int 4 √ null
ICD10.Id FK_dbo.Diagnosis_dbo.ICD10_ICD10IdR
SNOMEDDiagnosisId int 4 √ null
SNOMEDDiagnosis.Id FK_dbo.Diagnosis_dbo.SNOMEDDiagnosis_SNOMEDDiagnosisIdR
SNOMEDMorphologyId int 4 √ null
SNOMEDMorphologies.Id FK_dbo.Diagnosis_dbo.SNOMEDMorphologies_SNOMEDMorphologyIdR
LateralityId int 4 √ null
Lateralities.Id FK_dbo.Diagnosis_dbo.Lateralities_LateralityIdR
DateOfDiagnosis datetime 16,3 √ null
DatePatientInformed datetime 16,3 √ null
GradeOfDifferentiationId int 4 √ null
GradesOfDifferentiation.Id FK_dbo.Diagnosis_dbo.GradesOfDifferentiation_GradeOfDifferentiationIdR
BasisOfDiagnosisId int 4 √ null
BasisOfDiagnosis.Id FK_dbo.Diagnosis_dbo.BasisOfDiagnosis_BasisOfDiagnosisIdR
CNSIndicationCodeId int 4 √ null
CNSIndicationCodes.Id FK_dbo.Diagnosis_dbo.CNSIndicationCodes_CNSIndicationCodeIdR
OrganisationId int 4 √ null
Organisations.Id FK_dbo.Diagnosis_dbo.Organisations_OrganisationIdR
DateDeleted datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Diagnosis Primary key Asc Id
IX_BasisOfDiagnosisId Performance Asc BasisOfDiagnosisId
IX_CNSIndicationCodeId Performance Asc CNSIndicationCodeId
IX_ConsultantAtDiagnosisId Performance Asc ConsultantAtDiagnosisId
IX_GradeOfDifferentiationId Performance Asc GradeOfDifferentiationId
IX_ICD10GroupId Performance Asc ICD10GroupId
IX_ICD10Id Performance Asc ICD10Id
IX_LateralityId Performance Asc LateralityId
IX_MorphologyId Performance Asc MorphologyId
IX_OrganisationId Performance Asc OrganisationId
IX_ReferralId Performance Asc ReferralId
IX_SNOMEDDiagnosisId Performance Asc SNOMEDDiagnosisId
IX_SNOMEDMorphologyId Performance Asc SNOMEDMorphologyId
IX_TumourStatusId Performance Asc TumourStatusId

Relationships

Close relationships within degrees of separation