|
 |
Area
Fields:
| Field |
Type |
Comments |
Reference |
| OfficeID |
int(11) |
Office to which the area relates |
| Department |
int(11) |
Identifies the department to which the area belongs (1 for sales, 2
lettings, 4 commercial, 8 land) |
| Mask |
int(11) |
One bit in integer set to indicate one of 32 possible areas within the
office |
Data |
| Name |
char(255) |
Area Name |
| DistrictCode |
int(11) |
Allows offices to share areas. All areas with the same district code
are treated as the same physical area. If an applicant selects the area
in one office, the corresponding area is selected for the other office(s) |
System |
| Closed |
tinyint(1) |
|
Defunct |
| AreaID |
int(11) |
|
| |
|
|
Indexes:
| Key |
Fields |
Comment |
| PRIMARY |
OfficeID, Department, Mask |
|
| AreaID |
AreaID |
Defunct |
| OfficeID |
OfficeID |
Defunct |
|
|
© Radical Solutions Limited 2005
|
|