Production.ProductDocument (table)

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