HumanResources.Shift

Generated using SQL Data Dictionary demo version.

Table HumanResources.Shift (3 rows)

Work shift lookup table.

	Column	Data Type	Identity	Nullable	Default
PK	ShiftID	tinyint	X
Primary key for Shift records.
UK	Name	Name(nvarchar(50))
Shift description.
UK	StartTime	time
Shift start time.
UK	EndTime	time
Shift end time.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_Shift_ShiftID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- ShiftID

AK_Shift_Name
- (Unique)
Unique nonclustered index.
- Name

AK_Shift_StartTime_EndTime
- (Unique)
Unique nonclustered index.
- StartTime
- EndTime

Referenced by:

HumanResources.EmployeeDepartmentHistory
- ShiftID

Used by:

View
HumanResources.vEmployeeDepartmentHistory
- Name
- ShiftID