Difference between revisions of "HumanResources.Shift (table)"

From dbscript Online Help
Jump to: navigation, search
Line 123: Line 123:
  
 
|}
 
|}
 
 
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| HumanResources.Shift
 
| HumanResources.Shift
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
|- style="background:silver"
 
 
| '''ShiftID
 
| '''ShiftID
 
| '''Name
 
| '''Name
 
| '''StartTime
 
| '''StartTime
 
| '''EndTime
 
| '''EndTime
|-  
+
|- valign="top"
| 1
+
 
| Day
+
| 1
| 1900-01-01 07:00:00.000
+
| Day
| 1900-01-01 15:00:00.000
+
| 1900-01-01 07:00:00.000
|-  
+
| 1900-01-01 15:00:00.000
| 2
+
|- valign="top"
| Evening
+
 
| 1900-01-01 15:00:00.000
+
| 2
| 1900-01-01 23:00:00.000
+
| Evening
|-  
+
| 1900-01-01 15:00:00.000
| 3
+
| 1900-01-01 23:00:00.000
| Night
+
|- valign="top"
| 1900-01-01 23:00:00.000
+
 
| 1900-01-01 07:00:00.000
+
| 3
 +
| Night
 +
| 1900-01-01 23:00:00.000
 +
| 1900-01-01 07:00:00.000
 
|}
 
|}
  

Revision as of 23:18, 23 June 2010

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

automatically generated

Table HumanResources.Shift
Description Work shift lookup table.


Column Data Type Nullable Default Description / PK / Index
ShiftID tinyint not null Primary key for Shift records.
PK_Shift_ShiftID
Name Name not null Shift description.
AK_Shift_Name
StartTime datetime not null Shift start time.
AK_Shift_StartTime_EndTime
EndTime datetime not null Shift end time.
AK_Shift_StartTime_EndTime
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory ShiftID ShiftID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema HumanResources


Reference Type Object Type Referencing Object
Select View HumanResources.vEmployeeDepartmentHistory