_Deprecated_21_01_LabTestResults


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
_Deprecated_21_01_LabTestResultDefined.Id FK_dbo.LabTestResultDefined_dbo.LabTestResults_IdR
_Deprecated_21_01_LabTestResultOther.Id FK_dbo.LabTestResultOther_dbo.LabTestResults_IdR
ResultOperatorId int 4 √ null
ResultOperators.Id FK_dbo.LabTestResults_dbo.ResultOperators_ResultOperatorIdR
ResultOutcomeId int 4 √ null
ResultOutcomes.Id FK_dbo.LabTestResults_dbo.ResultOutcomes_ResultOutcomeIdR
InvestigationId int 4 ((0))
Investigations.Id FK_dbo.LabTestResults_dbo.Investigations_InvestigationIdC
PanelId int 4 √ null
_Deprecated_21_01_LabTestPanels.Id FK_dbo.LabTestResults_dbo.LabTestPanels_PanelIdR
StringResult nvarchar 42 √ null
DecimalResult decimal 22,5 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo._Deprecated_21_01_LabTestResults Primary key Asc Id
IX_InvestigationId Performance Asc InvestigationId
IX_PanelId Performance Asc PanelId
IX_ResultOperatorId Performance Asc ResultOperatorId
IX_ResultOutcomeId Performance Asc ResultOutcomeId

Relationships

Close relationships within degrees of separation