Object type: Table

Cross-reference table mapping products to related product documents.

Columns 

Name	Data type	Nullable	Description
ProductID	int	No	Product identification number. Foreign key to Product.ProductID.
DocumentID	int	No	Document identification number. Foreign key to Document.DocumentID.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_ProductDocument_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_ProductDocument_ProductID_DocumentID	PRIMARY KEY	ProductID DocumentID	Clustered index created by a primary key constraint.
FK_ProductDocument_Product_ProductID	FOREIGN KEY	ProductID	Reference table: Production.Product Foreign key constraint referencing Product.ProductID.
FK_ProductDocument_Document_DocumentID	FOREIGN KEY	DocumentID	Reference table: Production.Document Foreign key constraint referencing Document.DocumentID.

Triggers 

Name	Description
Production.uProductDocument	AFTER UPDATE trigger setting the ModifiedDate column in the ProductDocument table to the current date.

Modified by 

Name	Description
Production.uProductDocument	AFTER UPDATE trigger setting the ModifiedDate column in the ProductDocument table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation