Difference between revisions of "HumanResources.Shift (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HumanResources.Shift |- |} {| border="1" cellpadding="5" cellspacing="0" sty...) |
(No difference)
|
Revision as of 14:35, 3 January 2009
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 |
