Table: Engagement_Template
Columns
NameTypeConstraintsDescription
engagement_template_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
engagement_template_idnvarchar (11)NOT NULLUser defined identifier (unique).
descriptionnvarchar (250)NOT NULLUser defined description.
create_date_utcdatetimeNOT NULL
engagement_template_id_sortablevarchar (48)NOT NULLA representation of the engagement_template_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of engagement_template_id.
office_grouping_type_KEYintNOT NULLKey to a Office Grouping Type that indicates how to determine which office will be assigned to generated engagements.
biller__staff_grouping_type_KEYintNOT NULLKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
reviewer__staff_grouping_type_KEYintNOT NULLKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
manager__staff_grouping_type_KEYintNOT NULLKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
is_defaultbitNOT NULLWhether or not this engagement will be used as a default for new clients that are entered.
Primary key
NameColumnsDescription
PK_Engagement_Template$engagement_template_KEYengagement_template_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Engagement_Template$engagement_template_idengagement_template_idEach id must be unique.
UK_Engagement_Template$engagement_template_id_sortableengagement_template_id_sortableAn index by the sortable ID is desired, and the algorithm ends up producing unique values.
Indexes
NameColumnsDescription
IX_Engagement_Template$biller__staff_grouping_type_KEYbiller__staff_grouping_type_KEYIndex supports foreign key FK_Engagement_Template__Staff_Grouping_Type__biller__staff_grouping_type_KEY
IX_Engagement_Template$manager__staff_grouping_type_KEYmanager__staff_grouping_type_KEYIndex supports foreign key FK_Engagement_Template__Staff_Grouping_Type__manager__staff_grouping_type_KEY
IX_Engagement_Template$office_grouping_type_KEYoffice_grouping_type_KEYIndex supports foreign key FK_Engagement_Template__Office_Grouping_Type__office_grouping_type_KEY
IX_Engagement_Template$reviewer__staff_grouping_type_KEYreviewer__staff_grouping_type_KEYIndex supports foreign key FK_Engagement_Template__Staff_Grouping_Type__reviewer__staff_grouping_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Engagement_Template__Staff_Grouping_Type__biller__staff_grouping_type_KEYbiller__staff_grouping_type_KEYStaff_Grouping_Type
FK_Engagement_Template__Staff_Grouping_Type__manager__staff_grouping_type_KEYmanager__staff_grouping_type_KEYStaff_Grouping_Type
FK_Engagement_Template__Staff_Grouping_Type__reviewer__staff_grouping_type_KEYreviewer__staff_grouping_type_KEYStaff_Grouping_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project_Template__Engagement_Template__engagement_template_KEYengagement_template_KEYProject_Template
FK_Engagement__Engagement_Template__engagement_template_KEYengagement_template_KEYEngagement
FK_User_Preference__Engagement_Template__entry__engagement_template_KEYentry__engagement_template_KEYUser_Preference

Schema diagram