AdventureWorks2019
Production.ProductModelProductDescriptionCulture
//
Cross-reference table mapping product descriptions and the language the description is written in.
Created: Modified:
Columns
-
//${escapify(column.description)}[int] NOT NULL
-
//${escapify(column.description)}[int] NOT NULL
-
//${escapify(column.description)}[nchar](6) NOT NULL
-
//${escapify(column.description)}[datetime] NOT NULL DEFAULT (getdate())
Indexes
-
//Clustered index created by a primary key constraint.PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDUNIQUE CLUSTEREDProductModelID , ProductDescriptionID , CultureID
Foreign Keys
-
//Foreign key constraint referencing Culture.CultureID.FK_ProductModelProductDescriptionCulture_Culture_CultureIDProduction.CultureCultureID ⥱ CultureID
-
//Foreign key constraint referencing ProductDescription.ProductDescriptionID.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDProduction.ProductDescriptionProductDescriptionID ⥱ ProductDescriptionID
-
//Foreign key constraint referencing ProductModel.ProductModelID.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelIDProduction.ProductModelProductModelID ⥱ 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