Production.ProductModelProductDescriptionCulture Table

Description

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

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	762
Data Space Used	32.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length	Default
ProductModelID	Primary key. Foreign key to ProductModel.ProductModelID.	Integer	4
ProductDescriptionID	Primary key. Foreign key to ProductDescription.ProductDescriptionID.	Integer	4
CultureID	Culture identification number. Foreign key to Culture.CultureID.	WChar	6
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_ProductModelProductDescriptionCulture_Culture_CultureID	Foreign key constraint referencing Culture.CultureID.
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	Foreign key constraint referencing ProductDescription.ProductDescriptionID.
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID	Foreign key constraint referencing ProductModel.ProductModelID.

Objects that depend on Production.ProductModelProductDescriptionCulture

	Database Object	Object Type	Description	Dep Level
	Production.vProductAndDescription	View	Product names and descriptions. Product descriptions are provided in multiple languages.	1

Objects that Production.ProductModelProductDescriptionCulture depends on

Database Object	Object Type	Description	Dep Level
Production.Culture	Table	Lookup table containing the languages in which some AdventureWorks data is stored.	1
dbo.Name	User Defined Data Type		2
Production.ProductDescription	Table	Product descriptions in several languages.	1
Production.ProductModel	Table	Product model classification.	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[ProductModelProductDescriptionCulture](
    [ProductModelID] [int] NOT NULL,
    [ProductDescriptionID] [int] NOT NULL,
    [CultureID] [nchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID] PRIMARY KEY CLUSTERED 
(
    [ProductModelID] ASC,
    [ProductDescriptionID] ASC,
    [CultureID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Production].[ProductModelProductDescriptionCulture] ADD  CONSTRAINT [DF_ProductModelProductDescriptionCulture_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID] FOREIGN KEY([CultureID])
REFERENCES [Production].[Culture] ([CultureID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_Culture_CultureID]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID] FOREIGN KEY([ProductDescriptionID])
REFERENCES [Production].[ProductDescription] ([ProductDescriptionID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID]
ALTER TABLE [Production].[ProductModelProductDescriptionCulture]  WITH CHECK ADD  CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID] FOREIGN KEY([ProductModelID])
REFERENCES [Production].[ProductModel] ([ProductModelID])
ALTER TABLE [Production].[ProductModelProductDescriptionCulture] CHECK CONSTRAINT [FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID]

Related Objects