mysql> use nsdb;
Database changed
mysql> desc users;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(11)     | NO   | PRI | NULL    | auto_increment |
| name     | varchar(15) | NO   | UNI | NULL    |                |
| password | varchar(50) | NO   |     | NULL    |                |
| email    | varchar(50) | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
4 rows in set (0.09 sec)

mysql> desc topics;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| id      | int(11)     | NO   | PRI | NULL    | auto_increment |
| title   | varchar(50) | NO   |     | NULL    |                |
| body    | text        | NO   |     | NULL    |                |
| user_id | int(11)     | NO   |     | NULL    |                |
| tags    | varchar(50) | NO   |     | NULL    |                |
+---------+-------------+------+-----+---------+----------------+
5 rows in set (0.02 sec)

mysql> desc comments;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(11)     | NO   | PRI | NULL    | auto_increment |
| user_id  | int(11)     | NO   |     | NULL    |                |
| topic_id | int(11)     | NO   |     | NULL    |                |
| title    | varchar(50) | NO   |     | NULL    |                |
| body     | text        | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
5 rows in set (0.03 sec)

