| Column | Data Type | Nullable | Default | Description / PK / Index |
| ShiftID | tinyint | not null | | Primary key for Shift records.
PK_Shift_ShiftID |
| Name | dbo.Name | not null | | Shift description.
AK_Shift_Name |
| StartTime | datetime | not null | | Shift start time.
AK_Shift_StartTime_EndTime |
| EndTime | datetime | not null | | Shift end time.
AK_Shift_StartTime_EndTime |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|