Sales.SpecialOfferProduct (table)

From dbscript Online Help
Revision as of 13:35, 3 January 2009 by Bot (talk | contribs) (New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOfferProduct |- |} {| border="1" cellpadding="5" cellspacing="0...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot

Table Sales.SpecialOfferProduct


Column Data Type Nullable Default PK Index
SpecialOfferID int not null PK_SpecialOfferProduct_SpecialOfferID_ProductID
ProductID int not null PK_SpecialOfferProduct_SpecialOfferID_ProductID IX_SpecialOfferProduct_ProductID
rowguid uniqueidentifier not null (newid()) AK_SpecialOfferProduct_rowguid
ModifiedDate datetime not null (getdate())


Relation Column Referenced Column
Production.Product ProductID ProductID
Sales.SpecialOffer SpecialOfferID SpecialOfferID


Detail Table Column Referencing Column
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID
Sales.SalesOrderDetail SpecialOfferID SpecialOfferID