Production.ProductModelIllustration - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	ProductModelIllustration
Module	Products

Cross-reference table mapping product models and illustrations.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		ProductModelID	int			Production.ProductModel	Primary key. Foreign key to ProductModel.ProductModelID.
Primary key. Foreign key to ProductModel.ProductModelID. References: Production.ProductModel
	2		IllustrationID	int			Production.Illustration	Primary key. Foreign key to Illustration.IllustrationID.
Primary key. Foreign key to Illustration.IllustrationID. References: Production.Illustration
	3		ModifiedDate	datetime		Default: getdate()	Production.ProductModelProductDescriptionCulture	Date and time the record was last updated.
Date and time the record was last updated. Default: getdate() References: Production.ProductModelProductDescriptionCulture

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductModelIllustration		Production.Illustration	Production.ProductModelIllustration.IllustrationID = Production.Illustration.IllustrationID	FK_ProductModelIllustration_Illustration_IllustrationID Foreign key constraint referencing Illustration.IllustrationID.
Production.ProductModelIllustration.IllustrationID = Production.Illustration.IllustrationID Name: FK_ProductModelIllustration_Illustration_IllustrationID Foreign key constraint referencing Illustration.IllustrationID.
Production.ProductModelIllustration		Production.ProductModel	Production.ProductModelIllustration.ProductModelID = Production.ProductModel.ProductModelID	FK_ProductModelIllustration_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelIllustration.ProductModelID = Production.ProductModel.ProductModelID Name: FK_ProductModelIllustration_ProductModel_ProductModelID Foreign key constraint referencing ProductModel.ProductModelID.
Production.ProductModelIllustration		Production.ProductModelProductDescriptionCulture	Production.ProductModelIllustration.ModifiedDate = Production.ProductModelProductDescriptionCulture.ProductDescriptionID	fk_ProductModelProductDescriptionCulture_ProductModelIllustration
Production.ProductModelIllustration.ModifiedDate = Production.ProductModelProductDescriptionCulture.ProductDescriptionID Name: fk_ProductModelProductDescriptionCulture_ProductModelIllustration
Production.ProductCategory		Production.ProductModelIllustration	Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Production.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID	fk_ProductModelIllustration_ProductCategory
Production.ProductCategory.Name = Production.ProductModelIllustration.ProductModelID Production.ProductCategory.Name = Production.ProductModelIllustration.IllustrationID Name: fk_ProductModelIllustration_ProductCategory

Unique keys

	Key name	Columns	Description
	PK_ProductModelIllustration_ProductModelID_IllustrationID	ProductModelID, IllustrationID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Production.ProductModelIllustration
Production.Illustration
Production.ProductModel
Production.ProductModelProductDescriptionCulture

Used by

Name
Production.ProductModelIllustration
Production.ProductCategory

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56