Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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