From dbscript Online Help
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())
|
|
|