Production.ProductDocument (table)

From dbscript Online Help
Revision as of 22:54, 28 December 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

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


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


Dependency Type Object Type Referenced Object
Schema Schema Production