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="...)
 
Line 38: Line 38:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Production.Document_(table)|Production.Document]]
 +
| DocumentID
 +
| DocumentID
 +
|-
 +
| [[Production.Product_(table)|Production.Product]]
 +
| ProductID
 +
| ProductID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductDocument
 +
|-
 +
 +
| '''Description
 +
| Cross-reference table mapping products to related product documents.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

wikibot

Table Production.ProductDocument


Column Data Type Nullable Default PK Index
ProductID int not null PK_ProductDocument_ProductID_DocumentID
DocumentID int not null PK_ProductDocument_ProductID_DocumentID
ModifiedDate datetime not null (getdate())


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

automatically generated

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductDocument_(table)&oldid=1103"