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

From dbscript Online Help
Jump to: navigation, search
 
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
Line 8: Line 8:
 
| '''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.
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
 
|- valign="top"
 
|- valign="top"
 
| ProductModelID
 
| ProductModelID
Line 52: Line 50:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
 
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
 
| ProductModelID, ProductDescriptionID, CultureID
 
| ProductModelID, ProductDescriptionID, CultureID
Line 63: 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
Line 85: Line 83:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Schema
 
| Schema
 
| Schema
 
| Schema
Line 99: Line 97:
 
| '''Referencing Object
 
| '''Referencing Object
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View

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