Table: 'Production.Illustration'

3 fields. 20 bytes.

Bicycle assembly diagrams.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
IllustrationIDint identity int Not nullPrimary key for Illustration records. 
Diagramxml   NullIllustrations used in manufacturing instructions. Stored as XML. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Illustration'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Production.Illustration', 1 item

Index NameDescriptionClusteredUniqueFields
PK_Illustration_IllustrationIDClustered index created by a primary key constraint.YesYesIllustrationID

Triggers for table 'Production.Illustration', 1 item

uIllustrationAFTER UPDATE trigger setting the ModifiedDate column in the Illustration table to the current date.after Update Yes

Dependencies for table 'Production.Illustration', 1 item

Object NameTypeField Name