Production.ProductPhoto (table)

wikibot

Table	Production.ProductPhoto
Description	Product images.

Columns

Column	Data Type	Nullable	Default	Description
ProductPhotoID	int	not null		Primary key for ProductPhoto records.
ThumbNailPhoto	varbinary(max)	null		Small image of the product.
ThumbnailPhotoFileName	nvarchar(50)	null		Small image file name.
LargePhoto	varbinary(max)	null		Large image of the product.
LargePhotoFileName	nvarchar(50)	null		Large image file name.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_ProductPhoto_ProductPhotoID	ProductPhotoID

Detail Tables

Detail Table	Column	Referencing Column
Production.ProductProductPhoto	ProductPhotoID	ProductPhotoID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

automatically generated

Table	Production.ProductPhoto
Description	Product images.

Column	Data Type	Nullable	Default	Description / PK / Index
ProductPhotoID	int	not null		Primary key for ProductPhoto records. PK_ProductPhoto_ProductPhotoID
ThumbNailPhoto	varbinary(max)	null		Small image of the product.
ThumbnailPhotoFileName	nvarchar(50)	null		Small image file name.
LargePhoto	varbinary(max)	null		Large image of the product.
LargePhotoFileName	nvarchar(50)	null		Large image file name.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.ProductProductPhoto	ProductPhotoID	ProductPhotoID

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production