Production.ProductModelProductDescriptionCulture - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductModelProductDescriptionCulture
Module	Products

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductModelID	int			Production.ProductModel	Primary key. Foreign key to ProductModel.ProductModelID.
Primary key. Foreign key to ProductModel.ProductModelID. References: Production.ProductModel
	2		ProductDescriptionID	int			Production.ProductDescription	Primary key. Foreign key to ProductDescription.ProductDescriptionID.
Primary key. Foreign key to ProductDescription.ProductDescriptionID. References: Production.ProductDescription
	3		CultureID	nchar(6)			Production.Culture	Culture identification number. Foreign key to Culture.CultureID.
Culture identification number. Foreign key to Culture.CultureID. References: Production.Culture
	4		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.ProductModelProductDescriptionCulture		Production.Culture	Production.ProductModelProductDescriptionCulture.CultureID = Production.Culture.CultureID	FK_ProductModelProductDescriptionCulture_Culture_CultureID Foreign key constraint referencing Culture.CultureID.
Production.ProductModelProductDescriptionCulture.CultureID = Production.Culture.CultureID Name: FK_ProductModelProductDescriptionCulture_Culture_CultureID Foreign key constraint referencing Culture.CultureID.
Production.ProductModelProductDescriptionCulture		Production.ProductDescription	Production.ProductModelProductDescriptionCulture.ProductDescriptionID = Production.ProductDescription.ProductDescriptionID	FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Foreign key constraint referencing ProductDescription.ProductDescriptionID.
Production.ProductModelProductDescriptionCulture.ProductDescriptionID = Production.ProductDescription.ProductDescriptionID Name: FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Foreign key constraint referencing ProductDescription.ProductDescriptionID.
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.
Production.ProductModelIllustration		Production.ProductModelProductDescriptionCulture	Production.ProductModelIllustration.ModifiedDate = Production.ProductModelProductDescriptionCulture.ProductDescriptionID	fk_ProductModelProductDescriptionCulture_ProductModelIllustration
Production.ProductModelIllustration.ModifiedDate = Production.ProductModelProductDescriptionCulture.ProductDescriptionID Name: fk_ProductModelProductDescriptionCulture_ProductModelIllustration

Unique keys

	Key name	Columns	Description
	PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	ProductModelID, ProductDescriptionID, CultureID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Production.ProductModelProductDescriptionCulture
Production.Culture
Production.ProductDescription
Production.ProductModel

Used by

Name
Production.ProductModelProductDescriptionCulture
Production.vProductAndDescription
Production.ProductModelIllustration

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