Information for the Schedule
Columns
Id
(datatype: int) Required Primary Key
Name
(datatype: nvarchar(50)) Required Primary Key
Description
(datatype: nvarchar(max)) Required Primary Key
iCalendarContent
(datatype: nvarchar(max)) Required Primary Key
CheckInStartOffsetMinutes
(datatype: int) Required Primary Key
CheckInEndOffsetMinutes
(datatype: int) Required Primary Key
EffectiveStartDate
(datatype: date) Required Primary Key
EffectiveEndDate
(datatype: date) Required Primary Key
CategoryId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
WeeklyDayOfWeek
(datatype: int) Required Primary Key
WeeklyTimeOfDay
(datatype: time) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
IsActive
(datatype: bit) Required Primary Key
Order
(datatype: int) Required Primary Key
AutoInactivateWhenComplete
(datatype: bit) Required Primary Key
AbbreviatedName
(datatype: nvarchar(50)) Required Primary Key
IsPublic
(datatype: bit) Required Primary Key