Table: Department_Grouping_Type
Tags: read-only

Content:
9981000<ProjectResponsible>'s <Department>Project[KEY(Staff department(Project responsible staff(Project)))]
9992000<ProjectAssigned>'s <Department>Project[KEY(Staff department(Project assigned staff(Project)))]
10003000Specified <Department>
Columns
NameTypeConstraintsDescription
department_grouping_type_KEYintNOT NULLPrimary key for this table.
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (250)NOT NULLDescription.
table_namenvarchar (128)NOT NULLName of the table used to find the value.
column_namenvarchar (128)NOT NULLName of the column used to find the value.
Primary key
NameColumnsDescription
PK_Department_Grouping_Type$department_grouping_type_KEYdepartment_grouping_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Department_Grouping_Type$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Project_Template__Department_Grouping_Type__department_grouping_type_KEYdepartment_grouping_type_KEYProject_Template

Schema diagram