Table: Schedule_Item_Assignment_List_Cache
Cache of the staff assignment lists.

Assignments are primarily stored in [Schedule_Item_Assignment] and are affected by the content of [Schedule_Item].[staff_assignment_method_KEY], [Staff].[description], [Filter].[description] and [Schedule_Item_Pool] and [Schedule_Item_Assignment].

This cache is maintained by triggers and Schedule_Item_Assignment_List_Cache_Calculation_View.
Columns
NameTypeConstraintsDescription
schedule_item_KEYintNOT NULLKey to the [Schedule_Item] row that these assignments are associated with.
assigned_staff_id_listnvarchar (-1)NOT NULLList of [Staff].[staff_id] (or work queue).
assigned_staff_listnvarchar (-1)NOT NULLList of [Staff].[description] (or work queue).
Primary key
NameColumnsDescription
PK_Schedule_Item_Assignment_List_Cache$schedule_item_KEYschedule_item_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Schedule_Item_Assignment_List_Cache__Schedule_Item__schedule_item_KEYschedule_item_KEYSchedule_Itemon delete cascade;

Schema diagram