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

From dbscript Online Help
Jump to: navigation, search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Table
 +
| Production.ProductModelProductDescriptionCulture
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping product descriptions and the language the description is written in.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| ProductModelID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to ProductModel.ProductModelID.
 +
|- valign="top"
 +
| ProductDescriptionID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to ProductDescription.ProductDescriptionID.
 +
|- valign="top"
 +
| CultureID
 +
| nchar(6)
 +
| not null
 +
|
 +
| Culture identification number. Foreign key to Culture.CultureID.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (getdate())
 +
| Date and time the record was last updated.
 +
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
 +
| ProductModelID, ProductDescriptionID, CultureID
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Production.Culture_(table)|Production.Culture]]
 +
| CultureID
 +
| CultureID
 +
|- valign="top"
 +
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 +
| ProductDescriptionID
 +
| ProductDescriptionID
 +
|- valign="top"
 +
| [[Production.ProductModel_(table)|Production.ProductModel]]
 +
| ProductModelID
 +
| ProductModelID
 +
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 111:
 
| '''Table
 
| '''Table
 
| Production.ProductModelProductDescriptionCulture
 
| Production.ProductModelProductDescriptionCulture
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping product descriptions and the language the description is written in.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 124:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
+
| Primary key. Foreign key to ProductModel.ProductModelID.<br />PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
−
|
+
|- valign="top"
−
|-
 
 
| ProductDescriptionID
 
| ProductDescriptionID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
+
| Primary key. Foreign key to ProductDescription.ProductDescriptionID.<br />PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
−
|
+
|- valign="top"
−
|-
 
 
| CultureID
 
| CultureID
 
| nchar(6)
 
| nchar(6)
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
+
| Culture identification number. Foreign key to Culture.CultureID.<br />PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 68: Line 172:
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 
| ProductModelID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 +
 
|}
 
|}

Latest revision as of 23:16, 23 June 2010

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