Production.ProductModel (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:48Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:06Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:56Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:40Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:01Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:50Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:08Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:31Z

Bot at 22:57, 26 November 2009

2009-11-26T22:57:43Z

Bot at 22:26, 26 November 2009

2009-11-26T22:26:57Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.ProductModel
@@ Line 8: / Line 8: @@
 | '''Description
 | Product model classification.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ProductModelID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ProductModel_ProductModelID
 | ProductModelID
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_ProductModel_Name
 | Unique
 | Name
-|-
+|- valign="top"
 | AK_ProductModel_rowguid
 | Unique
 | rowguid
-|-
+|- valign="top"
 | PXML_ProductModel_CatalogDescription
+|
 | CatalogDescription
-|-
+|- valign="top"
 | PXML_ProductModel_Instructions
+|
@@ Line 100: / Line 98: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Production.Product_(table)|Production.Product]]
 | ProductModelID
 | ProductModelID
-|-
+|- valign="top"
 | [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 | ProductModelID
 | ProductModelID
-|-
+|- valign="top"
 | [[Production.ProductModelProductDescriptionCulture_(table)|Production.ProductModelProductDescriptionCulture]]
 | ProductModelID
@@ Line 122: / Line 120: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-|-
+|- valign="top"
 | Schema
 | Schema
 | [[Production_(schema)|Production]]
-|-
+|- valign="top"
 | Data Type
 | XML Schema Collection
-| [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
+| [[Production.ManuInstructionsSchemaCollection_(xml schema collection)|Production.ManuInstructionsSchemaCollection]]
-|-
+|- valign="top"
 | Data Type
 | XML Schema Collection
-| [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
+| [[Production.ProductDescriptionSchemaCollection_(xml schema collection)|Production.ProductDescriptionSchemaCollection]]
 |}
@@ Line 151: / Line 149: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
-|-
+|- valign="top"
 | Select
 | View
 | [[Production.vProductModelCatalogDescription_(view)|Production.vProductModelCatalogDescription]]
-|-
+|- valign="top"
 | Select
 | View

@@ 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 ProductModel records.<br />PK_ProductModel_ProductModelID
+| Primary key for ProductModel records.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Product model description.<br />AK_ProductModel_Name
+| Product model description.
 |- valign="top"
 | CatalogDescription
@@ Line 37: / Line 38: @@
 | null
+|
-| Detailed product catalog information in xml format.<br />PXML_ProductModel_CatalogDescription
+| Detailed product catalog information in xml format.
 |- valign="top"
 | Instructions
@@ Line 43: / Line 44: @@
 | null
+|
-| Manufacturing instructions in xml format.<br />PXML_ProductModel_Instructions
+| Manufacturing instructions in xml format.
 |- valign="top"
 | rowguid
@@ Line 49: / Line 50: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductModel_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | 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 80: / Line 115: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 91: / Line 126: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |-
@@ Line 104: / Line 144: @@
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 127: / Line 167: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.ProductModel
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | ProductModelID
 | int
 | not null
+|
-| PK_ProductModel_ProductModelID
+| Primary key for ProductModel records.<br />PK_ProductModel_ProductModelID
+|- valign="top"
 | Name
 | dbo.Name
 | not null
+|
+| Product model description.<br />AK_ProductModel_Name
-| AK_ProductModel_Name
+|- valign="top"
 | CatalogDescription
 | xml
 | null
+|
+| Detailed product catalog information in xml format.<br />PXML_ProductModel_CatalogDescription
-| PXML_ProductModel_CatalogDescription
+|- valign="top"
 | Instructions
 | xml
 | null
+|
+| Manufacturing instructions in xml format.<br />PXML_ProductModel_Instructions
-| PXML_ProductModel_Instructions
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ProductModel_rowguid
-| AK_ProductModel_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 83: / Line 79: @@
 | ProductModelID
 |}
 == automatically generated ==

@@ Line 90: / Line 90: @@
 | Production.ProductModel
 |- valign="top"
 | '''Description
 | Product model classification.
 |-
 |}

@@ Line 169: / Line 169: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[dbo.Name_(type)|dbo.Name]]
-| Type
 |-
 | Schema
 | Schema
 |-
 | [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
 | XML Schema Collection
 | [[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|Production.ProductDescriptionSchemaCollection]]
-| XML Schema Collection
 |}
@@ Line 194: / Line 198: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 | View
 | Select
 | View
 | [[Production.vProductModelInstructions_(view)|Production.vProductModelInstructions]]
-| View
 |}

@@ Line 172: / Line 172: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Name_(type)|dbo.Name]]
 | Type
 | Data Type
 |-
 | [[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|Production.ManuInstructionsSchemaCollection]]
@@ Line 193: / Line 197: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]