HumanResources.Shift (table)

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	1900-01-01 07:00:00.000	1900-01-01 15:00:00.000
2	Evening	1900-01-01 15:00:00.000	1900-01-01 23:00:00.000
3	Night	1900-01-01 23:00:00.000	1900-01-01 07:00:00.000