Difference between revisions of "HumanResources.Shift (table)"
| Line 68: | Line 68: | ||
| ShiftID | | ShiftID | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
== wikivalues == | == wikivalues == | ||
Revision as of 15:34, 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 |
wikivalues
| Table Values | HumanResources.Shift |
| ShiftID | Name | StartTime | EndTime |
| 1 | Day | 1900-01-01 07:00:00.000 | 1900-01-01 15:00:00.000 |
| 2 | Evening | 1900-01-01 15:00:00.000 | 1900-01-01 23:00:00.000 |
| 3 | Night | 1900-01-01 23:00:00.000 | 1900-01-01 07:00:00.000 |
