_Deprecated_21_01_TumourMarkerResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
_Deprecated_21_01_TumourMarkerResultsDefined.Id FK_dbo.TumourMarkerResultsDefined_dbo.TumourMarkerResults_IdR
_Deprecated_21_01_TumourMarkerResultsOther.Id FK_dbo.TumourMarkerResultsOther_dbo.TumourMarkerResults_IdR
InvestigationId int 4 null
Investigations.Id FK_dbo.TumourMarkerResults_dbo.Investigations_InvestigationIdC
OperatorId int 4 √ null
ResultOperators.Id FK_dbo.TumourMarkerResults_dbo.ResultOperators_OperatorIdR
OutcomeId int 4 √ null
ResultOutcomes.Id FK_dbo.TumourMarkerResults_dbo.ResultOutcomes_OutcomeIdR
StringResult nvarchar 42 √ null
DecimalResult decimal 22,5 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo._Deprecated_21_01_TumourMarkerResults Primary key Asc Id
IX_InvestigationId Performance Asc InvestigationId
IX_OperatorId Performance Asc OperatorId
IX_OutcomeId Performance Asc OutcomeId

Relationships

Close relationships within degrees of separation