Table: 'HumanResources.Shift'

5 fields. 149 bytes.

Work shift lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ShiftIDtinyint identity tinyint Not nullPrimary key for Shift records. 
NameName nvarchar(50) Not nullShift description. 
StartTimedatetime   Not nullShift start time. 
EndTimedatetime   Not nullShift end time. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.Shift'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'HumanResources.Shift', 3 items

Index NameDescriptionClusteredUniqueFields
PK_Shift_ShiftIDClustered index created by a primary key constraint.YesYesShiftID
AK_Shift_NameUnique nonclustered index.NoYesName
AK_Shift_StartTime_EndTimeUnique nonclustered index.NoYesStartTime, EndTime

Triggers for table 'HumanResources.Shift', 1 item

uShiftAFTER UPDATE trigger setting the ModifiedDate column in the Shift table to the current date.after Update Yes

Dependencies for table 'HumanResources.Shift', 2 items

Object NameTypeField Name