| Tables | SQL 2005 Adventure Works OLTP |
Product images.
Columns
Name Data type Nullable Description ProductPhotoID int No Column has identity seed value of 1 with a step value of 1.
Primary key for ProductPhoto records.ThumbNailPhoto varbinary(max) Yes Small image of the product. ThumbnailPhotoFileName nvarchar(50) Yes Small image file name. LargePhoto varbinary(max) Yes Large image of the product. LargePhotoFileName nvarchar(50) Yes Large image file name. ModifiedDate datetime No Default value: GETDATE()
Date and time the record was last updated.
Constraints
Name Type Columns Description DF_ProductPhoto_ModifiedDate DEFAULT ModifiedDate Value: GETDATE()
Default constraint value of GETDATE()PK_ProductPhoto_ProductPhotoID PRIMARY KEY ProductPhotoID Clustered index created by a primary key constraint.
Triggers
Name Description Production.uProductPhoto AFTER UPDATE trigger setting the ModifiedDate column in the ProductPhoto table to the current date.
Linked tables
Name Description Production.ProductProductPhoto Cross-reference table mapping products and product photos.
Accessed by
Name Description Product Catalog Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.
Modified by
Name Description Production.uProductPhoto AFTER UPDATE trigger setting the ModifiedDate column in the ProductPhoto table to the current date.
Applies to
Tables | User