| Field |
Type |
Comments |
Referencing |
| PictureID |
int(11) |
Unique reference |
| OriginatingSiteID |
int(11) |
Site which originally uploaded the image |
| PropertyID |
int(11) |
If this is a picture of a property contains the property id else zero. |
| OfficeID |
int(11) |
If this is a picture of an office contains the office id else zero. |
| NewHomeSiteID |
int(11) |
If this is a picture of a new home site contains the site id else zero. |
Attachment Details |
| Sequence |
int(11) |
Unsed to arrange the pictures into order |
| Width |
int(11) |
Image width in pixels |
| Height |
int(11) |
Image height in pixels |
| Quality |
int(11) |
JPEG quality |
| Caption |
varchar |
Title for image |
| FileSize |
int(11) |
File size in bytes |
| FileDate |
datetime |
Timestamp of file |
| FileType |
int(11) |
0=jpeg, 100=png, 200=pdf, 201=word |
| ObjectClass |
int(11) |
0=picture, 1=floorplan, 100=details, 990=proof of identity |
| RoomSpace |
varchar(255) |
The name of the room or space. Allows the picture to be placed in the
correct position within the property details |
| NotOnWeb |
tinyint(1) |
If set to 1, the image will not be displayed on the website |
Control |
| Closed |
tinyint(1) |
|
| CreationOffice |
int(11) |
|
| CreationUser |
int(11) |
|
| CreationDate |
datetime |
|
| ModificationOffice |
int(11) |
|
| ModificationUser |
int(11) |
|
| ModificationDate |
datetime |
|
