AdventureWorks

Basic Index   Expanded Index

Table Name:Production.Illustration
Description:Bicycle assembly diagrams.
Primary Keys:IllustrationID
FieldTypeDefaultsNulls?Comments
IllustrationIDint - IdentityNoneNoPrimary key for Illustration records.
DiagramxmlNoneYesIllustrations used in manufacturing instructions. Stored as XML.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Illustration_IllustrationIDYesYesIllustrationID

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductModelIllustration_Illustration_IllustrationIDProduction.ProductModelIllustrationIllustrationID

No triggers