Production.ProductModel - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductModel
Module	Products

Product model classification.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductModelID	int		Identity		Primary key for ProductModel records.
Primary key for ProductModel records. Identity
	2		Name	nvarchar(50)				Product model description.
Product model description.
	3		CatalogDescription	xml				Detailed product catalog information in xml format.
Detailed product catalog information in xml format.
	4		Instructions	xml				Manufacturing instructions in xml format.
Manufacturing instructions in xml format.
	5		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	6		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.Product		Production.ProductModel	Production.Product.ProductModelID = Production.ProductModel.ProductModelID	FK_Product_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.Product.ProductModelID = Production.ProductModel.ProductModelID Name: FK_Product_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelIllustration		Production.ProductModel	Production.ProductModelIllustration.ProductModelID = Production.ProductModel.ProductModelID	FK_ProductModelIllustration_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelIllustration.ProductModelID = Production.ProductModel.ProductModelID Name: FK_ProductModelIllustration_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelProductDescriptionCulture		Production.ProductModel	Production.ProductModelProductDescriptionCulture.ProductModelID = Production.ProductModel.ProductModelID	FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelProductDescriptionCulture.ProductModelID = Production.ProductModel.ProductModelID Name: FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.

Unique keys

	Key name	Columns	Description
	PK_ProductModel_ProductModelID	ProductModelID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_ProductModel_Name	Name	Unique nonclustered index.
Unique nonclustered index.
	AK_ProductModel_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Used by

Name
Production.ProductModel
Production.vProductAndDescription
Production.vProductModelCatalogDescription
Production.vProductModelInstructions
Production.Product
Production.ProductModelIllustration
Production.ProductModelProductDescriptionCulture

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56