Production.ProductModelProductDescriptionCulture

Table: 'Production.ProductModelProductDescriptionCulture'

4 fields. 36 bytes.

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

Field Name Data Type Size Original Type Default Nullable Description Check

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 getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Default	Nullable	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		getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductModelProductDescriptionCulture'

Primary Key Name Field Names

PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID ProductModelID, ProductDescriptionID, CultureID

Primary Key Name	Field Names
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	ProductModelID, ProductDescriptionID, CultureID

Foreign keys for table 'Production.ProductModelProductDescriptionCulture', 3 items

Foreign Primary Key Name

ProductModelProductDescriptionCulture.CultureID Culture.CultureID FK_ProductModelProductDescriptionCulture_Culture_CultureID

ProductModelProductDescriptionCulture.ProductDescriptionID ProductDescription.ProductDescriptionID FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID

ProductModelProductDescriptionCulture.ProductModelID ProductModel.ProductModelID FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID

Foreign	Primary	Key Name
ProductModelProductDescriptionCulture.CultureID	Culture.CultureID	FK_ProductModelProductDescriptionCulture_Culture_CultureID
ProductModelProductDescriptionCulture.ProductDescriptionID	ProductDescription.ProductDescriptionID	FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
ProductModelProductDescriptionCulture.ProductModelID	ProductModel.ProductModelID	FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID

Indexes for table 'Production.ProductModelProductDescriptionCulture', 1 item

Index Name Description Clustered Unique Fields

PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID Clustered index created by a primary key constraint. Yes Yes ProductModelID, ProductDescriptionID, CultureID

Index Name	Description	Clustered	Unique	Fields
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	Clustered index created by a primary key constraint.	Yes	Yes	ProductModelID, ProductDescriptionID, CultureID

Triggers for table 'Production.ProductModelProductDescriptionCulture', 1 item

Name Description Type Enabled

uProductModelProductDescriptionCulture AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelProductDescriptionCulture table to the current date. after Update Yes

Name	Description	Type	Enabled
uProductModelProductDescriptionCulture	AFTER UPDATE trigger setting the ModifiedDate column in the ProductModelProductDescriptionCulture table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductModelProductDescriptionCulture', 2 items

Object Name Type Field Name

Production.uProductModelProductDescriptionCulture trigger N/A

Production.vProductAndDescription view N/A

Object Name	Type	Field Name
Production.uProductModelProductDescriptionCulture	trigger	N/A
Production.vProductAndDescription	view	N/A