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
Name | Type | Constraints | Description
schedule_item_KEY | int | NOT NULL | Key to the [Schedule_Item] row that these assignments are associated with.
assigned_staff_id_list | nvarchar (-1) | NOT NULL | List of [Staff].[staff_id] (or work queue).
assigned_staff_list | nvarchar (-1) | NOT NULL | List of [Staff].[description] (or work queue).

Primary key
Name | Columns | Description
PK_Schedule_Item_Assignment_List_Cache$schedule_item_KEY | schedule_item_KEY | CLUSTERED

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