Production.ProductDocument (table)

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