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...) |
|||
| Line 67: | Line 67: | ||
| ShiftID | | ShiftID | ||
| ShiftID | | ShiftID | ||
| + | |} | ||
| + | |||
| + | == wikivalues == | ||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- | ||
| + | | '''Table Values | ||
| + | | HumanResources.Shift | ||
| + | |- | ||
| + | |} | ||
| + | |||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''ShiftID | ||
| + | | '''Name | ||
| + | | '''StartTime | ||
| + | | '''EndTime | ||
| + | |- | ||
| + | | 1 | ||
| + | | Day | ||
| + | | CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120) | ||
| + | | CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120) | ||
| + | |- | ||
| + | | 2 | ||
| + | | Evening | ||
| + | | CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120) | ||
| + | | CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120) | ||
| + | |- | ||
| + | | 3 | ||
| + | | Night | ||
| + | | CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120) | ||
| + | | CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120) | ||
|} | |} | ||
Revision as of 14:53, 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 | CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120) | CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120) |
| 2 | Evening | CONVERT(DATETIME, '1900-01-01 15:00:00.000', 120) | CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120) |
| 3 | Night | CONVERT(DATETIME, '1900-01-01 23:00:00.000', 120) | CONVERT(DATETIME, '1900-01-01 07:00:00.000', 120) |
