Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
HumanResources Shift (table)
Print
RSS
Modified on 2011/08/27 11:17
by
wikibot
Categorized as
Uncategorized
dbo Name (type)
HumanResources (schema)
HumanResources EmployeeDepartmentHistory (table)
HumanResources vEmployeeDepartmentHistory (view)
dbo Name (type)
HumanResources (schema)
HumanResources EmployeeDepartmentHistory (table)
HumanResources vEmployeeDepartmentHistory (view)
»
HumanResources Shift (table)
[X]
»
HumanResources Shift (table)
wikibot
¶
Table
HumanResources.Shift
Description
Work shift lookup table.
Columns
¶
Column
Data Type
Nullable
Default
Description
ShiftID
tinyint
not null
Primary key for Shift records.
Name
dbo.Name
not null
Shift description.
StartTime
datetime
not null
Shift start time.
EndTime
datetime
not null
Shift end time.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_Shift_ShiftID
ShiftID
Indexes
¶
Index
Type
Columns
AK_Shift_Name
Unique
Name
AK_Shift_StartTime_EndTime
Unique
StartTime, EndTime
Detail Tables
¶
Detail Table
Column
Referencing Column
HumanResources.EmployeeDepartmentHistory
ShiftID
ShiftID
References
¶
Dependency Type
Object Type
Referenced Object
Data Type
Type
dbo.Name
Schema
Schema
HumanResources
Dependencies
¶
Reference Type
Object Type
Referencing Object
Select
View
HumanResources.vEmployeeDepartmentHistory
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.