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