Databases
>
AdventureWorks2019
>
Tables
> Production.ProductModelIllustration
AdventureWorks2019
Production.ProductModelIllustration
//
Cross-reference table mapping product models and illustrations.
Created:
5/8/2023
Modified:
5/8/2023
Save
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
1/9/2014
10
3
1/9/2014
47
4
1/9/2014
47
5
1/9/2014
48
4
1/9/2014
48
5
1/9/2014
67
6
1/9/2014