← All tables and views
AdventureWorks OLTP table
HumanResources.EmployeeDepartmentHistory
Employee department transfers.
296rows
6 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK 1/4 | HumanResources.Employee.BusinessEntityID |
DepartmentID | INTEGER | no | PK 3/4 | HumanResources.Department.DepartmentID |
ShiftID | INTEGER | no | PK 4/4 | HumanResources.Shift.ShiftID |
StartDate | TEXT | no | PK 2/4 | — |
EndDate | TEXT | yes | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
No additional full-column unique key was found.
1 unique index inspected
sqlite_autoindex_HumanResources.EmployeeDepartmentHistory_1BusinessEntityID + StartDate + DepartmentID + ShiftIDData preview
Sample records
| BusinessEntityID | DepartmentID | ShiftID | StartDate | EndDate | ModifiedDate |
|---|---|---|---|---|---|
| 1 | 16 | 1 | 2009-01-14 | NULL | 2009-01-13 00:00:00.000 |
| 2 | 1 | 1 | 2008-01-31 | NULL | 2008-01-30 00:00:00.000 |
| 3 | 1 | 1 | 2007-11-11 | NULL | 2007-11-10 00:00:00.000 |
| 4 | 1 | 1 | 2007-12-05 | 2010-05-30 | 2010-05-28 00:00:00.000 |
| 4 | 2 | 1 | 2010-05-31 | NULL | 2010-05-30 00:00:00.000 |
| 5 | 1 | 1 | 2008-01-06 | NULL | 2008-01-05 00:00:00.000 |
| 6 | 1 | 1 | 2008-01-24 | NULL | 2008-01-23 00:00:00.000 |
| 7 | 6 | 1 | 2009-02-08 | NULL | 2009-02-07 00:00:00.000 |
Interactive explorer