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

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

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

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployeeDepartmentHistory