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

From dbscript Online Help
Jump to: navigation, search
 
(10 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.Illustration
 
| Production.Illustration
|-
+
|- valign="top"
 +
| '''Description
 +
| Bicycle assembly diagrams.
 
|}
 
|}
  
 
+
=== 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"
|-
 
 
| IllustrationID
 
| IllustrationID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_Illustration_IllustrationID
+
| Primary key for Illustration records.
|
+
|- valign="top"
|-
 
 
| Diagram
 
| Diagram
 
| xml
 
| xml
 
| null
 
| null
 
|  
 
|  
|  
+
| Illustrations used in manufacturing instructions. Stored as XML.
|
+
|- 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_Illustration_IllustrationID
 +
| IllustrationID
 +
|}
  
 
+
=== Detail Tables ===
 
{| 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 48: Line 55:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
+
 
|-
+
|- valign="top"
 
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 
| [[Production.ProductModelIllustration_(table)|Production.ProductModelIllustration]]
 
| IllustrationID
 
| IllustrationID
 
| IllustrationID
 
| IllustrationID
 
|}
 
|}
 +
 +
=== 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 ==
 
== automatically generated ==
  
Line 60: Line 83:
 
| '''Table
 
| '''Table
 
| Production.Illustration
 
| Production.Illustration
|-
+
|- valign="top"
 
 
 
| '''Description
 
| '''Description
 
| Bicycle assembly diagrams.
 
| Bicycle assembly diagrams.
 
|-
 
|-
 
 
|}
 
|}
  
Line 82: Line 103:
 
| not null
 
| not null
 
|  
 
|  
| Primary key for Illustration records.PK_Illustration_IllustrationID
+
| Primary key for Illustration records.<br />PK_Illustration_IllustrationID
 
|- valign="top"
 
|- valign="top"
 
| Diagram
 
| Diagram
Line 88: Line 109:
 
| null
 
| null
 
|  
 
|  
| Illustrations used in manufacturing instructions. Stored as XML.
+
| Illustrations used in manufacturing instructions. Stored as XML.<br />
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 94: Line 115:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 109: Line 130:
 
| IllustrationID
 
| IllustrationID
 
| IllustrationID
 
| IllustrationID
 +
|}
 +
 +
 +
{| 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 23:16, 23 June 2010

wikibot[edit]

Table Production.Illustration
Description Bicycle assembly diagrams.

Columns[edit]

Column Data Type Nullable Default Description
IllustrationID int not null Primary key for Illustration records.
Diagram xml null Illustrations used in manufacturing instructions. Stored as XML.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_Illustration_IllustrationID IllustrationID

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductModelIllustration IllustrationID IllustrationID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

Table Production.Illustration
Description Bicycle assembly diagrams.


Column Data Type Nullable Default Description / PK / Index
IllustrationID int not null Primary key for Illustration records.
PK_Illustration_IllustrationID
Diagram XML null Illustrations used in manufacturing instructions. Stored as XML.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.ProductModelIllustration IllustrationID IllustrationID


Dependency Type Object Type Referenced Object
Schema Schema Production