Production.ProductDocument (table)

From dbscript Online Help
Revision as of 01:13, 27 November 2009 by Bot (talk | contribs)
Jump to: navigation, search

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