Table of words
Word/Phrase
Index ( smallint )
Usage/definition
Examples
Table of results
Word/Phrase index ( smallint )
Number of results ( mediumint )
Aggregate score per affect index ( DOUBLE(9,2) UNSIGNED ) up to 1 billion to 2 decimal places
Table of affects
Affect ( varchar )
Affect id ( tinyint )
Table of voters
IP address who have voted
array of Word/Phrase index voted for ( smallint )