Production.ProductModelProductDescriptionCulture Table

Information

Name	ProductModelProductDescriptionCulture
Schema	Production
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
ProductModelProductDescriptionCulture	TABLE	MS_Description	Cross-reference table mapping product descriptions and the language the description is written in.

Columns

Name	Data Type	Collation	References	Default
ProductModelID	int		Production.ProductModel.ProductModelID
ProductDescriptionID	int		Production.ProductDescription.ProductDescriptionID
CultureID	nchar(6)	SQL_Latin1_General_CP1_CI_AS	Production.Culture.CultureID
ModifiedDate	datetime			(getdate())

Indexes

Name	Type	Primary	Unique	Columns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	Clustered			ProductModelID, ProductDescriptionID, CultureID

Foreign Key Constraints

Name	Type	Referenced Table
FK_ProductModelProductDescriptionCulture_Culture_CultureID	Foreign key	Production.Culture
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	Foreign key	Production.ProductDescription
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID	Foreign key	Production.ProductModel

SQL Script

CREATE TABLE [Production].[ProductModelProductDescriptionCulture] (
    [ProductModelID] int NOT NULL,
    [ProductDescriptionID] int NOT NULL,
    [CultureID] nchar(6) NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);