BloodTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
BloodTestPanelAssociations.TestId FK_dbo.BloodTestPanelAssociations_dbo.BloodTests_TestIdC
BloodTestRanges.BloodTestId FK_dbo.BloodTestRanges_dbo.BloodTests_BloodTestIdC
BloodTestRangeTypeDefinitions.BloodTestId FK_dbo.BloodTestRangeTypeDefinitions_dbo.BloodTests_BloodTestIdC
BloodTestResultDefined.BloodTestId FK_dbo.BloodTestResultDefined_dbo.BloodTests_BloodTestIdC
BloodTestUnitAssociations.TestId FK_dbo.BloodTestUnitAssociations_dbo.BloodTests_TestIdC
CancerSiteSettings.PrincipalTumourMarkerId FK_dbo.CancerSiteSettings_dbo.BloodTests_PrincipalTumourMarkerIdR
Description nvarchar 100 null
TestType int 4 null
PortalCode nvarchar 60 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.BloodTests Primary key Asc Id

Relationships

Close relationships within degrees of separation