mysql> describe wp_posts;
+-----------------------+---------------------+------+-----+---------------------+----------------+
| Field                 | Type                | Null | Key | Default             | Extra          |
+-----------------------+---------------------+------+-----+---------------------+----------------+
| ID                    | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment | 
| post_author           | bigint(20)          | NO   |     | 0                   |                | 
| post_date             | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| post_date_gmt         | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| post_content          | longtext            | NO   |     | NULL                |                | 
| post_title            | text                | NO   |     | NULL                |                | 
| post_category         | int(4)              | NO   |     | 0                   |                | 
| post_excerpt          | text                | NO   |     | NULL                |                | 
| post_status           | varchar(20)         | NO   |     | publish             |                | 
| comment_status        | varchar(20)         | NO   |     | open                |                | 
| ping_status           | varchar(20)         | NO   |     | open                |                | 
| post_password         | varchar(20)         | NO   |     |                     |                | 
| post_name             | varchar(200)        | NO   | MUL |                     |                | 
| to_ping               | text                | NO   |     | NULL                |                | 
| pinged                | text                | NO   |     | NULL                |                | 
| post_modified         | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| post_modified_gmt     | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| post_content_filtered | text                | NO   |     | NULL                |                | 
| post_parent           | bigint(20)          | NO   |     | 0                   |                | 
| guid                  | varchar(255)        | NO   |     |                     |                | 
| menu_order            | int(11)             | NO   |     | 0                   |                | 
| post_type             | varchar(20)         | NO   | MUL | post                |                | 
| post_mime_type        | varchar(100)        | NO   |     |                     |                | 
| comment_count         | bigint(20)          | NO   |     | 0                   |                | 
+-----------------------+---------------------+------+-----+---------------------+----------------+
24 rows in set (0.01 sec)

mysql> describe wp_comments;
+----------------------+---------------------+------+-----+---------------------+----------------+
| Field                | Type                | Null | Key | Default             | Extra          |
+----------------------+---------------------+------+-----+---------------------+----------------+
| comment_ID           | bigint(20) unsigned | NO   | PRI | NULL                | auto_increment | 
| comment_post_ID      | int(11)             | NO   | MUL | 0                   |                | 
| comment_author       | tinytext            | NO   |     | NULL                |                | 
| comment_author_email | varchar(100)        | NO   |     |                     |                | 
| comment_author_url   | varchar(200)        | NO   |     |                     |                | 
| comment_author_IP    | varchar(100)        | NO   |     |                     |                | 
| comment_date         | datetime            | NO   |     | 0000-00-00 00:00:00 |                | 
| comment_date_gmt     | datetime            | NO   | MUL | 0000-00-00 00:00:00 |                | 
| comment_content      | text                | NO   |     | NULL                |                | 
| comment_karma        | int(11)             | NO   |     | 0                   |                | 
| comment_approved     | varchar(20)         | NO   | MUL | 1                   |                | 
| comment_agent        | varchar(255)        | NO   |     |                     |                | 
| comment_type         | varchar(20)         | NO   |     |                     |                | 
| comment_parent       | bigint(20)          | NO   |     | 0                   |                | 
| user_id              | bigint(20)          | NO   |     | 0                   |                | 
+----------------------+---------------------+------+-----+---------------------+----------------+
15 rows in set (0.00 sec)