Production.ProductModelProductDescriptionCulture (table)

wikibot

Table	Production.ProductModelProductDescriptionCulture
Description	Cross-reference table mapping product descriptions and the language the description is written in.

Columns

Column	Data Type	Nullable	Default	Description
ProductModelID	int	not null		Primary key. Foreign key to ProductModel.ProductModelID.
ProductDescriptionID	int	not null		Primary key. Foreign key to ProductDescription.ProductDescriptionID.
CultureID	nchar(6)	not null		Culture identification number. Foreign key to Culture.CultureID.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	ProductModelID, ProductDescriptionID, CultureID

Foreign Keys

Relation	Column	Referenced Column
Production.Culture	CultureID	CultureID
Production.ProductDescription	ProductDescriptionID	ProductDescriptionID
Production.ProductModel	ProductModelID	ProductModelID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	Production.vProductAndDescription

automatically generated

Table	Production.ProductModelProductDescriptionCulture
Description	Cross-reference table mapping product descriptions and the language the description is written in.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductModelID	int	not null		Primary key. Foreign key to ProductModel.ProductModelID. PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductDescriptionID	int	not null		Primary key. Foreign key to ProductDescription.ProductDescriptionID. PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
CultureID	nchar(6)	not null		Culture identification number. Foreign key to Culture.CultureID. PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Culture	CultureID	CultureID
Production.ProductDescription	ProductDescriptionID	ProductDescriptionID
Production.ProductModel	ProductModelID	ProductModelID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

Reference Type	Object Type	Referencing Object
Select	View	Production.vProductAndDescription