HumanResources.Shift
| Documentation | AdventureWorks |
| Schema | HumanResources |
| Name | Shift |
| Module | Human Resources |
Work shift lookup table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ShiftID | tinyint | Identity | Primary key for Shift records. | ||||
| Primary key for Shift records. Identity |
||||||||
| 2 | Name | nvarchar(50) | Shift description. | |||||
| Shift description. |
||||||||
| 3 | StartTime | time(7) | Shift start time. | |||||
| Shift start time. |
||||||||
| 4 | EndTime | time(7) | Shift end time. | |||||
| Shift end time. |
||||||||
| 5 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
| Date and time the record was last updated. Default: getdate() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| HumanResources.Employee | HumanResources.Shift | zzz zxczxc |
||
|
Name: zzz zxczxc |
||||
| HumanResources.EmployeeDepartmentHistory | HumanResources.Shift | HumanResources.EmployeeDepartmentHistory.ShiftID = HumanResources.Shift.ShiftID | FK_EmployeeDepartmentHistory_Shift_ShiftID Foreign key constraint referencing Shift.ShiftID |
|
|
HumanResources.EmployeeDepartmentHistory.ShiftID = HumanResources.Shift.ShiftID Name: FK_EmployeeDepartmentHistory_Shift_ShiftIDForeign key constraint referencing Shift.ShiftID |
||||
| HumanResources.vEmployeeDepartmentHistory | HumanResources.Shift | HumanResources.vEmployeeDepartmentHistory.Title = HumanResources.Shift.Name | fk_Shift_vEmployeeDepartmentHistory xcbxcvbxcvbbvbvb |
|
|
HumanResources.vEmployeeDepartmentHistory.Title = HumanResources.Shift.Name Name: fk_Shift_vEmployeeDepartmentHistoryxcbxcvbxcvbbvbvb |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_Shift_ShiftID | ShiftID | Primary key (clustered) constraint | |
| Primary key (clustered) constraint | |||
| AK_Shift_Name | Name | Unique nonclustered index. | |
| Unique nonclustered index. | |||
| AK_Shift_StartTime_EndTime | StartTime, EndTime | Unique nonclustered index. | |
| Unique nonclustered index. | |||
Used by
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56