OfficeRequirement

Fields:

Field Type Comments

Reference

OfficeID int(11) Office reference
ContactID int(11) Contact Reference
NegotiatorID_Sales int(11) The sales negotiator in the office who is managing the applicant
NegotiatorID_lettings int(11) The lettings negotiator in the office who is managing the applicant

Data

Areas int(11) Bitmask that identifies the areas of interest or -1 if any area
Noted tinyint(1) Applicant has been aknowledged by the office through the 'transferred applicants' function

System

Closed tinyint(1)  
CreationOffice int(11)  
CreationUser int(11)  
CreationDate datetime  
ModificationOffice int(11)  
ModificationUser int(11)  
ModificationDate datetime  
NegotiatorID int(11)  
     

Indexes:

Key Fields Comment
PRIMARY OfficeID, ContactID  
ContactID ContactID, OfficeID  
NegotiatorID NegotiatorID  
OfficeID OfficeID, CreationDate