AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductModelIllustration
Description:Cross-reference table mapping product models and illustrations.
Primary Keys:ProductModelID
IllustrationID
FieldTypeDefaultsNulls?Comments
ProductModelIDintNoneNoPrimary key. Foreign key to ProductModel.ProductModelID.
IllustrationIDintNoneNoPrimary key. Foreign key to Illustration.IllustrationID.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ProductModelIllustration_ProductModelID_IllustrationIDYesYesProductModelID
IllustrationID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_ProductModelIllustration_Illustration_IllustrationIDIllustrationIDProduction.Illustration
FK_ProductModelIllustration_ProductModel_ProductModelIDProductModelIDProduction.ProductModel

No primary keys as foreign key constraints
No triggers