dbo.makesafeUserSchedule

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.makesafeUserSchedule.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	UserID	int	no		FK to makesafeUser.ID identifying the user this on-call/rostered schedule period is for.
3	FromDate	datetime	no		Start of the scheduled on-call period.
4	Todate	datetime	no		End of the scheduled on-call period.
5	DateModified	datetime	no		Timestamp the schedule record was created or last modified.
6	IsActive	bit	no		True if this schedule entry is currently active/in effect.

Relationships (inferred)

From	To	Confidence
dbo.makesafeUserSchedule.UserID	dbo.makesafeUser.ID	high

Referenced by

Procedures: dbo.spMakesafeDisableUserSchedule, dbo.spMakesafeGetActiveUserScheduleMobiles, dbo.spMakesafeGetAllUserSchedules, dbo.spMakesafeGetUserSchedule, dbo.spMakesafeGetUserScheduleByID, dbo.spMakesafeGetUserScheduleCount, dbo.spMakesafeInsertUserSchedule, dbo.spMakesafeQueueEscalationSMSMessagesNoSchedules, dbo.spMakesafeQueueEscalationSMSMessagesUnassigned, dbo.spMakesafeQueueOnCallSMSMessagesUnassigned, dbo.spMakesafeUpdateUserSchedule