Table: Office_Grouping_Type
Determines the office grouping type for a engagement template.
Tags: read-only

Content:
999<Client>'s <Office>
1000Specified <Office>
Columns
NameTypeConstraintsDescription
office_grouping_type_KEYintNOT NULLDatabase assigned primary key for this table.
descriptionnvarchar (50)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Office_Grouping_Type$office_grouping_type_KEYoffice_grouping_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Office_Grouping_Type__descriptiondescriptionEach Office Grouping Type must have a different description.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Template__Office_Grouping_Type__office_grouping_type_KEYoffice_grouping_type_KEYEngagement_Template

Schema diagram