Table: Schedule_Item_Last_In_Series
Table that caches the last schedule item key for each series
Columns
NameTypeConstraintsDescription
schedule_item_series_KEYintNOT NULLPrimary key for this table.
schedule_item_KEYintKey of the last Schedule Item in the series.
Primary key
NameColumnsDescription
PK_Schedule_Item_Last_In_Series$schedule_item_series_KEYschedule_item_series_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Schedule_Item_Last_In_Series$schedule_item_KEYschedule_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Last_In_Series__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Itemon delete set null;
FK_Schedule_Item_Last_In_Series__Schedule_Item_Series__schedule_item_series_KEYschedule_item_series_KEYSchedule_Item_Serieson delete cascade;

Schema diagram