ActivityTemplates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 null
ActivitySchedule.ActivityTemplateId FK_dbo.ActivitySchedule_dbo.ActivityTemplates_ActivityTemplateIdR
ActivityTemplateSchedule.ActivityTemplateId FK_dbo.ActivityTemplateSchedule_dbo.ActivityTemplates_ActivityTemplateIdC
CancerSiteId int 4 null
CancerSites.Id FK_dbo.ActivityTemplates_dbo.CancerSites_CancerSiteIdC
Description nvarchar 1073741823 null
DateDeleted datetime 16,3 null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.ActivityTemplates Primary key Asc Id
IX_CancerSiteId Performance Asc CancerSiteId

Relationships