Table: Staff_Assignment_Method
[Schedule_Item] records have more than one way that staff can be assigned to them. Tags: read-only Content:
1 | <ProjectAssigned> <Staff>
2 | Work Queue
Columns
Name | Type | Constraints | Description
staff_assignment_method_KEY | int | NOT NULL | 1=Assigned Staff 2=Work Queue
description | nvarchar (30) | NOT NULL | System defined description.

Primary key
Name | Columns | Description
PK_Staff_Assignment_Method$staff_assignment_method_KEY | staff_assignment_method_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Project_Template__Staff_Assignment_Method__staff_assignment_method_KEY | staff_assignment_method_KEY | Project_Template |
FK_Task_Template__Staff_Assignment_Method__staff_assignment_method_KEY | staff_assignment_method_KEY | Task_Template |
FK_Schedule_Item__Staff_Assignment_Method__staff_assignment_method_KEY | staff_assignment_method_KEY | Schedule_Item |