| Field |
Type |
Comments |
Referencing |
| ControlID |
int(11) |
Used to select the only record (always 1) |
Data |
| DatabaseName |
varchar(50) |
The name of the MySQL database name |
| Config1 |
int(11) |
Bitflags used switch on/off genesis customization features |
| Config2 |
int(11) |
As above - not currently used |
| ClientNumber |
int(11) |
Unique number for each estate agent |
| PictureURL |
varchar |
String used to generate an http pointer to property images so that they
can be downloaded by third parties (such as newspapers) |
| JustListedText |
varchar |
Special text to be used for advertising when a property is first listed. |
| FallenThroughText |
varchar |
Special text to be used for advertising when a property falls through.
|
| PriceReducedText |
varchar |
Special text to be used for advertising when a property price is reduced. |
Narrative Defaults (Consider depricating
with switch to standard narrative) |
| DefaultNarrative |
longblob |
Blank template for property narrative |
| NarrativeLocation |
varchar |
Name of the narrative section |
| NarrativeAbstract |
varchar |
|
| NarrativeSummary |
varchar |
|
| NarrativeBullets |
varchar |
|
| NarrativeOverview |
varchar |
|
| NarrativeAccommodation |
varchar |
|
| AdvertisingLocation |
varchar |
Defines the narrative sections to be used for the location in adverts. |
| AdvertisingCopy |
varchar |
Defines the narrative sections to be used for the copy in adverts. |
| WebLocation |
varchar |
Defines the narrative sections to be used for the location on websites
and portals. |
| WebAbstract |
varchar |
|
| WebSummary |
varchar |
|
System |
| DemoBaseDate |
datetime |
Used only in demo system within the FixDate refresh process |
