Owner: | HumanResources |
Creation Date: | 04/26/2006 |
Located On: | PRIMARY |
Data Size KB: | 8 |
Index Size KB: | 40 |
Rows: | 3 |
Description: | Work shift lookup table. |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
ShiftID | tinyint | 1 | Primary key for Shift records. | ||||||
Name | Name | 100 | Shift description. | ||||||
StartTime | datetime | 8 | Shift start time. | ||||||
EndTime | datetime | 8 | Shift end time. | ||||||
ModifiedDate | datetime | 8 | (getdate()) | Date and time the record was last updated. |
Name | Seed | Increment | Not for replication | |
ShiftID | 1 | 1 |
Index | Primary | Unique | Description | |
PK_Shift_ShiftID | Primary key (clustered) constraint | |||
AK_Shift_Name | Unique nonclustered index. | |||
AK_Shift_StartTime_EndTime | Unique nonclustered index. |
Table | Foreign Key | Primary Key or Unique Constraint | |
HumanResources.EmployeeDepartmentHistory | FK_EmployeeDepartmentHistory_Shift_ShiftID | PK_Shift_ShiftID |
Objects that [HumanResources].[Shift] depends on
Object Name | Owner | Object Type | Dep Level | |
Name | dbo | User Defined type | 1 |
Objects that depend on [HumanResources].[Shift]
Object Name | Owner | Object Type | Dep Level | |
EmployeeDepartmentHistory | HumanResources | Table | 1 | |
vEmployeeDepartment | HumanResources | View | 2 | |
vEmployeeDepartmentHistory | HumanResources | View | 2 |
CREATE TABLE [Shift] (
[ShiftID] [tinyint] IDENTITY (1, 1) NOT NULL ,
[Name] [Name] NOT NULL ,
[StartTime] [datetime] NOT NULL ,
[EndTime] [datetime] NOT NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Shift_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_Shift_ShiftID] PRIMARY KEY CLUSTERED
(
[ShiftID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
See Also
List of tables