Sales.SpecialOfferProduct (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:53Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:20Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:35Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:19Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:42Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:57Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:10Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:22Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:35Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOfferProduct |- |} {| border="1" cellpadding="5" cellspacing="0...

2009-01-03T12:35:11Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SpecialOfferProduct |- |} {| border="1" cellpadding="5" cellspacing="0...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| Sales.SpecialOfferProduct
|-
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''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())
|
|
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation
| '''Column
| '''Referenced Column

|-
| [[Production.Product_(table)|Production.Product]]
| ProductID
| ProductID
|-
| [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
| SpecialOfferID
| SpecialOfferID
|}

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table
| '''Column
| '''Referencing Column

|-
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
| SpecialOfferID
| SpecialOfferID
|-
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
| SpecialOfferID
| SpecialOfferID
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SpecialOfferProduct
@@ Line 8: / Line 8: @@
 | '''Description
 | Cross-reference table mapping products to special offer discounts.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SpecialOfferID
@@ Line 52: / Line 50: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SpecialOfferProduct_SpecialOfferID_ProductID
 | SpecialOfferID, ProductID
@@ Line 63: / Line 61: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SpecialOfferProduct_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | IX_SpecialOfferProduct_ProductID
+|
@@ Line 80: / Line 78: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductID
 | ProductID
-|-
+|- valign="top"
 | [[Sales.SpecialOffer_(table)|Sales.SpecialOffer]]
 | SpecialOfferID
@@ Line 97: / Line 95: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | SpecialOfferID
 | SpecialOfferID
-|-
+|- valign="top"
 | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | SpecialOfferID
@@ Line 115: / Line 113: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for SpecialOfferProduct records.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductID
+| Primary key for SpecialOfferProduct records.
 |- valign="top"
 | ProductID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Product identification number. Foreign key to Product.ProductID.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
+| Product identification number. Foreign key to Product.ProductID.
 |- valign="top"
 | rowguid
@@ Line 37: / Line 38: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SpecialOfferProduct_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 64: / Line 91: @@
 |}
+=== Detail Tables ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 81: / Line 108: @@
 |}

@@ Line 89: / Line 89: @@
 | Sales.SpecialOfferProduct
 |- valign="top"
 | '''Description
 | Cross-reference table mapping products to special offer discounts.
 |-
 |}

@@ Line 169: / Line 169: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}

@@ Line 88: / Line 88: @@
 | '''Table
 | Sales.SpecialOfferProduct
-|-
+|- valign="top"
 | '''Description
@@ Line 110: / Line 110: @@
 | not null
+|
-| Primary key for SpecialOfferProduct records.PK_SpecialOfferProduct_SpecialOfferID_ProductID
+| Primary key for SpecialOfferProduct records.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductID
 |- valign="top"
 | ProductID
@@ Line 116: / Line 116: @@
 | not null
+|
-| Product identification number. Foreign key to Product.ProductID.PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
+| Product identification number. Foreign key to Product.ProductID.<br />PK_SpecialOfferProduct_SpecialOfferID_ProductIDIX_SpecialOfferProduct_ProductID
 |- valign="top"
 | rowguid
@@ Line 122: / Line 122: @@
 | not null
 | (NEWID())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_SpecialOfferProduct_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SpecialOfferProduct_rowguid
 |- valign="top"
 | ModifiedDate
@@ Line 128: / Line 128: @@
 | not null
 | (GETDATE())
-| Date and time the record was last updated.
+| Date and time the record was last updated.<br />
 |}