AdventureWorks
| Table Name: | HumanResources.Shift |
| Description: | Work shift lookup table. |
| Primary Keys: | ShiftID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ShiftID | tinyint - Identity | None | No | Primary key for Shift records. |
| Name | nvarchar (50) | None | No | Shift description. |
| StartTime | datetime | None | No | Shift start time. |
| EndTime | datetime | None | No | Shift end time. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Shift_ShiftID | Yes | Yes | ShiftID |
| AK_Shift_Name | No | Yes | Name |
| AK_Shift_StartTime_EndTime | No | Yes | StartTime EndTime |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_EmployeeDepartmentHistory_Shift_ShiftID | HumanResources.EmployeeDepartmentHistory | ShiftID |