mysql> use wikidb_quality;
Database changed
mysql> describe ratedpage;
+--------------+-----------------+------+-----+---------+----------------+
| Field        | Type            | Null | Key | Default | Extra          |
+--------------+-----------------+------+-----+---------+----------------+
| ratedpage_id | int(8) unsigned | NO   | PRI | NULL    | auto_increment |
| page_id      | int(8) unsigned | NO   | UNI | 0       |                |
| rating       | char(1)         | NO   |     | T       |                |
+--------------+-----------------+------+-----+---------+----------------+
3 rows in set (0.08 sec)

mysql> describe ratedtext;
+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| ratedpage_id | int(8) unsigned | NO   | PRI |         |       |
| html_text    | mediumblob      | YES  |     | NULL    |       |
| plain_text   | mediumblob      | YES  |     | NULL    |       |
| pos_text     | mediumblob      | YES  |     | NULL    |       |
| parsed_text  | mediumblob      | YES  |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+
5 rows in set (0.02 sec)

mysql> describe features;
+--------------------------+-----------------+------+-----+---------+-------+
| Field                    | Type            | Null | Key | Default | Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| ratedpage_id             | int(8) unsigned | NO   | PRI |         |       |
| words                    | double          | YES  |     | NULL    |       |
| averagewordlength        | double          | YES  |     | NULL    |       |
| averagenumberofsyllables | double          | YES  |     | NULL    |       |
| numberofsentences        | double          | YES  |     | NULL    |       |
| averagesentencelength    | double          | YES  |     | NULL    |       |
| averagelengthofparagraph | double          | YES  |     | NULL    |       |
| proportionofquestions    | double          | YES  |     | NULL    |       |
| conjunctions             | double          | YES  |     | NULL    |       |
| pronouns                 | double          | YES  |     | NULL    |       |
| prepositions             | double          | YES  |     | NULL    |       |
| nominalizations          | double          | YES  |     | NULL    |       |
| colemanliau              | double          | YES  |     | NULL    |       |
| fleschindex              | double          | YES  |     | NULL    |       |
| kincaid                  | double          | YES  |     | NULL    |       |
| smoggrading              | double          | YES  |     | NULL    |       |
| ari                      | double          | YES  |     | NULL    |       |
| fogindex                 | double          | YES  |     | NULL    |       |
| tobe                     | double          | YES  |     | NULL    |       |
| lix                      | double          | YES  |     | NULL    |       |
| age                      | double          | YES  |     | NULL    |       |
| length                   | double          | YES  |     | NULL    |       |
| templates                | double          | YES  |     | NULL    |       |
| external                 | double          | YES  |     | NULL    |       |
| internal                 | double          | YES  |     | NULL    |       |
| relative                 | double          | YES  |     | NULL    |       |
| images                   | double          | YES  |     | NULL    |       |
| paragraphs               | double          | YES  |     | NULL    |       |
| categories               | double          | YES  |     | NULL    |       |
| h2                       | double          | YES  |     | NULL    |       |
| h3                       | double          | YES  |     | NULL    |       |
| h4                       | double          | YES  |     | NULL    |       |
| interlanguagelinks       | double          | YES  |     | NULL    |       |
| referencecount           | double          | YES  |     | NULL    |       |
| pagerank                 | double          | YES  |     | NULL    |       |
+--------------------------+-----------------+------+-----+---------+-------+
35 rows in set (0.02 sec)

mysql>