HumanResources.Shift Table

Information

NameShift
SchemaHumanResources
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
ShiftTABLEMS_DescriptionWork shift lookup table.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   ShiftIDtinyint   
 
 
 
   Namenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   StartTimedatetime   
 
 
 
   EndTimedatetime   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_Shift_ShiftIDClustered  ShiftID
AK_Shift_NameNonClustered  Name
AK_Shift_StartTime_EndTimeNonClustered  StartTime, EndTime

SQL Script

CREATE TABLE [HumanResources].[Shift] (
    [ShiftID] tinyint NOT NULL IDENTITY,
    [Name] nvarchar(50) NOT NULL,
    [StartTime] datetime NOT NULL,
    [EndTime] datetime NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_Shift_Name] on [HumanResources].[Shift]([Name]);
CREATE UNIQUE INDEX [AK_Shift_StartTime_EndTime] on [HumanResources].[Shift]([StartTime], [EndTime]);