Difference between revisions of "Sales.SpecialOfferProduct (table)"

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Sales.SpecialOfferProduct
 
| Sales.SpecialOfferProduct
|-
+
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping products to special offer discounts.
 
|}
 
|}
  
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''PK
+
| '''Description
| '''Index
+
 
+
|- valign="top"
|-
 
 
| SpecialOfferID
 
| SpecialOfferID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_SpecialOfferProduct_SpecialOfferID_ProductID
+
| Primary key for SpecialOfferProduct records.
|
+
|- valign="top"
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_SpecialOfferProduct_SpecialOfferID_ProductID
+
| Product identification number. Foreign key to Product.ProductID.
| IX_SpecialOfferProduct_ProductID
+
|- valign="top"
|-
 
 
| rowguid
 
| rowguid
 
| uniqueidentifier
 
| uniqueidentifier
 
| not null
 
| not null
 
| (newid())
 
| (newid())
|  
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
| AK_SpecialOfferProduct_rowguid
+
|- valign="top"
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
|  
+
| Date and time the record was last updated.
|  
+
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_SpecialOfferProduct_SpecialOfferID_ProductID
 +
| SpecialOfferID, ProductID
 
|}
 
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_SpecialOfferProduct_rowguid
 +
| Unique
 +
| rowguid
 +
|- valign="top"
 +
| IX_SpecialOfferProduct_ProductID
 +
|
 +
| ProductID
 +
|}
  
 +
=== Foreign Keys ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 78:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
|-
+
|- valign="top"
 
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 
| SpecialOfferID
 
| SpecialOfferID
Line 66: Line 89:
 
|}
 
|}
  
 
+
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 72: Line 95:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
|-
+
|- valign="top"
 
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 +
|}
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

Table Sales.SpecialOfferProduct
Description Cross-reference table mapping products to special offer discounts.

Columns[edit]

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[edit]

Primary Key Columns
PK_SpecialOfferProduct_SpecialOfferID_ProductID SpecialOfferID, ProductID

Indexes[edit]

Index Type Columns
AK_SpecialOfferProduct_rowguid Unique rowguid
IX_SpecialOfferProduct_ProductID ProductID

Foreign Keys[edit]

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

Detail Tables[edit]

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

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales


automatically generated[edit]

Table Sales.SpecialOfferProduct
Description Cross-reference table mapping products to special offer discounts.


Column Data Type Nullable Default Description / PK / Index
SpecialOfferID int not null Primary key for SpecialOfferProduct records.
PK_SpecialOfferProduct_SpecialOfferID_ProductID
ProductID int not null Product identification number. Foreign key to Product.ProductID.
PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
rowguid uniqueidentifier not null (NEWID()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SpecialOfferProduct_rowguid
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


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


Dependency Type Object Type Referenced Object
Schema Schema Sales