DiagnosisMets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
DiagnosisId int 4 null
Diagnosis.Id FK_dbo.DiagnosisMets_dbo.Diagnosis_DiagnosisIdC
LocationId int 4 √ null
MetsLocations.Id FK_dbo.DiagnosisMets_dbo.MetsLocations_MetsLocationIdR
CertaintyId int 4 √ null
MetsCertainties.Id FK_dbo.DiagnosisMets_dbo.MetsCertainties_MetsCertaintyIdR
TypeId int 4 √ null
MetsTypes.Id FK_dbo.DiagnosisMets_dbo.MetsTypes_MetsTypeIdR
OtherMetastaticSite nvarchar 1073741823 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.DiagnosisMets Primary key Asc Id
IX_CertaintyId Performance Asc CertaintyId
IX_DiagnosisId Performance Asc DiagnosisId
IX_LocationId Performance Asc LocationId
IX_TypeId Performance Asc TypeId

Relationships

Close relationships within degrees of separation