Production ProductModel (table)

wikibot ¶

Table	Production.ProductModel
Description	Product model classification.

Columns ¶

Column	Data Type	Nullable	Default	Description
ProductModelID	int	not null		Primary key for ProductModel records.
Name	dbo.Name	not null		Product model description.
CatalogDescription	xml	null		Detailed product catalog information in xml format.
Instructions	xml	null		Manufacturing instructions in xml format.
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 ¶

Primary Key	Columns
PK_ProductModel_ProductModelID	ProductModelID

Indexes ¶

Index	Type	Columns
AK_ProductModel_Name	Unique	Name
AK_ProductModel_rowguid	Unique	rowguid
PXML_ProductModel_CatalogDescription		CatalogDescription
PXML_ProductModel_Instructions		Instructions

Detail Tables ¶

Detail Table	Column	Referencing Column
Production.Product	ProductModelID	ProductModelID
Production.ProductModelIllustration	ProductModelID	ProductModelID
Production.ProductModelProductDescriptionCulture	ProductModelID	ProductModelID

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Production
Data Type	XML Schema Collection	Production.ManuInstructionsSchemaCollection
Data Type	XML Schema Collection	Production.ProductDescriptionSchemaCollection

Dependencies ¶

Reference Type	Object Type	Referencing Object
Select	View	Production.vProductAndDescription
Select	View	Production.vProductModelCatalogDescription
Select	View	Production.vProductModelInstructions