HumanResources.Shift (table)

From dbscript Online Help
Revision as of 15:53, 3 January 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table HumanResources.Shift


Column Data Type Nullable Default PK Index
ShiftID tinyint not null PK_Shift_ShiftID
Name dbo.Name not null AK_Shift_Name
StartTime datetime not null AK_Shift_StartTime_EndTime
EndTime datetime not null AK_Shift_StartTime_EndTime
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory ShiftID ShiftID

wikivalues

Table Values HumanResources.Shift


ShiftID Name StartTime EndTime
1 Day CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120) CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120)
2 Evening CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120) CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120)
3 Night CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120) CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120)
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.Shift_(table)&oldid=306"