| Column | Data Type | Nullable | Default | Description / PK / Index |
| DepartmentID | smallint | not null | | Primary key for Department records.
PK_Department_DepartmentID |
| Name | dbo.Name | not null | | Name of the department.
AK_Department_Name |
| GroupName | dbo.Name | not null | | Name of the group to which the department belongs.
|
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|