Production.ProductModelProductDescriptionCulture

Table: 'Production.ProductModelProductDescriptionCulture'

4 fields. 36 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductModelIDint   Not nullPrimary key. Foreign key to ProductModel.ProductModelID. 
ProductDescriptionIDint   Not nullPrimary key. Foreign key to ProductDescription.ProductDescriptionID. 
CultureIDnchar6  Not nullCulture identification number. Foreign key to Culture.CultureID. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductModelProductDescriptionCulture'

Primary Key NameField Names
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDProductModelID, ProductDescriptionID, CultureID

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

ForeignPrimaryKey Name
ProductModelProductDescriptionCulture.CultureIDCulture.CultureIDFK_ProductModelProductDescriptionCulture_Culture_CultureID
ProductModelProductDescriptionCulture.ProductDescriptionIDProductDescription.ProductDescriptionIDFK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
ProductModelProductDescriptionCulture.ProductModelIDProductModel.ProductModelIDFK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID

Indexes for table 'Production.ProductModelProductDescriptionCulture', 1 item

Index NameDescriptionClusteredUniqueFields
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDClustered index created by a primary key constraint.YesYesProductModelID, ProductDescriptionID, CultureID

Triggers for table 'Production.ProductModelProductDescriptionCulture', 1 item

NameDescriptionTypeEnabled
uProductModelProductDescriptionCultureAFTER 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 NameTypeField Name
Production.uProductModelProductDescriptionCulturetriggerN/A
Production.vProductAndDescriptionviewN/A