HumanResources.Shift

Columns

• //

  ${escapify(column.description)}
  ShiftID
  [tinyint] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  Name
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  StartTime
  [time](5) NOT NULL
• //

  ${escapify(column.description)}
  EndTime
  [time](5) NOT NULL
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Shift_ShiftID
  UNIQUE CLUSTERED
  ShiftID
• //

  Unique nonclustered index.
  AK_Shift_Name
  UNIQUE NONCLUSTERED
  Name
• //

  Unique nonclustered index.
  AK_Shift_StartTime_EndTime
  UNIQUE NONCLUSTERED
  StartTime , EndTime

Sample Data