Production.ProductDocument - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductDocument
Module	Products

Cross-reference table mapping products to related product documents.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductID	int			Production.Product	Product identification number. Foreign key to Product.ProductID.
Product identification number. Foreign key to Product.ProductID. References: Production.Product
	2		DocumentNode	hierarchyid			Production.Document	Document identification number. Foreign key to Document.DocumentNode.
Document identification number. Foreign key to Document.DocumentNode. References: Production.Document
	3		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductDocument		Production.Document	Production.ProductDocument.DocumentNode = Production.Document.DocumentNode	FK_ProductDocument_Document_DocumentNode Foreign key constraint referencing Document.DocumentNode.
Production.ProductDocument.DocumentNode = Production.Document.DocumentNode Name: FK_ProductDocument_Document_DocumentNode Foreign key constraint referencing Document.DocumentNode.
Production.ProductDocument		Production.Product	Production.ProductDocument.ProductID = Production.Product.ProductID	FK_ProductDocument_Product_ProductID Foreign key constraint referencing Product.ProductID.
Production.ProductDocument.ProductID = Production.Product.ProductID Name: FK_ProductDocument_Product_ProductID Foreign key constraint referencing Product.ProductID.

Unique keys

	Key name	Columns	Description
	PK_ProductDocument_ProductID_DocumentNode	ProductID, DocumentNode	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Production.ProductDocument
Production.Document
Production.Product

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56