Shift Table (AdventureWorks)

Is a lookup table that contains the work shifts.

The Shift table is contained in the HumanResources schema.

Column

Data type

Nullability

Description

ShiftID

smallint

Not null

Primary keys.

Name

Name (user-defined type)

nvarchar(50)

Not null

Shift description.

StartTime

datetime

Not null

Shift start time.

EndTime

datetime

Not null

Shift end time.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Community Additions

ADD
Show: