Production.Illustration - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	Illustration
Module	Products

Bicycle assembly diagrams.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		IllustrationID	int		Identity		Primary key for Illustration records.
Primary key for Illustration records. Identity
	2		Diagram	xml				Illustrations used in manufacturing instructions. Stored as XML.
Illustrations used in manufacturing instructions. Stored as XML.
	3		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductDescription		Production.Illustration	Production.ProductDescription.rowguid = Production.Illustration.IllustrationID	fk_Illustration_ProductDescription
Production.ProductDescription.rowguid = Production.Illustration.IllustrationID Name: fk_Illustration_ProductDescription
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.

Unique keys

	Key name	Columns	Description
	PK_Illustration_IllustrationID	IllustrationID	Primary key (clustered) constraint
Primary key (clustered) constraint

Used by

Name
Production.Illustration
Production.ProductDescription
Production.ProductModelIllustration

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