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
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
schedule_entry_KEY | int | NOT NULL |
schedule_item_KEY | int | NOT NULL | Link to the schedule item of the assignment that is being scheduled (or at least partially scheduled) by this record.
staff_KEY | int | NOT NULL | Link to the staff of the assignment that is being scheduled (or at least partially scheduled) by this record.
schedule_entry_start_utc | datetime | NOT NULL | The starting date and time in UTC.
schedule_entry_duration | int | NOT NULL | The duration of the schedule entry on the timeline in minutes.
schedule_entry_scheduled | int | NOT NULL | The 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_KEY | smallint (5) | NOT NULL | The time zone selected by the last person editing [schedule_entry_start_utc].
schedule_entry_end__time_zone_KEY | smallint (5) | NOT NULL | The time zone selected by the last person editing [schedule_entry_end_utc].
schedule_entry_end_utc | datetime | NOT NULL | COMPUTED: The ending date and time in UTC computed from [schedule_entry_start_utc] and [schedule_entry_duration].
calendar_category_KEY | int |  |

Primary key
Name | Columns | Description
PK_Schedule_Entry$schedule_entry_KEY | schedule_entry_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Entry$calendar_category_KEY | calendar_category_KEY | Index supports foreign key FK_Schedule_Entry__Calendar_Category__calendar_category_KEY
IX_Schedule_Entry$schedule_entry_end__time_zone_KEY | schedule_entry_end__time_zone_KEY | Index supports foreign key FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEY
IX_Schedule_Entry$schedule_entry_start__time_zone_KEY | schedule_entry_start__time_zone_KEY | Index 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_KEY | schedule_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_utc | schedule_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_KEY | staff_KEY, schedule_entry_start_utc, schedule_entry_duration, schedule_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Entry__Calendar_Category__calendar_category_KEY | calendar_category_KEY | Calendar_Category |
FK_Schedule_Entry__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item |
FK_Schedule_Entry__Staff__staff_KEY | staff_KEY | Staff |
FK_Schedule_Entry__Time_Zone__schedule_entry_end__time_zone_KEY | schedule_entry_end__time_zone_KEY | Time_Zone |
FK_Schedule_Entry__Time_Zone__schedule_entry_start__time_zone_KEY | schedule_entry_start__time_zone_KEY | Time_Zone |