AdventureWorks
| Table Name: | HumanResources.Department |
| Description: | Lookup table containing the departments within the Adventure Works Cycles company. |
| Primary Keys: | DepartmentID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| DepartmentID | smallint - Identity | None | No | Primary key for Department records. |
| Name | nvarchar (50) | None | No | Name of the department. |
| GroupName | nvarchar (50) | None | No | Name of the group to which the department belongs. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Department_DepartmentID | Yes | Yes | DepartmentID |
| AK_Department_Name | No | Yes | Name |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_EmployeeDepartmentHistory_Department_DepartmentID | HumanResources.EmployeeDepartmentHistory | DepartmentID |