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

From dbscript Online Help
Jump to: navigation, search
 
(2 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.ProductDocument
 
| 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"
 
{| 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"
|-
 
 
| ProductID
 
| ProductID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_ProductDocument_ProductID_DocumentID
+
| Product identification number. Foreign key to Product.ProductID.
|
+
|- valign="top"
|-
 
 
| DocumentID
 
| DocumentID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
| PK_ProductDocument_ProductID_DocumentID
+
| Document identification number. Foreign key to Document.DocumentID.
|
+
|- 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_ProductDocument_ProductID_DocumentID
 +
| ProductID, DocumentID
 +
|}
  
 
+
=== 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 48: Line 55:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[Production.Document_(table)|Production.Document]]
 
| [[Production.Document_(table)|Production.Document]]
 
| DocumentID
 
| DocumentID
 
| DocumentID
 
| DocumentID
|-
+
|- valign="top"
 
| [[Production.Product_(table)|Production.Product]]
 
| [[Production.Product_(table)|Production.Product]]
 
| ProductID
 
| ProductID
 
| 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 ==
 
== automatically generated ==
  

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