AdventureWorks

Basic Index   Expanded Index

Table Name:HumanResources.Shift
Description:Work shift lookup table.
Primary Keys:ShiftID
FieldTypeDefaultsNulls?Comments
ShiftIDtinyint - IdentityNoneNoPrimary key for Shift records.
Namenvarchar (50)NoneNoShift description.
StartTimedatetimeNoneNoShift start time.
EndTimedatetimeNoneNoShift end time.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Shift_ShiftIDYesYesShiftID
AK_Shift_NameNoYesName
AK_Shift_StartTime_EndTimeNoYesStartTime
EndTime

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_EmployeeDepartmentHistory_Shift_ShiftIDHumanResources.EmployeeDepartmentHistoryShiftID

No triggers