Table: Schedule_Item_Date_Index
This table is an index used for fast queries looking up the [Schedule_Item] rows that intersect with a date range.
Columns
NameTypeConstraintsDescription
schedule_item_KEYintNOT NULL
lower_date_utcdatetimeNOT NULL
upper_date_utcdatetimeNOT NULL
is_all_day_eventbitNOT NULL
Primary key
NameColumnsDescription
PK_Schedule_Item_Date_Index$schedule_item_KEY$lower_date_utcschedule_item_KEY, lower_date_utcCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Date_Index$lower_date_utc@is_all_day_event@schedule_item_KEY@upper_date_utclower_date_utc, is_all_day_event, schedule_item_KEY, upper_date_utcThis is the primary index used to look up records by lower_date_utc and must cover the other columns.
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Date_Index__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Itemon delete cascade;

Schema diagram