Table: Task_Template
Columns
NameTypeConstraintsDescription
task_template_KEYintNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
project_template_KEYintNOT NULL
completion_orderintNOT NULL
activity_KEYint
tracking_description_KEYintNOT NULL
budgeted_hoursdecimal (9, 2)NOT NULL
budgeted_amountdecimal (9, 2)NOT NULL
target_start_monthintNOT NULL
target_start_dayintNOT NULL
start__target_date_method_KEYintNOT NULL
target_complete_monthintNOT NULL
target_complete_dayintNOT NULL
complete__target_date_method_KEYintNOT NULL
targetnvarchar (1000)NOT NULL
completion_eventnvarchar (50)NOT NULL
commentsnvarchar (-1)NOT NULL
row_versiontimestampNOT NULL
solution_type_namenvarchar (50)NOT NULL
staff_grouping_type_KEYintNOT NULL
staff_assignment_method_KEYintNOT NULL
staff_qualifications__filter_KEYint
budgeted_amount_is_calculatedbitNOT NULL
descriptionnvarchar (250)NOT NULL
Primary key
NameColumnsDescription
PK_Task_Template$task_template_KEYtask_template_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Task_Template$project_template_KEY$task_template_KEYproject_template_KEY, task_template_KEYThis unique constraint supports the relationship between Task_Template and Task.
Indexes
NameColumnsDescription
IX_Task_Template$activity_KEYactivity_KEYIndex supports foreign key FK_Task_Template__Activity__activity_KEY
IX_Task_Template$complete__target_date_method_KEYcomplete__target_date_method_KEYIndex supports foreign key FK_Task_Template__Target_Date_Method__complete__target_date_method_KEY
IX_Task_Template$staff_assignment_method_KEYstaff_assignment_method_KEYIndex supports foreign key FK_Task_Template__Staff_Assignment_Method__staff_assignment_method_KEY
IX_Task_Template$staff_grouping_type_KEYstaff_grouping_type_KEYIndex supports foreign key FK_Task_Template__Staff_Grouping_Type__staff_grouping_type_KEY
IX_Task_Template$staff_qualifications__filter_KEYstaff_qualifications__filter_KEYIndex supports foreign key FK_Task_Template__Filter__staff_qualifications__filter_KEY
IX_Task_Template$start__target_date_method_KEYstart__target_date_method_KEYIndex supports foreign key FK_Task_Template__Target_Date_Method__start__target_date_method_KEY
IX_Task_Template$tracking_description_KEYtracking_description_KEYIndex supports foreign key FK_Task_Template__Tracking_Description__tracking_description_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Task_Template__Activity__activity_KEYactivity_KEYActivity
FK_Task_Template__Filter__staff_qualifications__filter_KEYstaff_qualifications__filter_KEYFilter
FK_Task_Template__Project_Template__project_template_KEYproject_template_KEYProject_Template
FK_Task_Template__Staff_Grouping_Type__staff_grouping_type_KEYstaff_grouping_type_KEYStaff_Grouping_Type
FK_Task_Template__Target_Date_Method__complete__target_date_method_KEYcomplete__target_date_method_KEYTarget_Date_Method
FK_Task_Template__Target_Date_Method__start__target_date_method_KEYstart__target_date_method_KEYTarget_Date_Method
FK_Task_Template__Tracking_Description__tracking_description_KEYtracking_description_KEYTracking_Description
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Task_Template_Assignment__Task_Template__task_template_KEYtask_template_KEYTask_Template_Assignment
FK_Task__Task_Template__project_template_KEY__task_template_KEYproject_template_KEY, task_template_KEYTask
FK_Task__Task_Template__task_template_KEYtask_template_KEYTaskon delete set null;

Schema diagram