Production.ProductModel (table)

wikibot

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	dbo.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

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

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

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

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

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