Table Definition - Image
Submitted by Synthetic Dreams on Fri, 08/15/2014 - 15:18
| 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
- INSERT and DELETE statements may not be run against the 'Image' table. For creating and deleting files, please see the 'Standard' table
- 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
- 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
