Databases > AdventureWorks2019 > Tables > Production.ProductModelIllustration

AdventureWorks2019

Production.ProductModelIllustration

//
Cross-reference table mapping product models and illustrations.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    ProductModelID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    IllustrationID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_ProductModelIllustration_ProductModelID_IllustrationID
    UNIQUE CLUSTERED
    ProductModelID , IllustrationID

Foreign Keys

  • //
    Foreign key constraint referencing Illustration.IllustrationID.
    FK_ProductModelIllustration_Illustration_IllustrationID
    Production.Illustration
    IllustrationID ⥱ IllustrationID
  • //
    Foreign key constraint referencing ProductModel.ProductModelID.
    FK_ProductModelIllustration_ProductModel_ProductModelID
    Production.ProductModel
    ProductModelID ⥱ ProductModelID

Sample Data

ProductModelID
IllustrationID
ModifiedDate
7
3
10
3
47
4
47
5
48
4
48
5
67
6