Production.ProductModelProductDescriptionCulture Table

Information

NameProductModelProductDescriptionCulture
SchemaProduction
Row Count762
Data Size32 KB
Index Size16 KB
Reserved Size48 KB
Unused Size0 KB
Created14.10.2005 1:58:34
Modified14.10.2005 1:59:59

Extended Properties

NameTypeProperty NameValue
ProductModelProductDescriptionCultureTABLEMS_DescriptionCross-reference table mapping product descriptions and the language the description is written in.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   ProductModelIDint  Production.ProductModel.ProductModelID
 
 
 
   ProductDescriptionIDint  Production.ProductDescription.ProductDescriptionID
 
 
 
   CultureIDnchar(12) SQL_Latin1_General_CP1_CI_ASProduction.Culture.CultureID
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDClustered  ProductModelID, ProductDescriptionID, CultureID

Foreign Key Constraints

NameTypeReferenced Table
FK_ProductModelProductDescriptionCulture_Culture_CultureIDForeign keyProduction.Culture
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDForeign keyProduction.ProductDescription
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelIDForeign keyProduction.ProductModel

Triggers

NameActivates onInstead OfFor ReplicationEnabledCreatedModified
Production.uProductModelProductDescriptionCultureUPDATE   14.10.2005 1:59:5414.10.2005 1:59:54