Production.ProductPhoto (table)

From dbscript Online Help
Jump to: navigation, search

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