From dbscript Online Help
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
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.
|
Dependency Type
|
Object Type
|
Referenced Object
|
Schema
|
Schema
|
Production
|