AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductModelProductDescriptionCulture
Description:Cross-reference table mapping product descriptions and the language the description is written in.
Primary Keys:ProductModelID
ProductDescriptionID
CultureID
FieldTypeDefaultsNulls?Comments
ProductModelIDintNoneNoPrimary key. Foreign key to ProductModel.ProductModelID.
ProductDescriptionIDintNoneNoPrimary key. Foreign key to ProductDescription.ProductDescriptionID.
CultureIDnchar (6)NoneNoCulture identification number. Foreign key to Culture.CultureID.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDYesYesProductModelID
ProductDescriptionID
CultureID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_ProductModelProductDescriptionCulture_Culture_CultureIDCultureIDProduction.Culture
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDProductDescriptionIDProduction.ProductDescription
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelIDProductModelIDProduction.ProductModel

No primary keys as foreign key constraints
No triggers