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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductDocument |- |} {| border="1" cellpadding="5" cellspacing="...)
 
 
(10 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.ProductDocument
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping products to related product documents.
 +
|}
 +
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 +
|- valign="top"
 +
| ProductID
 +
| int
 +
| not null
 +
|
 +
| Product identification number. Foreign key to Product.ProductID.
 +
|- valign="top"
 +
| DocumentID
 +
| int
 +
| not null
 +
|
 +
| Document identification number. Foreign key to Document.DocumentID.
 +
|- 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_ProductDocument_ProductID_DocumentID
 +
| ProductID, DocumentID
 +
|}
 +
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|- valign="top"
 +
| [[Production.Document_(table)|Production.Document]]
 +
| DocumentID
 +
| DocumentID
 +
|- valign="top"
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductID
 +
| ProductID
 +
|}
 +
 +
=== 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.ProductDocument
 
| Production.ProductDocument
 +
|- valign="top"
 +
| '''Description
 +
| Cross-reference table mapping products to related product documents.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 100:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductDocument_ProductID_DocumentID
+
| Product identification number. Foreign key to Product.ProductID.<br />PK_ProductDocument_ProductID_DocumentID
−
|
+
|- valign="top"
−
|-
 
 
| DocumentID
 
| DocumentID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_ProductDocument_ProductID_DocumentID
+
| Document identification number. Foreign key to Document.DocumentID.<br />PK_ProductDocument_ProductID_DocumentID
−
|
+
|- 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:
 
| ProductID
 
| ProductID
 
| ProductID
 
| ProductID
 +
|}
 +
 +
 +
{| 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.ProductDocument
Description Cross-reference table mapping products to related product documents.

Columns[edit]

Column Data Type Nullable Default Description
ProductID int not null Product identification number. Foreign key to Product.ProductID.
DocumentID int not null Document identification number. Foreign key to Document.DocumentID.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ProductDocument_ProductID_DocumentID ProductID, DocumentID

Foreign Keys[edit]

Relation Column Referenced Column
Production.Document DocumentID DocumentID
Production.Product ProductID ProductID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

Table Production.ProductDocument
Description Cross-reference table mapping products to related product documents.


Column Data Type Nullable Default Description / PK / Index
ProductID int not null Product identification number. Foreign key to Product.ProductID.
PK_ProductDocument_ProductID_DocumentID
DocumentID int not null Document identification number. Foreign key to Document.DocumentID.
PK_ProductDocument_ProductID_DocumentID
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Relation Column Referenced Column
Production.Document DocumentID DocumentID
Production.Product ProductID ProductID


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