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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductModelIllustration |- |} {| border="1" cellpadding="5" cell...)
 
 
(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.ProductModelIllustration
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping product models and illustrations.
 +
|}
 +
 +
=== 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"
 +
| IllustrationID
 +
| int
 +
| not null
 +
|
 +
| Primary key. Foreign key to Illustration.IllustrationID.
 +
|- 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_ProductModelIllustration_ProductModelID_IllustrationID
 +
| ProductModelID, IllustrationID
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Production.Illustration_(table)|Production.Illustration]]
 +
| IllustrationID
 +
| IllustrationID
 +
|- 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]]
 +
 +
|}
 +
 +
 +
== 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 87:
 
| '''Table
 
| '''Table
 
| Production.ProductModelIllustration
 
| Production.ProductModelIllustration
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping product models and illustrations.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 100:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| ProductModelID
 
| ProductModelID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelIllustration_ProductModelID_IllustrationID
+
| Primary key. Foreign key to ProductModel.ProductModelID.<br />PK_ProductModelIllustration_ProductModelID_IllustrationID
−
|
+
|- valign="top"
−
|-
 
 
| IllustrationID
 
| IllustrationID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductModelIllustration_ProductModelID_IllustrationID
+
| Primary key. Foreign key to Illustration.IllustrationID.<br />PK_ProductModelIllustration_ProductModelID_IllustrationID
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 57: Line 138:
 
| 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]]
 +
 
|}
 
|}

Latest revision as of 00:16, 24 June 2010

wikibot[edit]

Table Production.ProductModelIllustration
Description Cross-reference table mapping product models and illustrations.

Columns[edit]

Column Data Type Nullable Default Description
ProductModelID int not null Primary key. Foreign key to ProductModel.ProductModelID.
IllustrationID int not null Primary key. Foreign key to Illustration.IllustrationID.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ProductModelIllustration_ProductModelID_IllustrationID ProductModelID, IllustrationID

Foreign Keys[edit]

Relation Column Referenced Column
Production.Illustration IllustrationID IllustrationID
Production.ProductModel ProductModelID ProductModelID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

Table Production.ProductModelIllustration
Description Cross-reference table mapping product models and illustrations.


Column Data Type Nullable Default Description / PK / Index
ProductModelID int not null Primary key. Foreign key to ProductModel.ProductModelID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
IllustrationID int not null Primary key. Foreign key to Illustration.IllustrationID.
PK_ProductModelIllustration_ProductModelID_IllustrationID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Illustration IllustrationID IllustrationID
Production.ProductModel ProductModelID ProductModelID


Dependency Type Object Type Referenced Object
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductModelIllustration_(table)&oldid=2636"