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