HumanResources.Department
| Documentation | AdventureWorks |
| Schema | HumanResources |
| Name | Department |
| Module | Human Resources |
Lookup table containing the departments within the Adventure Works Cycles company.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | DepartmentID | smallint | Identity | Primary key for Department records. | ||||
| Primary key for Department records. Identity |
||||||||
| 2 | Name | nvarchar(50) | Name of the department. | |||||
| Name of the department. |
||||||||
| 3 | GroupName | nvarchar(50) | Name of the group to which the department belongs. | |||||
| Name of the group to which the department belongs. |
||||||||
| 4 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| HumanResources.EmployeeDepartmentHistory | HumanResources.Department | HumanResources.EmployeeDepartmentHistory.DepartmentID = HumanResources.Department.DepartmentID | FK_EmployeeDepartmentHistory_Department_DepartmentID Foreign key constraint referencing Department.DepartmentID. |
|
|
HumanResources.EmployeeDepartmentHistory.DepartmentID = HumanResources.Department.DepartmentID Name: FK_EmployeeDepartmentHistory_Department_DepartmentIDForeign key constraint referencing Department.DepartmentID. |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_Department_DepartmentID | DepartmentID | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_Department_Name | Name | Unique nonclustered index. | |
| Unique nonclustered index. | |||
Used by
| Name |
|---|
|
HumanResources.Department
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56