Tables SQL 2005 Adventure Works OLTP

HumanResources.Shift

Object type: Table

Work shift lookup table.

Columns 

Name  Data type  Nullable  Description 
ShiftID  tinyint  No Column has identity seed value of 1 with a step value of 1.
Primary key for Shift records. 
Name  Name  No Shift description. 
StartTime  datetime  No Shift start time. 
EndTime  datetime  No Shift end time. 
ModifiedDate  datetime  No Default value: GETDATE()
Date and time the record was last updated. 

Constraints 

Name  Type  Columns  Description 
DF_Shift_ModifiedDate  DEFAULT  ModifiedDate  Value: GETDATE()
Default constraint value of GETDATE() 
PK_Shift_ShiftID  PRIMARY KEY  ShiftID  Clustered index created by a primary key constraint. 

Indices 

Name  Description 
AK_Shift_Name  Unique nonclustered index. 
AK_Shift_StartTime_EndTime  Unique nonclustered index. 

Triggers 

Name  Description 
HumanResources.uShift  AFTER UPDATE trigger setting the ModifiedDate column in the Shift table to the current date. 

Linked tables 

Name  Description 
HumanResources.EmployeeDepartmentHistory  Employee department transfers. 

Accessed by 

Name  Description 
HumanResources.vEmployeeDepartmentHistory  Returns employee name and current and previous departments. 

Modified by 

Name  Description 
HumanResources.uShift  AFTER UPDATE trigger setting the ModifiedDate column in the Shift table to the current date. 

Applies to

Tables | User
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.