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