Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production ProductModelProductDescriptionCulture (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:04


wikibot

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

Reference TypeObject TypeReferencing Object
SelectViewProduction.vProductAndDescription

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