Production.ProductPhoto (table)

wikibot

Table

Production.ProductPhoto

Column	Data Type	Nullable	Default	PK	Index
ProductPhotoID	int	not null		PK_ProductPhoto_ProductPhotoID
ThumbNailPhoto	varbinary(max)	null
ThumbnailPhotoFileName	nvarchar(50)	null
LargePhoto	varbinary(max)	null
LargePhotoFileName	nvarchar(50)	null
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Production.ProductProductPhoto	ProductPhotoID	ProductPhotoID

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