Lookup

Fields:

Field Type Comments

Reference

Type char(255) Used to divide lookup into virtual tables each having their own unique type such as AbilityToBuy or SaleProgress
Value int(11) Value (zero normally reserved for default or undifined state)

Data

Description char(255) Description associated with the value

Indexes:

Key Fields Comment
PRIMARY Type , Value