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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft