Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableHumanResources.Shift
DescriptionWork shift lookup table.

Columns

ColumnData TypeNullableDefaultDescription
ShiftIDtinyintnot null Primary key for Shift records.
Namedbo.Namenot null Shift description.
StartTimedatetimenot null Shift start time.
EndTimedatetimenot null Shift end time.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Shift_ShiftIDShiftID

Indexes

IndexTypeColumns
AK_Shift_NameUniqueName
AK_Shift_StartTime_EndTimeUniqueStartTime, EndTime

Detail Tables

Detail TableColumnReferencing Column
HumanResources.EmployeeDepartmentHistoryShiftIDShiftID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaHumanResources

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployeeDepartmentHistory

wikivalues

Table ValuesHumanResources.Shift

ShiftIDNameStartTimeEndTime
1Day1900-01-01 07:00:00.0001900-01-01 15:00:00.000
2Evening1900-01-01 15:00:00.0001900-01-01 23:00:00.000
3Night1900-01-01 23:00:00.0001900-01-01 07:00:00.000

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.