Object type: Table

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

Columns 

Name	Data type	Nullable	Description
ProductModelID	int	No	Primary key. Foreign key to ProductModel.ProductModelID.
ProductDescriptionID	int	No	Primary key. Foreign key to ProductDescription.ProductDescriptionID.
CultureID	nchar(6)	No	Culture identification number. Foreign key to Culture.CultureID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_ProductModelProductDescriptionCulture_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	PRIMARY KEY	ProductModelID ProductDescriptionID CultureID	Clustered index created by a primary key constraint.
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	FOREIGN KEY	ProductDescriptionID	Reference table: Production.ProductDescription Foreign key constraint referencing ProductDescription.ProductDescriptionID.
FK_ProductModelProductDescriptionCulture_Culture_CultureID	FOREIGN KEY	CultureID	Reference table: Production.Culture Foreign key constraint referencing Culture.CultureID.
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID	FOREIGN KEY	ProductModelID	Reference table: Production.ProductModel Foreign key constraint referencing ProductModel.ProductModelID.

Triggers 

Name	Description
Production.uProductModelProductDescriptionCulture	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelProductDescriptionCulture table to the current date.

Accessed by 

Name	Description
Product Catalog	Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.
Production.vProductAndDescription	Product names and descriptions. Product descriptions are provided in multiple languages.

Modified by 

Name	Description
Production.uProductModelProductDescriptionCulture	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelProductDescriptionCulture table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation