CancerSites


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
_Deprecated_21_01_LabTests.ThresholdForSite_Id FK_dbo.LabTests_dbo.CancerSites_ThresholdForSite_IdR
_Deprecated_21_01_TumourMarkers.ThresholdForSite_Id FK_dbo.TumourMarkers_dbo.CancerSites_ThresholdForSite_IdR
ActivityTemplates.CancerSiteId FK_dbo.ActivityTemplates_dbo.CancerSites_CancerSiteIdC
Alerts.CancerSiteId FK_dbo.Alerts_dbo.CancerSites_CancerSiteIdC
BloodTestRangeTypeDefinitions.CancerSiteId FK_dbo.BloodTestRangeTypeDefinitions_dbo.CancerSites_CancerSiteIdC
CancerSiteSettings.CancerSiteId FK_dbo.CancerSiteSettings_dbo.CancerSites_CancerSiteIdC
CancerSubSites.CancerSiteId FK_dbo.CancerSubSites_dbo.CancerSites_CancerSiteIdC
LibraryFiles.CancerSiteId FK_dbo.LibraryFiles_dbo.CancerSites_CancerSiteIdC
UserPermissions.CancerSiteId FK_dbo.UserPermissions_dbo.CancerSites_CancerSiteIdC
Name nvarchar 200 null
Description nvarchar 200 √ null

Indexes

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

Relationships

Close relationships within degrees of separation