Tables | SQL 2005 Adventure Works OLTP |
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