HumanResources.EmployeeDepartmentHistory (table)

wikibot

Table

HumanResources.EmployeeDepartmentHistory

Column	Data Type	Nullable	Default	PK	Index
EmployeeID	int	not null		PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
DepartmentID	smallint	not null		PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID	IX_EmployeeDepartmentHistory_DepartmentID
ShiftID	tinyint	not null		PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID	IX_EmployeeDepartmentHistory_ShiftID
StartDate	datetime	not null		PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
EndDate	datetime	null
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
HumanResources.Department	DepartmentID	DepartmentID
HumanResources.Employee	EmployeeID	EmployeeID
HumanResources.Shift	ShiftID	ShiftID