Picture

Fields:

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  

Indexes:

Key Fields Comment
PRIMARYPictureID 
PropertyIDPropertyID 
NewHomeSiteIDNewHomeSiteID 
OriginatingSiteIDOriginatingSiteID 
OfficeIDOfficeID