AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductPhoto
Description:Product images.
Primary Keys:ProductPhotoID
FieldTypeDefaultsNulls?Comments
ProductPhotoIDint - IdentityNoneNoPrimary key for ProductPhoto records.
ThumbNailPhotovarbinary (MAX)NoneYesSmall image of the product.
ThumbnailPhotoFileNamenvarchar (50)NoneYesSmall image file name.
LargePhotovarbinary (MAX)NoneYesLarge image of the product.
LargePhotoFileNamenvarchar (50)NoneYesLarge image file name.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ProductPhoto_ProductPhotoIDYesYesProductPhotoID

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductProductPhoto_ProductPhoto_ProductPhotoIDProduction.ProductProductPhotoProductPhotoID

No triggers