Production.ProductModelIllustration (table)

wikibot

Table

Production.ProductModelIllustration

Column	Data Type	Nullable	Default	PK	Index
ProductModelID	int	not null		PK_ProductModelIllustration_ProductModelID_IllustrationID
IllustrationID	int	not null		PK_ProductModelIllustration_ProductModelID_IllustrationID
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Production.Illustration	IllustrationID	IllustrationID
Production.ProductModel	ProductModelID	ProductModelID

automatically generated

Table	Production.ProductModelIllustration
Description	Cross-reference table mapping product models and illustrations.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductModelID	int	not null		Primary key. Foreign key to ProductModel.ProductModelID. PK_ProductModelIllustration_ProductModelID_IllustrationID
IllustrationID	int	not null		Primary key. Foreign key to Illustration.IllustrationID. PK_ProductModelIllustration_ProductModelID_IllustrationID
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Production.Illustration	IllustrationID	IllustrationID
Production.ProductModel	ProductModelID	ProductModelID