AdventureWorks2019
Production.ProductDocument
//
Cross-reference table mapping products to related product documents.
Created: Modified:
Columns
-
//${escapify(column.description)}[int] NOT NULL
-
//${escapify(column.description)}[hierarchyid] NOT NULL
-
//${escapify(column.description)}[datetime] NOT NULL DEFAULT (getdate())
Indexes
-
//Clustered index created by a primary key constraint.PK_ProductDocument_ProductID_DocumentNodeUNIQUE CLUSTEREDProductID , DocumentNode
Foreign Keys
-
//Foreign key constraint referencing Document.DocumentNode.FK_ProductDocument_Document_DocumentNodeProduction.DocumentDocumentNode ⥱ DocumentNode
-
//Foreign key constraint referencing Product.ProductID.FK_ProductDocument_Product_ProductIDProduction.ProductProductID ⥱ 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]