HumanResources Shift (table)

wikibot ¶

Table	HumanResources.Shift
Description	Work shift lookup table.

Columns ¶

Column	Data Type	Nullable	Default	Description
ShiftID	tinyint	not null		Primary key for Shift records.
Name	dbo.Name	not null		Shift description.
StartTime	datetime	not null		Shift start time.
EndTime	datetime	not null		Shift end time.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_Shift_ShiftID	ShiftID

Indexes ¶

Index	Type	Columns
AK_Shift_Name	Unique	Name
AK_Shift_StartTime_EndTime	Unique	StartTime, EndTime

Detail Tables ¶

Detail Table	Column	Referencing Column
HumanResources.EmployeeDepartmentHistory	ShiftID	ShiftID

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	HumanResources

Dependencies ¶

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployeeDepartmentHistory

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