Object type: Table

Lookup table containing the departments within the Adventure Works Cycles company.

Columns 

Name	Data type	Nullable	Description
DepartmentID	smallint	No	Column has identity seed value of 1 with a step value of 1. Primary key for Department records.
Name	Name	No	Name of the department.
GroupName	Name	No	Name of the group to which the department belongs.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_Department_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_Department_DepartmentID	PRIMARY KEY	DepartmentID	Clustered index created by a primary key constraint.

Indices 

Name	Description
AK_Department_Name	Unique nonclustered index.

Triggers 

Name	Description
HumanResources.uDepartment	AFTER UPDATE trigger setting the ModifiedDate column in the Department table to the current date.

Linked tables 

Name	Description
HumanResources.EmployeeDepartmentHistory	Employee department transfers.

Accessed by 

Name	Description
HumanResources.vEmployeeDepartment	Returns employee name, title, and current department.
HumanResources.vEmployeeDepartmentHistory	Returns employee name and current and previous departments.

Modified by 

Name	Description
HumanResources.uDepartment	AFTER UPDATE trigger setting the ModifiedDate column in the Department table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation