ProductModelIllustration Table (AdventureWorks)

Is a cross-reference table that maps product models and illustrations. The illustrations are referenced in the Instructions column in the ProductModel table.

ProductModelIllustration Table Definition

The ProductModelIllustration table is contained in the Production schema.

Column

Data type

Nullability

Description

ProductModelID

int

Not null

Primary key. Foreign key to ProductModel.ProductModelID.

IllustrationID

int

Not null

Primary key. Foreign key to Illustration.IllustrationID.

ModifiedDate

datetime

Not null

Date and time the record was last updated.