mysql> describe pubs;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| pubid      | int(11)     |      | PRI | NULL    | auto_increment |
| title      | mediumtext  | YES  |     | NULL    |                |
| author     | mediumtext  | YES  |     | NULL    |                |
| tag        | varchar(32) | YES  |     | NULL    |                |
| year       | date        | YES  |     | NULL    |                |
| publisher  | varchar(64) | YES  |     | NULL    |                |
| pages      | varchar(16) | YES  |     | NULL    |                |
| ptype      | varchar(8)  | YES  |     | NULL    |                |
| ctype      | varchar(8)  | YES  |     | NULL    |                |
| isbn       | varchar(16) | YES  |     | NULL    |                |
| isbn2      | varchar(16) | YES  |     | NULL    |                |
| coverart   | mediumtext  | YES  |     | NULL    |                |
| bcoverart  | mediumtext  | YES  |     | NULL    |                |
| frontimage | mediumtext  | YES  |     | NULL    |                |
| price      | varchar(16) | YES  |     | NULL    |                |
| note       | int(11)     | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
16 rows in set (0.00 sec)

mysql> describe authors;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| pubid      | int(11)     |      | PRI | NULL    | auto_increment |
| canonical  | mediumtext  | YES  |     | NULL    |                |
| legalname  | mediumtext  | YES  |     | NULL    |                |
| birthplace | varchar(64) | YES  |     | NULL    |                |
| birthdate  | date        | YES  |     | NULL    |                |
| deathdate  | date        | YES  |     | NULL    |                |
| pseudos    | mediumtext  | YES  |     | NULL    |                |
| emails     | mediumtext  | YES  |     | NULL    |                |
| webpages   | mediumtext  | YES  |     | NULL    |                |
| note       | int(11)     | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

mysql> describe notes
    -> ;
+-------+------------+------+-----+---------+----------------+
| Field | Type       | Null | Key | Default | Extra          |
+-------+------------+------+-----+---------+----------------+
| pubid | int(11)    |      | PRI | NULL    | auto_increment |
| note  | mediumtext | YES  |     | NULL    |                |
+-------+------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)