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; |