BloodTestResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
BloodTestResultDefined.Id FK_dbo.BloodTestResultDefined_dbo.BloodTestResults_IdR
BloodTestResultOther.Id FK_dbo.BloodTestResultOther_dbo.BloodTestResults_IdR
OperatorId int 4 √ null
ResultOperators.Id FK_dbo.BloodTestResults_dbo.ResultOperators_ResultOperatorIdR
StringResult nvarchar 42 √ null
OutcomeId int 4 √ null
ResultOutcomes.Id FK_dbo.BloodTestResults_dbo.ResultOutcomes_ResultOutcomeIdR
InvestigationId int 4 null
Investigations.Id FK_dbo.BloodTestResults_dbo.Investigations_InvestigationIdC
DecimalResult decimal 22,5 √ null
TestPanelId int 4 √ null
BloodTestPanels.Id FK_dbo.BloodTestResults_dbo.BloodTestPanels_TestPanelIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.BloodTestResults Primary key Asc Id
IX_BloodTestResultRangeCheck Performance Asc/Desc InvestigationId + Id
IX_InvestigationId Performance Asc InvestigationId
IX_OperatorId Performance Asc OperatorId
IX_OutcomeId Performance Asc OutcomeId
IX_TestPanelId Performance Asc TestPanelId

Relationships

Close relationships within degrees of separation