ActivityTemplateSchedule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
BreastSwitchActivityTemplateSchedule.Id FK_dbo.BreastSwitchActivityTemplateSchedule_dbo.ActivityTemplateSchedule_IdR
ClinicalReviewActivityTemplateSchedule.Id FK_dbo.ClinicalReviewActivityTemplateSchedule_dbo.ActivityTemplateSchedule_IdR
HNAActivityTemplateSchedule.Id FK_dbo.HNAActivityTemplateSchedule_dbo.ActivityTemplateSchedule_IdR
InvestigationActivityTemplateSchedule.Id FK_dbo.InvestigationActivityTemplateSchedule_dbo.ActivityTemplateSchedule_IdR
MDTDiscussionActivityTemplateSchedule.Id FK_dbo.MDTDiscussionActivityTemplateSchedule_dbo.ActivityTemplateSchedule_IdR
IsRecurringActivity bit 1 null
RecurrenceTimeSpanTypeId int 4 √ null
ActivityTimeSpanTypes.Id FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeIdR
RecurrenceValue int 4 √ null
DurationTimeSpanTypeId int 4 √ null
ActivityTimeSpanTypes.Id FK_dbo.ActivityTemplateSchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeIdR
DurationValue int 4 √ null
ActivityTemplateId int 4 null
ActivityTemplates.Id FK_dbo.ActivityTemplateSchedule_dbo.ActivityTemplates_ActivityTemplateIdC
DateDeleted datetime 16,3 √ null
ActivityNote nvarchar 60 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.ActivityTemplateSchedule Primary key Asc Id
IX_ActivityTemplateId Performance Asc ActivityTemplateId
IX_DurationTimeSpanTypeId Performance Asc DurationTimeSpanTypeId
IX_RecurrenceTimeSpanTypeId Performance Asc RecurrenceTimeSpanTypeId

Relationships

Close relationships within degrees of separation