Production.ProductModel (table)

wikibot

Table

Production.ProductModel

Column	Data Type	Nullable	Default	PK	Index
ProductModelID	int	not null		PK_ProductModel_ProductModelID
Name	dbo.Name	not null			AK_ProductModel_Name
CatalogDescription	xml	null			PXML_ProductModel_CatalogDescription
Instructions	xml	null			PXML_ProductModel_Instructions
rowguid	uniqueidentifier	not null	(newid())		AK_ProductModel_rowguid
ModifiedDate	datetime	not null	(getdate())

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

Table	Production.ProductModel
Description	Product model classification.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductModelID	int	not null		Primary key for ProductModel records.PK_ProductModel_ProductModelID
Name	Name	not null		Product model description.AK_ProductModel_Name
CatalogDescription	XML	null		Detailed product catalog information in xml format.PXML_ProductModel_CatalogDescription
Instructions	XML	null		Manufacturing instructions in xml format.PXML_ProductModel_Instructions
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_ProductModel_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

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

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

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