Databases > AdventureWorks2019 > Tables > Production.ProductPhoto

AdventureWorks2019

Production.ProductPhoto

Product images.

Created: 5/8/2023 Modified: 5/8/2023

Columns

//

${escapify(column.description)}

ProductPhotoID

[int] IDENTITY (1,1) NOT NULL
//

${escapify(column.description)}

ThumbNailPhoto

[varbinary](MAX) NULL
//

${escapify(column.description)}

ThumbnailPhotoFileName

[nvarchar](50) NULL
//

${escapify(column.description)}

LargePhoto

[varbinary](MAX) NULL
//

${escapify(column.description)}

LargePhotoFileName

[nvarchar](50) NULL
//

${escapify(column.description)}

ModifiedDate

[datetime] NOT NULL DEFAULT (getdate())

Indexes

//

Clustered index created by a primary key constraint.

PK_ProductPhoto_ProductPhotoID

UNIQUE CLUSTERED

ProductPhotoID

Sample Data

ProductPhotoID

ThumbNailPhoto

ThumbnailPhotoFileName

LargePhoto

LargePhotoFileName

ModifiedDate

[varbinary]

no_image_available_small.gif

[varbinary]

no_image_available_large.gif

4/29/2008

[varbinary]

racer02_black_f_small.gif

[varbinary]

racer02_black_f_large.gif

4/29/2008

[varbinary]

racer02_black_small.gif

[varbinary]

racer02_black_large.gif

10/19/2012

[varbinary]

racer02_blue_f_small.gif

[varbinary]

racer02_blue_f_large.gif

10/19/2012

[varbinary]

racer02_blue_small.gif

[varbinary]

racer02_blue_large.gif

10/19/2012

[varbinary]

racer02_green_f_small.gif

[varbinary]

racer02_green_f_large.gif

10/19/2012

[varbinary]

racer02_green_small.gif

[varbinary]

racer02_green_large.gif

10/19/2012

[varbinary]

hotrodbike_black_small.gif

[varbinary]

hotrodbike_black_large.gif

4/29/2012

[varbinary]

hotrodbike_blue_small.gif

[varbinary]

hotrodbike_blue_large.gif

10/19/2012

[varbinary]

hotrodbike_f_small.gif

[varbinary]

hotrodbike_f_large.gif

4/29/2013

[varbinary]

hotrodbike_f_silver_small.gif

[varbinary]

hotrodbike_f_silver_large.gif

4/29/2013

[varbinary]

hotrodbike_small.gif

[varbinary]

hotrodbike_large.gif

4/29/2013

[varbinary]

hotrodbike_red_small.gif

[varbinary]

hotrodbike_red_large.gif

10/19/2012

[varbinary]

hotrodbike_silver_small.gif

[varbinary]

hotrodbike_silver_large.gif

4/29/2012

[varbinary]

hotrodbike_yellow_small.gif

[varbinary]

hotrodbike_yellow_large.gif

10/19/2012

[varbinary]

julianax_r_02_black_small.gif

[varbinary]

julianax_r_02_black_large.gif

10/19/2012

[varbinary]

julianax_r_02_blue_small.gif

[varbinary]

julianax_r_02_blue_large.gif

10/19/2012

[varbinary]

julianax_r_02_f_black_small.gif

[varbinary]

julianax_r_02_f_black_large.gif

10/19/2012

[varbinary]

julianax_r_02_f_blue_small.gif

[varbinary]

julianax_r_02_f_blue_large.gif

10/19/2012

[varbinary]

julianax_r_02_f_gold_small.gif

[varbinary]

julianax_r_02_f_gold_large.gif

10/19/2012

[varbinary]

julianax_r_02_f_green_small.gif

[varbinary]

julianax_r_02_f_green_large.gif

10/19/2012

[varbinary]

julianax_r_02_f_red_small.gif

[varbinary]

julianax_r_02_f_red_large.gif

10/19/2012

[varbinary]

julianax_r_02_gold_small.gif

[varbinary]

julianax_r_02_gold_large.gif

10/19/2012

[varbinary]

julianax_r_02_green_small.gif

[varbinary]

julianax_r_02_green_large.gif

10/19/2012

[varbinary]

julianax_r_02_red_small.gif

[varbinary]

julianax_r_02_red_large.gif

10/19/2012