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

From dbscript Online Help
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ProductModelProductDescriptionCulture
 
| 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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
+
| Primary key. Foreign key to ProductModel.ProductModelID.
−
|
+
|- valign="top"
−
|-
 
 
| ProductDescriptionID
 
| ProductDescriptionID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
+
| Primary key. Foreign key to ProductDescription.ProductDescriptionID.
−
|
+
|- 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.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 61:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.Culture_(table)|Production.Culture]]
 
| [[Production.Culture_(table)|Production.Culture]]
 
| CultureID
 
| CultureID
 
| CultureID
 
| CultureID
−
|-
+
|- valign="top"
 
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 
| [[Production.ProductDescription_(table)|Production.ProductDescription]]
 
| ProductDescriptionID
 
| ProductDescriptionID
 
| ProductDescriptionID
 
| ProductDescriptionID
−
|-
+
|- valign="top"
 
| [[Production.ProductModel_(table)|Production.ProductModel]]
 
| [[Production.ProductModel_(table)|Production.ProductModel]]
 
| ProductModelID
 
| ProductModelID
 
| 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 ==
 
== automatically generated ==
  
Line 76: Line 112:
 
| Production.ProductModelProductDescriptionCulture
 
| Production.ProductModelProductDescriptionCulture
 
|- valign="top"
 
|- valign="top"
−
 
 
| '''Description
 
| '''Description
 
| Cross-reference table mapping product descriptions and the language the description is written in.
 
| Cross-reference table mapping product descriptions and the language the description is written in.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 143: Line 177:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
 
−
| '''Dependency Type
 
  
 
|-
 
|-
−
| [[.Production_(schema)|.Production]]
 
 
| Schema
 
| Schema
 
| Schema
 
| Schema
 +
| [[Production_(schema)|Production]]
 +
 
|}
 
|}
  
Line 156: Line 191:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
 
−
| '''Reference Type
 
  
 
|-
 
|-
 +
| Select
 +
| View
 
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
 
| [[Production.vProductAndDescription_(view)|Production.vProductAndDescription]]
−
| View
+
 
−
| Select
 
 
|}
 
|}

Latest revision as of 00:16, 24 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"