Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Sales SpecialOfferProduct (table)
Print
RSS
Modified on 2011/08/27 11:19
by
wikibot
Categorized as
Uncategorized
Production Product (table)
Sales (schema)
Sales SalesOrderDetail (table)
Sales SpecialOffer (table)
Production Product (table)
Sales (schema)
Sales SalesOrderDetail (table)
Sales SpecialOffer (table)
»
Sales SpecialOfferProduct (table)
[X]
»
Sales SpecialOfferProduct (table)
wikibot
¶
Table
Sales.SpecialOfferProduct
Description
Cross-reference table mapping products to special offer discounts.
Columns
¶
Column
Data Type
Nullable
Default
Description
SpecialOfferID
int
not null
Primary key for SpecialOfferProduct records.
ProductID
int
not null
Product identification number. Foreign key to Product.ProductID.
rowguid
uniqueidentifier
not null
(newid())
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_SpecialOfferProduct_SpecialOfferID_ProductID
SpecialOfferID, ProductID
Indexes
¶
Index
Type
Columns
AK_SpecialOfferProduct_rowguid
Unique
rowguid
IX_SpecialOfferProduct_ProductID
ProductID
Foreign Keys
¶
Relation
Column
Referenced Column
Production.Product
ProductID
ProductID
Sales.SpecialOffer
SpecialOfferID
SpecialOfferID
Detail Tables
¶
Detail Table
Column
Referencing Column
Sales.SalesOrderDetail
SpecialOfferID
SpecialOfferID
Sales.SalesOrderDetail
SpecialOfferID
SpecialOfferID
References
¶
Dependency Type
Object Type
Referenced Object
Schema
Schema
Sales
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.