Updated: 2009-10-05

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores the Store Logo, Employee Photo, and Employee Signature images.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 1502 - Graphic

Note: The Description and FileName fields are not used in this table like they are in sql_structure_-_pricinggraphic_table. The image is always stored in the Picture field.

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
Graphic.ID int Primary Key for the Table sql_structure_-_store_table.LogoID
sql_structure_-_employee_table.PerImageID
sql_structure_-_employee_table.SignatureID
Graphic.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
Graphic.IsSystem bit Used to Mark Required Records
Graphic.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
Graphic.ModifiedByUser nvarchar(25) Windows User who last modified this record
Graphic.ModifiedDate datetime DateTime this Record was last modified
Graphic.Picture image Binary data representing the image.
Graphic.SeqID int
Graphic.StoreID int Not Used.

Related Tables

sql_structure_-_pricinggraphic_table

You could leave a comment if you were logged in.