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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOfferProduct |- |} {| border="1" cellpadding="5" cellspacing="0...)
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| 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"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| SpecialOfferID
 +
| int
 +
| not null
 +
|
 +
| Primary key for SpecialOfferProduct records.
 +
|- valign="top"
 +
| ProductID
 +
| int
 +
| not null
 +
|
 +
| Product identification number. Foreign key to Product.ProductID.
 +
|- valign="top"
 +
| rowguid
 +
| uniqueidentifier
 +
| not null
 +
| (newid())
 +
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (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"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductID
 +
| ProductID
 +
|- valign="top"
 +
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 +
| SpecialOfferID
 +
| SpecialOfferID
 +
|}
 +
 +
=== Detail Tables ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|- valign="top"
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
| SpecialOfferID
 +
| SpecialOfferID
 +
|- valign="top"
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
| 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 ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 127:
 
| '''Table
 
| '''Table
 
| Sales.SpecialOfferProduct
 
| Sales.SpecialOfferProduct
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping products to special offer discounts.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 140:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| SpecialOfferID
 
| SpecialOfferID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_SpecialOfferProduct_SpecialOfferID_ProductID
+
| Primary key for SpecialOfferProduct records.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductID
−
|
+
|- valign="top"
−
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_SpecialOfferProduct_SpecialOfferID_ProductID
+
| Product identification number. Foreign key to Product.ProductID.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_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.<br />AK_SpecialOfferProduct_rowguid
−
| AK_SpecialOfferProduct_rowguid
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 81: Line 201:
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 
| SpecialOfferID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Sales_(schema)|Sales]]
 +
 
|}
 
|}

Latest revision as of 00:17, 24 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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.SpecialOfferProduct_(table)&oldid=2679"