Staging


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DiagnosisId int 4 null
BreastStaging.DiagnosisId FK_dbo.BreastStaging_dbo.Staging_DiagnosisIdR
ColorectalStaging.DiagnosisId FK_dbo.ColorectalStaging_dbo.Staging_DiagnosisIdR
ProstateStaging.DiagnosisId FK_dbo.ProstateStaging_dbo.Staging_DiagnosisIdR
TesticularStaging.DiagnosisId FK_dbo.TesticularStaging_dbo.Staging_DiagnosisIdR
ThyroidStaging.DiagnosisId FK_dbo.ThyroidStaging_dbo.Staging_DiagnosisIdR
Diagnosis.Id FK_dbo.Staging_dbo.Diagnosis_DiagnosisIdR
TNM_FI_VersionId int 4 √ null
TNM_FI_OrganisationId int 4 √ null
Organisations.Id FK_dbo.Staging_dbo.Organisations_TNM_FI_OrganisationIdR
TNM_FI_Date datetime 16,3 √ null
TNM_FI_TValueId int 4 √ null
TNM_T_Value.Id FK_dbo.Staging_dbo.TNM_T_Value_TNM_FI_TValueIdR
TNM_FI_TLetterId int 4 √ null
TNM_T_Letter.Id FK_dbo.Staging_dbo.TNM_T_Letter_TNM_FI_TLetterIdR
TNM_FI_NValueId int 4 √ null
TNM_N_Value.Id FK_dbo.Staging_dbo.TNM_N_Value_TNM_FI_NValueIdR
TNM_FI_NLetterId int 4 √ null
TNM_N_Letter.Id FK_dbo.Staging_dbo.TNM_N_Letter_TNM_FI_NLetterIdR
TNM_FI_MValueId int 4 √ null
TNM_M_Value.Id FK_dbo.Staging_dbo.TNM_M_Value_TNM_FI_MValueIdR
TNM_FI_MLetterId int 4 √ null
TNM_M_Letter.Id FK_dbo.Staging_dbo.TNM_M_Letter_TNM_FI_MLetterIdR
TNM_FI_TNMGroupingId int 4 √ null
TNMGroupings.Id FK_dbo.Staging_dbo.TNMGroupings_TNM_FI_TNMGroupingIdR
TNMVersion_Id int 4 √ null
TNMVersions.Id FK_dbo.Staging_dbo.TNMVersions_TNMVersion_IdR
TNM_FI_EditionId int 4 √ null
TNMEdition_Id int 4 √ null
TNMEditions.Id FK_dbo.Staging_dbo.TNMEditions_TNMEdition_IdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.Staging Primary key Asc DiagnosisId
IX_DiagnosisId Performance Asc DiagnosisId
IX_TNM_FI_MLetterId Performance Asc TNM_FI_MLetterId
IX_TNM_FI_MValueId Performance Asc TNM_FI_MValueId
IX_TNM_FI_NLetterId Performance Asc TNM_FI_NLetterId
IX_TNM_FI_NValueId Performance Asc TNM_FI_NValueId
IX_TNM_FI_OrganisationId Performance Asc TNM_FI_OrganisationId
IX_TNM_FI_TLetterId Performance Asc TNM_FI_TLetterId
IX_TNM_FI_TNMGroupingId Performance Asc TNM_FI_TNMGroupingId
IX_TNM_FI_TValueId Performance Asc TNM_FI_TValueId
IX_TNMEdition_Id Performance Asc TNMEdition_Id
IX_TNMVersion_Id Performance Asc TNMVersion_Id

Relationships

Close relationships within degrees of separation