Databases > AdventureWorks2019 > Tables > Production.ProductModelProductDescriptionCulture

AdventureWorks2019

Production.ProductModelProductDescriptionCulture

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

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    ProductModelID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    ProductDescriptionID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    CultureID
    [nchar](6) NOT NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
    UNIQUE CLUSTERED
    ProductModelID , ProductDescriptionID , CultureID

Foreign Keys

  • //
    Foreign key constraint referencing Culture.CultureID.
    FK_ProductModelProductDescriptionCulture_Culture_CultureID
    Production.Culture
    CultureID ⥱ CultureID
  • //
    Foreign key constraint referencing ProductDescription.ProductDescriptionID.
    FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
    Production.ProductDescription
    ProductDescriptionID ⥱ ProductDescriptionID
  • //
    Foreign key constraint referencing ProductModel.ProductModelID.
    FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID
    Production.ProductModel
    ProductModelID ⥱ ProductModelID

Sample Data

ProductModelID
ProductDescriptionID
CultureID
ModifiedDate
1
1199
en
1
1467
ar
1
1589
fr
1
1712
th
1
1838
he
1
1965
zh-cht
2
1210
en
2
1476
ar
2
1598
fr
2
1721
th
2
1847
he
2
1974
zh-cht
3
1195
en
3
1464
ar
3
1586
fr
3
1709
th
3
1835
he
3
1961
zh-cht
4
1194
en
4
1463
ar
4
1585
fr
4
1708
th
4
1834
he
4
1960
zh-cht
5
647
en