ActivitySchedule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
Activities.ActivityScheduleId FK_dbo.Activities_dbo.ActivitySchedule_ActivityScheduleIdC
BreastSwitchActivitySchedule.Id FK_dbo.BreastSwitchActivitySchedule_dbo.ActivitySchedule_IdR
ClinicalReviewActivitySchedule.Id FK_dbo.ClinicalReviewActivitySchedule_dbo.ActivitySchedule_IdR
HNAActivitySchedule.Id FK_dbo.HNAActivitySchedule_dbo.ActivitySchedule_IdR
InvestigationActivitySchedule.Id FK_dbo.InvestigationActivitySchedule_dbo.ActivitySchedule_IdR
MDTDiscussionActivitySchedule.Id FK_dbo.MDTDiscussionActivitySchedule_dbo.ActivitySchedule_IdR
IsRecurringActivity bit 1 null
RecurrenceTimeSpanTypeId int 4 √ null
ActivityTimeSpanTypes.Id FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_RecurrenceTimeSpanTypeIdR
RecurrenceValue int 4 √ null
DurationTimeSpanTypeId int 4 √ null
ActivityTimeSpanTypes.Id FK_dbo.ActivitySchedule_dbo.ActivityTimeSpanTypes_DurationTimeSpanTypeIdR
DurationValue int 4 √ null
ReferralId int 4 null
Referrals.Id FK_dbo.ActivitySchedule_dbo.Referrals_ReferralIdC
DateDeleted datetime 16,3 √ null
DateClosed datetime 16,3 √ null
ActivityScheduleClosedReasonId int 4 √ null
ActivityScheduleClosedReasons.Id FK_dbo.ActivitySchedule_dbo.ActivityScheduleClosedReasons_ActivityScheduleClosedReasonIdR
ActivityScheduleClosedReasonOther nvarchar 1073741823 √ null
StatusTypeId int 4 null
ActivityScheduleStatusTypes.Id FK_dbo.ActivitySchedule_dbo.ActivityScheduleStatusTypes_StatusTypeIdC
ActivityNote nvarchar 60 √ null
ActivityTemplateId int 4 √ null
ActivityTemplates.Id FK_dbo.ActivitySchedule_dbo.ActivityTemplates_ActivityTemplateIdR
DateTemplateAdded datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.ActivitySchedule Primary key Asc Id
IX_ActivityScheduleClosedReasonId Performance Asc ActivityScheduleClosedReasonId
IX_ActivityTemplateId Performance Asc ActivityTemplateId
IX_DurationTimeSpanTypeId Performance Asc DurationTimeSpanTypeId
IX_RecurrenceTimeSpanTypeId Performance Asc RecurrenceTimeSpanTypeId
IX_ReferralId Performance Asc ReferralId
IX_StatusTypeId Performance Asc StatusTypeId

Relationships

Close relationships within degrees of separation