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

automatically generated

Table	HumanResources.Shift
Description	Work shift lookup table.

Column	Data Type	Nullable	Default	Description	PK / Index
ShiftID	tinyint	not null		Primary key for Shift records.	PK_Shift_ShiftID
Name	Name	not null		Shift description.	AK_Shift_Name
StartTime	datetime	not null		Shift start time.	AK_Shift_StartTime_EndTime
EndTime	datetime	not null		Shift end time.	AK_Shift_StartTime_EndTime
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
HumanResources.EmployeeDepartmentHistory	ShiftID	ShiftID