BreastInvestigationResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
InvestigationId int 4 null
Investigations.Id FK_dbo.BreastInvestigationResults_dbo.Investigations_InvestigationIdC
SiteId int 4 √ null
BreastSites.Id FK_dbo.BreastInvestigationResults_dbo.BreastSites_SiteIdR
SideId int 4 √ null
BreastSides.Id FK_dbo.BreastInvestigationResults_dbo.BreastSides_SideIdR
TNM_Rad_TValueId int 4 √ null
TNM_T_Value.Id FK_dbo.BreastInvestigationResults_dbo.TNM_T_Value_TNM_Rad_TValueIdR
TNM_Rad_TLetterId int 4 √ null
TNM_T_Letter.Id FK_dbo.BreastInvestigationResults_dbo.TNM_T_Letter_TNM_Rad_TLetterIdR
TNM_Rad_NValueId int 4 √ null
TNM_N_Value.Id FK_dbo.BreastInvestigationResults_dbo.TNM_N_Value_TNM_Rad_NValueIdR
TNM_Rad_NLetterId int 4 √ null
TNM_N_Letter.Id FK_dbo.BreastInvestigationResults_dbo.TNM_N_Letter_TNM_Rad_NLetterIdR
TNM_Rad_MValueId int 4 √ null
TNM_M_Value.Id FK_dbo.BreastInvestigationResults_dbo.TNM_M_Value_TNM_Rad_MValueIdR
TNM_Rad_MLetterId int 4 √ null
TNM_M_Letter.Id FK_dbo.BreastInvestigationResults_dbo.TNM_M_Letter_TNM_Rad_MLetterIdR
TNM_Rad_EditionId int 4 √ null
TNMEditions.Id FK_dbo.BreastInvestigationResults_dbo.TNMEditions_TNMRadEdition_IdR
TNM_Rad_VersionId int 4 √ null
TNMVersions.Id FK_dbo.BreastInvestigationResults_dbo.TNMVersions_TNMRadVersion_IdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.BreastInvestigationResults Primary key Asc Id
IX_InvestigationId Performance Asc InvestigationId
IX_SideId Performance Asc SideId
IX_SiteId Performance Asc SiteId
IX_TNM_Rad_EditionId Performance Asc TNM_Rad_EditionId
IX_TNM_Rad_MLetterId Performance Asc TNM_Rad_MLetterId
IX_TNM_Rad_MValueId Performance Asc TNM_Rad_MValueId
IX_TNM_Rad_NLetterId Performance Asc TNM_Rad_NLetterId
IX_TNM_Rad_NValueId Performance Asc TNM_Rad_NValueId
IX_TNM_Rad_TLetterId Performance Asc TNM_Rad_TLetterId
IX_TNM_Rad_TValueId Performance Asc TNM_Rad_TValueId
IX_TNM_Rad_VersionId Performance Asc TNM_Rad_VersionId

Relationships

Close relationships within degrees of separation