Generated using SQL Data Dictionary demo version.
Employee department transfers.
|Employee identification number. Foreign key to Employee.BusinessEntityID.|
|Department in which the employee worked including currently. Foreign key to Department.DepartmentID.|
|Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.|
|Date the employee started work in the department.|
|Date the employee left the department. NULL = Current department.|
|Date and time the record was last updated.|
Primary key (clustered) constraint