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
Name | Type | Constraints | Description
schedule_item_KEY | int | NOT NULL |
lower_date_utc | datetime | NOT NULL |
upper_date_utc | datetime | NOT NULL |
is_all_day_event | bit | NOT NULL |

Primary key
Name | Columns | Description
PK_Schedule_Item_Date_Index$schedule_item_KEY$lower_date_utc | schedule_item_KEY, lower_date_utc | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Item_Date_Index$lower_date_utc@is_all_day_event@schedule_item_KEY@upper_date_utc | lower_date_utc, is_all_day_event, schedule_item_KEY, upper_date_utc | This is the primary index used to look up records by lower_date_utc and must cover the other columns.

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Item_Date_Index__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item | on delete cascade;