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

Referenced Object	Object Type	Dependency Type
.Production	Schema	Schema