Databases > AdventureWorks2019 > Tables > HumanResources.Department

AdventureWorks2019

HumanResources.Department

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

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    DepartmentID
    [smallint] IDENTITY (1,1) NOT NULL
  • //
    ${escapify(column.description)}
    Name
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    GroupName
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_Department_DepartmentID
    UNIQUE CLUSTERED
    DepartmentID
  • //
    Unique nonclustered index.
    AK_Department_Name
    UNIQUE NONCLUSTERED
    Name

Sample Data

DepartmentID
Name
GroupName
ModifiedDate
1
Engineering
Research and Development
2
Tool Design
Research and Development
3
Sales
Sales and Marketing
4
Marketing
Sales and Marketing
5
Purchasing
Inventory Management
6
Research and Development
Research and Development
7
Production
Manufacturing
8
Production Control
Manufacturing
9
Human Resources
Executive General and Administration
10
Finance
Executive General and Administration
11
Information Services
Executive General and Administration
12
Document Control
Quality Assurance
13
Quality Assurance
Quality Assurance
14
Facilities and Maintenance
Executive General and Administration
15
Shipping and Receiving
Inventory Management
16
Executive
Executive General and Administration