Generated using SQL Data Dictionary demo version.


Table HumanResources.Shift (3 rows)


Work shift lookup table.


  Column Data Type Identity Nullable Default
PK ShiftID tinyint X
Primary key for Shift records.
UK Name Name(nvarchar(50))
Shift description.
UK StartTime time
Shift start time.
UK EndTime time
Shift end time.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


Referenced by:


Used by: