Production.ProductModel

Object type: Table

Product model classification.

Columns

Name Data type Nullable Description

ProductModelID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ProductModel records.

Name Name No Product model description.

CatalogDescription XML(Production.ProductDescriptionSchemaCollection) Yes Detailed product catalog information in xml format.

Instructions XML(Production.ManuInstructionsSchemaCollection) Yes Manufacturing instructions in xml format.

rowguid uniqueidentifier No Default value: NEWID()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.

Constraints

Name Type Columns Description

DF_ProductModel_rowguid DEFAULT rowguid Value: NEWID()
Default constraint value of NEWID()

DF_ProductModel_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()

PK_ProductModel_ProductModelID PRIMARY KEY ProductModelID Clustered index created by a primary key constraint.

Indices

Name Description

AK_ProductModel_Name Unique nonclustered index.

AK_ProductModel_rowguid Unique nonclustered index.Used to support replication samples.

PXML_ProductModel_CatalogDescription Primary XML index.

PXML_ProductModel_Instructions Primary XML index.

Triggers

Name Description

Production.uProductModel AFTER UPDATE trigger setting the ModifiedDate column in the ProductModel table to the current date.

Linked tables

Name Description

Production.Product Products sold or used in the manfacturing of sold products.

Production.ProductModelIllustration Cross-reference table mapping product models and illustrations.

Production.ProductModelProductDescriptionCulture Cross-reference table mapping product descriptions and the language the description is written in.

Accessed by

Name Description

Product Catalog Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.

Production.vProductAndDescription Product names and descriptions. Product descriptions are provided in multiple languages.

Production.vProductModelCatalogDescription Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.

Production.vProductModelInstructions Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.

Modified by

Name Description

Production.uProductModel AFTER UPDATE trigger setting the ModifiedDate column in the ProductModel table to the current date.

Applies to

Tables | User

Name	Data type	Nullable	Description
ProductModelID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for ProductModel records.
Name	Name	No	Product model description.
CatalogDescription	XML(Production.ProductDescriptionSchemaCollection)	Yes	Detailed product catalog information in xml format.
Instructions	XML(Production.ManuInstructionsSchemaCollection)	Yes	Manufacturing instructions in xml format.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Name	Type	Columns	Description
DF_ProductModel_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_ProductModel_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ProductModel_ProductModelID	PRIMARY KEY	ProductModelID	Clustered index created by a primary key constraint.

Name	Description
AK_ProductModel_Name	Unique nonclustered index.
AK_ProductModel_rowguid	Unique nonclustered index.Used to support replication samples.
PXML_ProductModel_CatalogDescription	Primary XML index.
PXML_ProductModel_Instructions	Primary XML index.

Name	Description
Production.uProductModel	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModel table to the current date.

Name	Description
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductModelIllustration	Cross-reference table mapping product models and illustrations.
Production.ProductModelProductDescriptionCulture	Cross-reference table mapping product descriptions and the language the description is written in.

Name	Description
Product Catalog	Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.
Production.vProductAndDescription	Product names and descriptions. Product descriptions are provided in multiple languages.
Production.vProductModelCatalogDescription	Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.
Production.vProductModelInstructions	Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.