Sales.SpecialOfferProduct Table

Information

NameSpecialOfferProduct
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
SpecialOfferProductTABLEMS_DescriptionCross-reference table mapping products to special offer discounts.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   SpecialOfferIDint  Sales.SpecialOffer.SpecialOfferID
 
 
 
   ProductIDint  Production.Product.ProductID
 
 
 
   rowguiduniqueidentifier   
(newid())
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_SpecialOfferProduct_SpecialOfferID_ProductIDClustered  SpecialOfferID, ProductID
AK_SpecialOfferProduct_rowguidNonClustered  rowguid
IX_SpecialOfferProduct_ProductIDNonClustered  ProductID

Foreign Key Constraints

NameTypeReferenced Table
FK_SpecialOfferProduct_Product_ProductIDForeign keyProduction.Product
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferIDForeign keySales.SpecialOffer

SQL Script

CREATE TABLE [Sales].[SpecialOfferProduct] (
    [SpecialOfferID] int NOT NULL,
    [ProductID] int NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_SpecialOfferProduct_rowguid] on [Sales].[SpecialOfferProduct]([rowguid]);
CREATE INDEX [IX_SpecialOfferProduct_ProductID] on [Sales].[SpecialOfferProduct]([ProductID]);