ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
Production.ProductModelProductDescriptionCulture_(table)
Print
RSS
Modified: 2011/08/27 10:14 by
wikibot
-
Uncategorized
»
public.reportnxtid_(sequence)
»
Sales.SalesOrderHeader_(table)
»
Production.ProductModelProductDescriptionCulture_(table)
[X]
»
public.reportnxtid_(sequence)
»
Sales.SalesOrderHeader_(table)
»
Production.ProductModelProductDescriptionCulture_(table)
Edit
wikibot
Table
Production.ProductModelProductDescriptionCulture
Description
Cross-reference table mapping product descriptions and the language the description is written in.
Edit
Columns
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.
Edit
Primary Key
Primary Key
Columns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductModelID, ProductDescriptionID, CultureID
Edit
Foreign Keys
Relation
Column
Referenced Column
Production.Culture
CultureID
CultureID
Production.ProductDescription
ProductDescriptionID
ProductDescriptionID
Production.ProductModel
ProductModelID
ProductModelID
Edit
References
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
Edit
Dependencies
Reference Type
Object Type
Referencing Object
Select
View
Production.vProductAndDescription
Edit
automatically generated
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
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.