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>
2Work Queue
Columns
NameTypeConstraintsDescription
staff_assignment_method_KEYintNOT NULL1=Assigned Staff
2=Work Queue
descriptionnvarchar (30)NOT NULLSystem defined description.
Primary key
NameColumnsDescription
PK_Staff_Assignment_Method$staff_assignment_method_KEYstaff_assignment_method_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project_Template__Staff_Assignment_Method__staff_assignment_method_KEYstaff_assignment_method_KEYProject_Template
FK_Task_Template__Staff_Assignment_Method__staff_assignment_method_KEYstaff_assignment_method_KEYTask_Template
FK_Schedule_Item__Staff_Assignment_Method__staff_assignment_method_KEYstaff_assignment_method_KEYSchedule_Item

Schema diagram