Object type: Table

Bicycle assembly diagrams.

Columns 

Name	Data type	Nullable	Description
IllustrationID	int	No	Column has identity seed value of 1 with a step value of 1. Primary key for Illustration records.
Diagram	XML	Yes	Illustrations used in manufacturing instructions. Stored as XML.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_Illustration_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_Illustration_IllustrationID	PRIMARY KEY	IllustrationID	Clustered index created by a primary key constraint.

Triggers 

Name	Description
Production.uIllustration	AFTER UPDATE trigger setting the ModifiedDate column in the Illustration table to the current date.

Linked tables 

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

Modified by 

Name	Description
Production.uIllustration	AFTER UPDATE trigger setting the ModifiedDate column in the Illustration table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation