Difference between revisions of "Production.ProductModelProductDescriptionCulture (table)"

From dbscript Online Help
Jump to: navigation, search
Line 45: Line 45:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
| CultureID
 +
| CultureID
 +
|-
 +
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 +
| ProductDescriptionID
 +
| ProductDescriptionID
 +
|-
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
| ProductModelID
 +
| ProductModelID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductModelProductDescriptionCulture
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping product descriptions and the language the description is written in.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:27, 27 November 2009

wikibot

Table Production.ProductModelProductDescriptionCulture


Column Data Type Nullable Default PK Index
ProductModelID int not null PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductDescriptionID int not null PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
CultureID nchar(6) not null PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ModifiedDate datetime not null (getdate())


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

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductModelProductDescriptionCulture_(table)&oldid=1108"