mysql> describe thread;
+--------------------------+------------------+------+-----+----------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+------------------+------+-----+----------------+----------------+
| thread_id | int(8) unsigned | NO | PRI | NULL | auto_increment |
| thread_root | int(8) unsigned | NO | UNI | NULL | |
| thread_ancestor | int(8) unsigned | NO | MUL | NULL | |
| thread_parent | int(8) unsigned | YES | MUL | NULL | |
| thread_summary_page | int(8) unsigned | YES | MUL | NULL | |
| thread_subject | varbinary(255) | YES | | NULL | |
| thread_author_id | int(10) unsigned | YES | MUL | NULL | |
| thread_author_name | varbinary(255) | YES | | NULL | |
| thread_modified | binary(14) | NO | MUL | | |
| thread_created | binary(14) | NO | MUL | | |
| thread_editedness | int(1) | NO | | 0 | |
| thread_article_namespace | int(11) | NO | MUL | NULL | |
| thread_article_title | varbinary(255) | NO | | NULL | |
| thread_article_id | int(8) unsigned | NO | MUL | NULL | |
| thread_type | int(4) unsigned | NO | | 0 | |
| thread_sortkey | varbinary(255) | NO | MUL | | |
| thread_replies | int(8) | YES | | -1 | |
| thread_signature | tinyblob | YES | | NULL | |
+--------------------------+------------------+------+-----+----------------+----------------+
