Table: 'Production.ProductPhoto'

6 fields. 220 bytes.

Product images.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductPhotoIDint identity int Not nullPrimary key for ProductPhoto records. 
ThumbNailPhotovarbinary   NullSmall image of the product. 
ThumbnailPhotoFileNamenvarchar50  NullSmall image file name. 
LargePhotovarbinary   NullLarge image of the product. 
LargePhotoFileNamenvarchar50  NullLarge image file name. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductPhoto'

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

Indexes for table 'Production.ProductPhoto', 1 item

Index NameDescriptionClusteredUniqueFields
PK_ProductPhoto_ProductPhotoIDClustered index created by a primary key constraint.YesYesProductPhotoID

Triggers for table 'Production.ProductPhoto', 1 item

uProductPhotoAFTER UPDATE trigger setting the ModifiedDate column in the ProductPhoto table to the current date.after Update Yes

Dependencies for table 'Production.ProductPhoto', 1 item

Object NameTypeField Name