AdventureWorks
| Table Name: | Production.ProductModelIllustration |
| Description: | Cross-reference table mapping product models and illustrations. |
| Primary Keys: | ProductModelID IllustrationID |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| ProductModelID | int | None | No | Primary key. Foreign key to ProductModel.ProductModelID. |
| IllustrationID | int | None | No | Primary key. Foreign key to Illustration.IllustrationID. |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_ProductModelIllustration_ProductModelID_IllustrationID | Yes | Yes | ProductModelID IllustrationID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_ProductModelIllustration_Illustration_IllustrationID | IllustrationID | Production.Illustration |
| FK_ProductModelIllustration_ProductModel_ProductModelID | ProductModelID | Production.ProductModel |