ScrewTurn Wiki

Edit

wikibot

TableProduction.ProductModelProductDescriptionCulture
DescriptionCross-reference table mapping product descriptions and the language the description is written in.

Edit

Columns

ColumnData TypeNullableDefaultDescription
ProductModelIDintnot null Primary key. Foreign key to ProductModel.ProductModelID.
ProductDescriptionIDintnot null Primary key. Foreign key to ProductDescription.ProductDescriptionID.
CultureIDnchar(6)not null Culture identification number. Foreign key to Culture.CultureID.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDProductModelID, ProductDescriptionID, CultureID

Edit

Foreign Keys

RelationColumnReferenced Column
Production.CultureCultureIDCultureID
Production.ProductDescriptionProductDescriptionIDProductDescriptionID
Production.ProductModelProductModelIDProductModelID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Edit

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewProduction.vProductAndDescription

Edit

automatically generated

TableProduction.ProductModelProductDescriptionCulture
DescriptionCross-reference table mapping product descriptions and the language the description is written in.

ColumnData TypeNullableDefaultDescription / PK / Index
ProductModelIDintnot null Primary key. Foreign key to ProductModel.ProductModelID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductDescriptionIDintnot null Primary key. Foreign key to ProductDescription.ProductDescriptionID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
CultureIDnchar(6)not null Culture identification number. Foreign key to Culture.CultureID.
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



RelationColumnReferenced Column
Production.CultureCultureIDCultureID
Production.ProductDescriptionProductDescriptionIDProductDescriptionID
Production.ProductModelProductModelIDProductModelID

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Reference TypeObject TypeReferencing Object
SelectViewProduction.vProductAndDescription

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.