Sales.SpecialOffer

Columns

• //

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

  ${escapify(column.description)}
  Description
  [nvarchar](255) NOT NULL
• //

  ${escapify(column.description)}
  DiscountPct
  [smallmoney] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [DiscountPct] >= (0.00)

  ([DiscountPct]>=(0.00))
• //

  ${escapify(column.description)}
  Type
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  Category
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  StartDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  EndDate
  [datetime] NOT NULL
• //

  ${escapify(column.description)}
  MinQty
  [int] NOT NULL DEFAULT ((0))

  //

  CONSTRAINT: Check constraint [MinQty] >= (0)

  ([MinQty]>=(0))
• //

  ${escapify(column.description)}
  MaxQty
  [int] NULL

  //

  CONSTRAINT: Check constraint [MaxQty] >= (0)

  ([MaxQty]>=(0))
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_SpecialOffer_SpecialOfferID
  UNIQUE CLUSTERED
  SpecialOfferID
• //

  Unique nonclustered index. Used to support replication samples.
  AK_SpecialOffer_rowguid
  UNIQUE NONCLUSTERED
  rowguid

Check Constraints

• //

  Check constraint [EndDate] >= [StartDate]
  CK_SpecialOffer_EndDate
  ([EndDate]>=[StartDate])

Sample Data