Table: Schedule_Entry
Represents all or some of a scheduled assignment. Each block can be scheduled by day or for a particular time. There is nothing unique about a [Schedule_Entry] and it is up to the user interface to reduce the number of overlaps and adjacent entries, but it is possible for such entries to be created due to concurrency.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
schedule_entry_KEYintNOT NULL
schedule_item_KEYintNOT NULLLink to the schedule item of the assignment that is being scheduled (or at least partially scheduled) by this record.
staff_KEYintNOT NULLLink to the staff of the assignment that is being scheduled (or at least partially scheduled) by this record.
schedule_entry_start_utcdatetimeNOT NULLThe starting date and time in UTC.
schedule_entry_durationintNOT NULLThe duration of the schedule entry on the timeline in minutes.
schedule_entry_scheduledintNOT NULLThe number of minutes this entry has actually been scheduled for. It can be any amount less than or equal to [schedule_entry_duration].
schedule_entry_start__time_zone_KEYsmallint (5)NOT NULLThe time zone selected by the last person editing [schedule_entry_start_utc].
schedule_entry_end__time_zone_KEYsmallint (5)NOT NULLThe time zone selected by the last person editing [schedule_entry_end_utc].
schedule_entry_end_utcdatetimeNOT NULLCOMPUTED: The ending date and time in UTC computed from [schedule_entry_start_utc] and [schedule_entry_duration].
calendar_category_KEYint
Primary key
NameColumnsDescription
PK_Schedule_Entry$schedule_entry_KEYschedule_entry_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Entry$calendar_category_KEYcalendar_category_KEYIndex supports foreign key FK_Schedule_Entry__Calendar_Category__calendar_category_KEY
IX_Schedule_Entry$schedule_entry_end__time_zone_KEYschedule_entry_end__time_zone_KEYIndex supports foreign key FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEY
IX_Schedule_Entry$schedule_entry_start__time_zone_KEYschedule_entry_start__time_zone_KEYIndex supports foreign key FK_Schedule_Entry__Time_Zone__schedule_entry_start__time_zone_KEY
IX_Schedule_Entry$schedule_entry_start_utc@schedule_entry_duration@schedule_item_KEY@staff_KEYschedule_entry_start_utc, schedule_entry_duration, schedule_item_KEY, staff_KEY
IX_Schedule_Entry$schedule_item_KEY$staff_KEY@schedule_entry_duration@schedule_entry_start_utcschedule_item_KEY, staff_KEY, schedule_entry_duration, schedule_entry_start_utc
IX_Schedule_Entry$staff_KEY$schedule_entry_start_utc@schedule_entry_duration@schedule_item_KEYstaff_KEY, schedule_entry_start_utc, schedule_entry_duration, schedule_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Entry__Calendar_Category__calendar_category_KEYcalendar_category_KEYCalendar_Category
FK_Schedule_Entry__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Item
FK_Schedule_Entry__Staff__staff_KEYstaff_KEYStaff
FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEYschedule_entry_end__time_zone_KEYTime_Zone
FK_Schedule_Entry__Time_Zone__schedule_entry_start__time_zone_KEYschedule_entry_start__time_zone_KEYTime_Zone

Schema diagram