|
 |
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 |
|
|
© Radical Solutions Limited 2005
|
|
|
|