|
 |
property
Fields
| Field |
Type |
Comment |
Reference |
| PropertyID |
int(11) |
Unique ID |
| SourceID |
int(11) |
Genesis/GPP reference number |
| AgentID |
int(11) |
|
| BranchID |
int(11) |
|
Address |
| BuildingNumber |
varchar(255) |
|
| Building |
varchar(255) |
|
| StreetNumber |
varchar(255) |
|
| Street |
varchar(255) |
|
| SubLocality |
varchar(255) |
|
| Locality |
varchar(255) |
|
| Town |
varchar(255) |
|
| County |
varchar(255) |
|
| Postcode |
varchar(255) |
|
| Outcode |
varchar(5) |
|
| Country |
varchar(255) |
|
| Location |
varchar(255) |
|
General |
| Register |
tinyint(11) unsigned |
|
| AgentReference |
varchar(255) |
Agents own reference number |
Specification |
| Tenure |
int(11) |
|
| Price |
int(11) |
|
| PriceType |
int(11) |
|
| Status |
int(11) |
|
| Type |
int(11) |
|
| Style |
int(11) |
|
| Bedrooms |
int(11) |
|
| Bathrooms |
int(11) |
|
| Receptions |
int(11) |
|
| Age |
int(11) |
|
| Garden |
int(11) |
|
| Parking |
int(11) |
|
| Features |
int(11) |
|
| Setting |
int(11) |
|
| Abstract |
text |
|
| Summary |
text |
|
| Bullets |
text |
|
| Narrative |
blob |
|
| Keywords |
text |
|
Other |
| SalesParticulars |
varchar(255) |
|
| FloorPlan |
varchar(255) |
|
| VirtualTour |
varchar(255) |
|
| Movie |
varchar(255) |
|
| URL |
varchar(255) |
|
| FineHome |
tinyint(1) unsigned |
|
| Auction |
tinyint(1) unsigned |
|
| AuctionDate |
datetime |
|
| AuctionLot |
int(11) unsigned |
|
| LeasholdYears |
int(11) |
|
| LeasholdStart |
datetime |
|
| Available |
datetime |
|
| Furnished |
int(11) |
|
| Charges |
varchar(255) |
|
| Staffing |
varchar(255) |
|
| FloorSize |
double |
|
| LandSize |
double |
|
| NewHomeSiteID |
int(11) unsigned |
|
| NewHomeStyle |
varchar(255) |
|
| ExcludeFromWeb |
tinyint(1) |
|
| NarrativeApproved |
tinyint(1) unsigned |
|
| Portals |
int(11) unsigned |
|
| SaleDate |
date |
|
| ExchangeDate |
date |
|
| CompletionDate |
date |
|
| SalePrice |
int(11) unsigned |
|
| Fee |
double unsigned |
|
| HolidayPriceBand |
char(1) |
|
| HolidayPriceBandText |
varchar(255) |
|
| HolidaySleeps |
int(11) |
|
| HolidaySleepsMax |
int(11) |
|
| Created |
datetime |
|
| Updated |
datetime |
|
| Uploaded |
datetime |
|
| Closed |
tinyint(1) |
|
Defunct |
| WardCode |
varchar(4) |
|
| DistrictCode |
char(2) |
|
| GridE |
int(11) unsigned |
|
| GridN |
int(11) unsigned |
|
| AreaID |
int(11) |
|
Indexes
| Key | Seq | Column | Comment |
| PRIMARY | 1 | PropertyID | |
| BranchProperty | 1 | SourceID | |
| BranchProperty | 2 | BranchID | |
| AgentID | 1 | AgentID | |
| BranchID | 1 | BranchID | |
| SearchAuction | 1 | AuctionLot | |
| SearchAuction | 2 | AuctionDate | |
| SearchAuction | 3 | Closed | |
| SearchAuction | 4 | ExcludeFromWeb | |
| SearchAuction | 5 | AgentID | |
| SearchAuction | 6 | Price | |
| SearchStandard | 1 | Price | |
| SearchStandard | 2 | AgentID | |
| SearchStandard | 3 | BranchID | |
| SearchStandard | 4 | Status | |
| SearchStandard | 5 | NewHomeSiteID | |
| SearchStandard | 6 | ExcludeFromWeb | |
| SearchStandard | 7 | Closed | |
| SearchStandard | 8 | PropertyID | |
| SearchStandard | 9 | Type | |
| SearchStandard | 10 | Bedrooms | |
| SearchStandard | 11 | Age | |
| SearchStandard | 12 | FineHome | |
| SearchStandard | 13 | Outcode | |
| SearchStandard | 14 | AreaID | |
| SearchAccommodation | 1 | AgentID | |
| SearchAccommodation | 2 | BranchID | |
| SearchAccommodation | 3 | AreaID | |
| SearchAccommodation | 4 | Register | |
| SearchAccommodation | 5 | HolidaySleeps | |
| SearchAccommodation | 6 | HolidaySleepsMax | |
| SearchAccommodation | 7 | ExcludeFromWeb | |
| SearchAccommodation | 8 | Closed | |
| SearchOutcode | 1 | Outcode | |
| SearchOutcode | 2 | Price | |
| SearchOutcode | 3 | Status | |
| SearchOutcode | 4 | ExcludeFromWeb | |
| SearchOutcode | 5 | Closed | |
|
|
© Radical Solutions Limited 2005
|
|