Table Definition - Image

Field Type Read-only Description
ID Integer Yes Primary Key (unique ID) for row. Foreign Key to 'Standard' table
Format Char No Image format type (JPG, GIF, PNG, BMP). Will convert file (and change extension) when used in UPDATE statements, or copy into new file when copy mode is enabled
HorizRes Integer No Horizontal resolution in pixels. Will resize image (maintaining vertical resolution) when used in UPDATE statements
VertRes Integer No Vertical resolution in pixels. Will resize image (maintaining horizontal resolution) when used in UPDATE statements
Size Double No Current normalized size of image. Will grow/shrink an image when used in UPDATE statements. See notes below
Comment Char Yes Embedded image comments (if supported)

Usage Notes

  1. INSERT and DELETE statements may not be run against the 'Image' table. For creating and deleting files, please see the 'Standard' table
  2. Changes made to the 'Size' field in UPDATE statements will grow or shrink the image, maintaining the aspect ratio, by a factor of the value specified. E.g. for an image originally 200x300, specifying 3 for 'Size' in an UPDATE statement would resize the image to 600x900. Specifying 0.5 for 'Size' in an UPDATE statement would resize the image to 100x150. A value of 1 will always be returned for 'Size' from a SELECT statement
  3. Fields may not be populated if row corresponds to a directory, or non-image file type. The 'ID' field also serves as a foreign key into the 'Standard' table, and a JOIN may be used between the two tables

© 2014 Synthetic Dreams Back to Top

Back to Top

Follow Us

Twitter icon
Facebook icon
LinkedIn icon

Tweets from the Team