AdventureWorks

Basic Index   Expanded Index

Table Name:HumanResources.Department
Description:Lookup table containing the departments within the Adventure Works Cycles company.
Primary Keys:DepartmentID
FieldTypeDefaultsNulls?Comments
DepartmentIDsmallint - IdentityNoneNoPrimary key for Department records.
Namenvarchar (50)NoneNoName of the department.
GroupNamenvarchar (50)NoneNoName of the group to which the department belongs.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Department_DepartmentIDYesYesDepartmentID
AK_Department_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_EmployeeDepartmentHistory_Department_DepartmentIDHumanResources.EmployeeDepartmentHistoryDepartmentID

No triggers