Production.ProductModelProductDescriptionCulture (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table Production.ProductModelProductDescriptionCulture
Description Cross-reference table mapping product descriptions and the language the description is written in.

Columns[edit]

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

Primary Key[edit]

Primary Key Columns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID ProductModelID, ProductDescriptionID, CultureID

Foreign Keys[edit]

Relation Column Referenced Column
Production.Culture CultureID CultureID
Production.ProductDescription ProductDescriptionID ProductDescriptionID
Production.ProductModel ProductModelID ProductModelID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production

Dependencies[edit]

Reference Type Object Type Referencing Object
Select View Production.vProductAndDescription


automatically generated[edit]

Table Production.ProductModelProductDescriptionCulture
Description Cross-reference table mapping product descriptions and the language the description is written in.


Column Data Type Nullable Default Description / PK / Index
ProductModelID int not null Primary key. Foreign key to ProductModel.ProductModelID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductDescriptionID int not null Primary key. Foreign key to ProductDescription.ProductDescriptionID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
CultureID nchar(6) not null Culture identification number. Foreign key to Culture.CultureID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Culture CultureID CultureID
Production.ProductDescription ProductDescriptionID ProductDescriptionID
Production.ProductModel ProductModelID ProductModelID


Dependency Type Object Type Referenced Object
Schema Schema Production


Reference Type Object Type Referencing Object
Select View Production.vProductAndDescription