AdventureWorks Database > HumanResources Schema > HumanResources.EmployeeDepartmentHistory Table : PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID Index |
File Group | PRIMARY |
Space Used | 16.00 KB |
Fill Factor | 0 |
Do not Recompute Statistics | ![]() |
Full Text Key | ![]() |
Clustered Index | ![]() |
Primary Key Index | ![]() |
Unique Index | ![]() |
Pad Index | ![]() |
Column | Description | Sort Order | |
---|---|---|---|
![]() | EmployeeID | Employee identification number. Foreign key to Employee.EmployeeID. | Ascending |
![]() | StartDate | Date the employee started work in the department. | Ascending |
![]() | DepartmentID | Department in which the employee worked including currently. Foreign key to Department.DepartmentID. | Ascending |
![]() | ShiftID | Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. | Ascending |
Average key length | 15.00 |
Density | 1.00 |
Rows in the Table | 296 |
Rows Sampled | 296 |
Distribution Steps | 150 |
Updated | Jan 8 2010 8:41AM |