AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductDocument
Description:Cross-reference table mapping products to related product documents.
Primary Keys:ProductID
DocumentID
FieldTypeDefaultsNulls?Comments
ProductIDintNoneNoProduct identification number. Foreign key to Product.ProductID.
DocumentIDintNoneNoDocument identification number. Foreign key to Document.DocumentID.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ProductDocument_ProductID_DocumentIDYesYesProductID
DocumentID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_ProductDocument_Document_DocumentIDDocumentIDProduction.Document
FK_ProductDocument_Product_ProductIDProductIDProduction.Product

No primary keys as foreign key constraints
No triggers