index_words, index_rel

Words-table and word-relation table. Almost self-explanatory. For the index_rel table some fields require explanation:

count

Field
count
Description
Number of occurrences on the page

first

Field
first
Description
How close to the top (low number is better)

freq

Field
freq
Description
Frequency (please see source for the calculations. This is converted from some floating point to an integer)

flags

Field
flags
Description

Bits, which describes the weight of the words:

8th bit (128) = word found in title,

7th bit (64) = word found in keywords,

6th bit (32) = word found in description,

Last 5 bits are not used yet, but if used they will enter the weight hierarchy. The result rows are ordered by this value if the "Weight/Frequency" sorting is selected. Thus results with a hit in the title, keywords or description are ranked higher in the result list.