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

From dbscript Online Help
Jump to: navigation, search
 
(13 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 ==
 
== automatically generated ==
  
Line 106: Line 166:
 
| '''Table
 
| '''Table
 
| HumanResources.Shift
 
| HumanResources.Shift
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Work shift lookup table.
 
| Work shift lookup table.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 128: Line 186:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Shift records.PK_Shift_ShiftID
+
| Primary key for Shift records.<br />PK_Shift_ShiftID
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 134: Line 192:
 
| not null
 
| not null
 
|  
 
|  
−
| Shift description.AK_Shift_Name
+
| Shift description.<br />AK_Shift_Name
 
|- valign="top"
 
|- valign="top"
 
| StartTime
 
| StartTime
Line 140: Line 198:
 
| not null
 
| not null
 
|  
 
|  
−
| Shift start time.AK_Shift_StartTime_EndTime
+
| Shift start time.<br />AK_Shift_StartTime_EndTime
 
|- valign="top"
 
|- valign="top"
 
| EndTime
 
| EndTime
Line 146: Line 204:
 
| not null
 
| not null
 
|  
 
|  
−
| Shift end time.AK_Shift_StartTime_EndTime
+
| Shift end time.<br />AK_Shift_StartTime_EndTime
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 152: Line 210:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 172: Line 230:
 
{| 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"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
 
−
 
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
−
| Type
+
 
−
| Data Type
+
|-
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 
 
|}
 
|}
  
Line 185: Line 249:
 
{| 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"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
+
 
−
| '''Reference Type
 
−
 
 
|-
 
|-
 +
| Select
 +
| View
 
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
−
| View
+
 
−
| Select
 
 
|}
 
|}

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"