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

From dbscript Online Help
Jump to: navigation, search
 
(15 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| HumanResources.Shift
 
| HumanResources.Shift
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Work shift lookup table.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ShiftID
 
| ShiftID
 
| tinyint
 
| tinyint
 
| not null
 
| not null
 
|  
 
|  
−
| PK_Shift_ShiftID
+
| Primary key for Shift records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Shift description.
−
| AK_Shift_Name
+
|- valign="top"
−
|-
 
 
| StartTime
 
| StartTime
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Shift start time.
−
| AK_Shift_StartTime_EndTime
+
|- valign="top"
−
|-
 
 
| EndTime
 
| EndTime
 
| datetime
 
| datetime
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Shift end time.
−
| AK_Shift_StartTime_EndTime
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_Shift_ShiftID
 +
| ShiftID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_Shift_Name
 +
| Unique
 +
| Name
 +
|- valign="top"
 +
| AK_Shift_StartTime_EndTime
 +
| Unique
 +
| StartTime, EndTime
 +
|}
  
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 62: Line 84:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 
| ShiftID
 
| ShiftID
 
| ShiftID
 
| ShiftID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 +
|}
 +
 +
 
== 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
 +
|}
 +
 
 +
== automatically generated ==
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| HumanResources.Shift
 +
|- valign="top"
 +
| '''Description
 +
| Work shift lookup table.
 +
|-
 +
|}
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description / PK / Index
 +
 +
|- valign="top"
 +
| ShiftID
 +
| tinyint
 +
| not null
 +
|
 +
| Primary key for Shift records.<br />PK_Shift_ShiftID
 +
|- valign="top"
 +
| Name
 +
| Name
 +
| not null
 +
|
 +
| Shift description.<br />AK_Shift_Name
 +
|- valign="top"
 +
| StartTime
 +
| datetime
 +
| not null
 +
|
 +
| Shift start time.<br />AK_Shift_StartTime_EndTime
 +
|- valign="top"
 +
| EndTime
 +
| datetime
 +
| not null
 +
|
 +
| Shift end time.<br />AK_Shift_StartTime_EndTime
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.<br />
 +
|}
 +
 
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
| ShiftID
 +
| ShiftID
 +
|}
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 
 +
|-
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 
 +
|}
 +
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 
 +
|-
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 
 
|}
 
|}

Latest revision as of 09:54, 27 August 2011

wikibot[edit]

Table HumanResources.Shift
Description Work shift lookup table.

Columns[edit]

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[edit]

Primary Key Columns
PK_Shift_ShiftID ShiftID

Indexes[edit]

Index Type Columns
AK_Shift_Name Unique Name
AK_Shift_StartTime_EndTime Unique StartTime, EndTime

Detail Tables[edit]

Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory ShiftID ShiftID

References[edit]

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

Dependencies[edit]

Reference Type Object Type Referencing Object
Select View HumanResources.vEmployeeDepartmentHistory


wikivalues[edit]

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[edit]

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
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.Shift_(table)&oldid=2927"