Databases > AdventureWorks2019 > Tables > Production.ProductDocument

AdventureWorks2019

Production.ProductDocument

//
Cross-reference table mapping products to related product documents.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    ProductID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    DocumentNode
    [hierarchyid] NOT NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_ProductDocument_ProductID_DocumentNode
    UNIQUE CLUSTERED
    ProductID , DocumentNode

Foreign Keys

  • //
    Foreign key constraint referencing Document.DocumentNode.
    FK_ProductDocument_Document_DocumentNode
    Production.Document
    DocumentNode ⥱ DocumentNode
  • //
    Foreign key constraint referencing Product.ProductID.
    FK_ProductDocument_Product_ProductID
    Production.Product
    ProductID ⥱ ProductID

Sample Data

ProductID
DocumentNode
ModifiedDate
317
[hierarchyid]
318
[hierarchyid]
319
[hierarchyid]
506
[hierarchyid]
506
[hierarchyid]
514
[hierarchyid]
515
[hierarchyid]
516
[hierarchyid]
517
[hierarchyid]
518
[hierarchyid]
519
[hierarchyid]
520
[hierarchyid]
521
[hierarchyid]
522
[hierarchyid]
928
[hierarchyid]
929
[hierarchyid]
930
[hierarchyid]
931
[hierarchyid]
932
[hierarchyid]
933
[hierarchyid]
934
[hierarchyid]
935
[hierarchyid]
936
[hierarchyid]
937
[hierarchyid]
938
[hierarchyid]