mysql> describe boxfolder;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| boxfolder_id | int(7)       | NO   | PRI | NULL    | auto_increment |
| volume       | varchar(20)  | NO   |     | NULL    |                |
| box          | varchar(10)  | NO   |     | NULL    |                |
| folder       | varchar(20)  | YES  |     | NULL    |                |
| range        | text         | YES  |     | NULL    |                |
| comments     | varchar(100) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+