AdventureWorks
| Table Name: | Production.ProductModelProductDescriptionCulture |
| Description: | Cross-reference table mapping product descriptions and the language the description is written in. |
| Primary Keys: | ProductModelID ProductDescriptionID CultureID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductModelID | int | None | No | Primary key. Foreign key to ProductModel.ProductModelID. |
| ProductDescriptionID | int | None | No | Primary key. Foreign key to ProductDescription.ProductDescriptionID. |
| CultureID | nchar (6) | None | No | Culture identification number. Foreign key to Culture.CultureID. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | Yes | Yes | ProductModelID ProductDescriptionID CultureID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductModelProductDescriptionCulture_Culture_CultureID | CultureID | Production.Culture |
| FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID | ProductDescriptionID | Production.ProductDescription |
| FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID | ProductModelID | Production.ProductModel |