Table: Schedule_Item_Last_In_Series
Table that caches the last schedule item key for each series
Columns
Name | Type | Constraints | Description
schedule_item_series_KEY | int | NOT NULL | Primary key for this table.
schedule_item_KEY | int |  | Key of the last Schedule Item in the series.

Primary key
Name | Columns | Description
PK_Schedule_Item_Last_In_Series$schedule_item_series_KEY | schedule_item_series_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Schedule_Item_Last_In_Series$schedule_item_KEY | schedule_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Schedule_Item_Last_In_Series__Schedule_Item__schedule_item_KEY | schedule_item_KEY | Schedule_Item | on delete set null;
FK_Schedule_Item_Last_In_Series__Schedule_Item_Series__schedule_item_series_KEY | schedule_item_series_KEY | Schedule_Item_Series | on delete cascade;