Table Gen_Product_Pictures

Entity

Entity: General.Products.ProductPictures

Pictures of products. Entity: Gen_Product_Pictures

Owner Tables Hierarchy

Gen_Products

Summary

Name	Type	Description
Comments	`nvarchar(254)`
Is_Default	`bit`	1=This is the default picture for the product and the size class; 0=otherwise
Last_Update_Time	`datetime` Readonly	The exact server time, when the picture was last updated. Set automatically.
Picture	`varbinary`	The actual product picture. Can be NULL if we insert only some comments
Picture_No	`int`	Unique picture number within the product. Also used for sorting
Picture_Size_Class	`nvarchar(1)` Allowed: `S`, `L`	Specifies the relative picture size and usage. S=Small picture (thumbnail), L=Large picture (full size), NULL=unspecified.
Product_Id	`uniqueidentifier`
Product_Picture_Id	`uniqueidentifier` `PK`
Row_Version	`timestamp`

Columns

Comments

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254) (Allows NULL)
UI Memo Editor	yes
UI Width	100
User Login	no
Visible	yes

Is_Default

1=This is the default picture for the product and the size class; 0=otherwise

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Is_Default - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Last_Update_Time

The exact server time, when the picture was last updated. Set automatically.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Last_Update_Time - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	yes

Picture

The actual product picture. Can be NULL if we insert only some comments

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	4
Ownership Reference	no
Pasword	no
Picture	yes
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	varbinary (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Picture_No

Unique picture number within the product. Also used for sorting

Property	Value
Auto Complete	no
Autoincrement	1
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Picture_No - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	yes

Picture_Size_Class

Specifies the relative picture size and usage. S=Small picture (thumbnail), L=Large picture (full size), NULL=unspecified.

Property	Value
Allowed Values	`S`, `L`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(1) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Product_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	1
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Products
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Product_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Product_Picture_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Product_Picture_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	yes

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Table of Contents