Feature

Fields:

Field Type Comments

Reference

FeatureID int(11) auto_increment

Data

Sequence char(50) Used to order features
Level int(11) 0 for heading, 1 for feature
Description char(50) Feature description
AllText char(50) Text to be used to indicate every feature within heading selected
Nothing char(50) Text to be used to indicate no features within heading have been selected
Element int(11) Groups features together: 1=House Style, 2=Age, 3=Garden, 4=Parking, 6=Must Have's
Mask int(11) Bitmask for feature

Indexes:

Key Fields Comment
PRIMARY FeatureID