Sales.SpecialOffer Table

Information

NameSpecialOffer
SchemaSales
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:55

Extended Properties

NameTypeProperty NameValue
SpecialOfferTABLEMS_DescriptionSale discounts lookup table.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   SpecialOfferIDint   
 
 
 
   Descriptionnvarchar(255) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   DiscountPctsmallmoney   
((0.00))
 
 
   Typenvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   Categorynvarchar(50) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   StartDatedatetime   
 
 
 
   EndDatedatetime   
 
 
 
   MinQtyint   
((0))
 
 
   MaxQtyint   
 
 
 
   rowguiduniqueidentifier   
(newid())
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_SpecialOffer_SpecialOfferIDClustered  SpecialOfferID
AK_SpecialOffer_rowguidNonClustered  rowguid

Check Constraints

NameColumnEnabledTrustedExpression
CK_SpecialOffer_EndDate   ([EndDate]>=[StartDate])
CK_SpecialOffer_DiscountPctDiscountPct  ([DiscountPct]>=(0.00))
CK_SpecialOffer_MinQtyMinQty  ([MinQty]>=(0))
CK_SpecialOffer_MaxQtyMaxQty  ([MaxQty]>=(0))

SQL Script

CREATE TABLE [Sales].[SpecialOffer] (
    [SpecialOfferID] int NOT NULL IDENTITY,
    [Description] nvarchar(255) NOT NULL,
    [DiscountPct] smallmoney NOT NULL DEFAULT ((0.00)),
    [Type] nvarchar(50) NOT NULL,
    [Category] nvarchar(50) NOT NULL,
    [StartDate] datetime NOT NULL,
    [EndDate] datetime NOT NULL,
    [MinQty] int NOT NULL DEFAULT ((0)),
    [MaxQty] int NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SpecialOffer_rowguid] on [Sales].[SpecialOffer]([rowguid]);