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