Difference between revisions of "Production.ProductPhoto (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.ProductPhoto |- |} {| border="1" cellpadding="5" cellspacing="0" ...)
 
Line 59: Line 59:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Production.ProductProductPhoto_(table)|Production.ProductProductPhoto]]
 +
| ProductPhotoID
 +
| ProductPhotoID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.ProductPhoto
 +
|-
 +
 +
| '''Description
 +
| Product images.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:27, 27 November 2009

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ProductPhoto_(table)&oldid=1109"