Export (0) Print
Expand All
Expand Minimize

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:
© 2014 Microsoft