HumanResources.Shift (table)
wikibot
| Table | HumanResources.Shift |
| Column | Data Type | Nullable | Default | PK | Index |
| ShiftID | tinyint | not null | PK_Shift_ShiftID | ||
| Name | dbo.Name | not null | AK_Shift_Name | ||
| StartTime | datetime | not null | AK_Shift_StartTime_EndTime | ||
| EndTime | datetime | not null | AK_Shift_StartTime_EndTime | ||
| ModifiedDate | datetime | not null | (getdate()) |
| Detail Table | Column | Referencing Column |
| HumanResources.EmployeeDepartmentHistory | ShiftID | ShiftID |
