Shift Table (AdventureWorks)
Is a lookup table that contains the work shifts.
Shift Table Definition
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. |
See Also
Reference
Employee Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary