Production.Illustration (table)

wikibot

Table	Production.Illustration
Description	Bicycle assembly diagrams.

Columns

Column	Data Type	Nullable	Default	Description
IllustrationID	int	not null		Primary key for Illustration records.
Diagram	xml	null		Illustrations used in manufacturing instructions. Stored as XML.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_Illustration_IllustrationID	IllustrationID

Detail Tables

Detail Table	Column	Referencing Column
Production.ProductModelIllustration	IllustrationID	IllustrationID

automatically generated

Table	Production.Illustration
Description	Bicycle assembly diagrams.

Column	Data Type	Nullable	Default	Description / PK / Index
IllustrationID	int	not null		Primary key for Illustration records. PK_Illustration_IllustrationID
Diagram	XML	null		Illustrations used in manufacturing instructions. Stored as XML.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.ProductModelIllustration	IllustrationID	IllustrationID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production