HumanResources.Shift

Table: 'HumanResources.Shift'

5 fields. 149 bytes.

Work shift lookup table.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ShiftID	tinyint identity		tinyint		Not null	Primary key for Shift records.
Name	Name		nvarchar(50)		Not null	Shift description.
StartTime	datetime				Not null	Shift start time.
EndTime	datetime				Not null	Shift end time.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.Shift'

Primary Key Name	Field Name
PK_Shift_ShiftID	ShiftID

There are no Foreign Keys for this table.

Indexes for table 'HumanResources.Shift', 3 items

Index Name	Description	Clustered	Unique	Fields
PK_Shift_ShiftID	Clustered index created by a primary key constraint.	Yes	Yes	ShiftID
AK_Shift_Name	Unique nonclustered index.	No	Yes	Name
AK_Shift_StartTime_EndTime	Unique nonclustered index.	No	Yes	StartTime, EndTime

Triggers for table 'HumanResources.Shift', 1 item

Name	Description	Type	Enabled
uShift	AFTER 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 Name	Type	Field Name
HumanResources.uShift	trigger	N/A
HumanResources.vEmployeeDepartmentHistory	view	N/A