mysql> explain vendors;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | int(20)      | NO   | PRI | NULL    | auto_increment |
| company_name | varchar(255) | YES  |     | NULL    |                |
| contact_name | varchar(255) | YES  |     | NULL    |                |
| address      | varchar(255) | YES  |     | NULL    |                |
| city         | varchar(255) | YES  |     | NULL    |                |
| state        | varchar(100) | YES  |     | NULL    |                |
| zipcode      | varchar(25)  | YES  |     | NULL    |                |
| phone        | varchar(25)  | YES  |     | NULL    |                |
| email        | varchar(255) | YES  |     | NULL    |                |
| url          | varchar(255) | YES  |     | NULL    |                |
| category     | varchar(255) | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+



mysql> explain category;
+-------+---------+------+-----+---------+----------------+
| Field | Type    | Null | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| catid | int(11) | NO   | PRI | NULL    | auto_increment |
| name  | text    | YES  |     | NULL    |                |
+-------+---------+------+-----+---------+----------------+
2 rows in set (0.02 sec)

mysql> select * from category;
+-------+---------------------------+
| catid | name                      |
+-------+---------------------------+
|     1 | Antiques, Liquidators     |
|     2 | Appraiser, Home           |
|     3 | Auto Body                 |
|     4 | Carpet Cleaners           |
|     5 | Dentist                   |
|     6 | Dent Removal              |
|     7 | Electrician               |
|     8 | Financial Consultant      |
|     9 | Flooring                  |
|    10 | Home Inspectors           |
|    11 | Insurance                 |
|    12 | Landscaping               |
|    13 | Mold Inspection / Removal |
|    14 | Moving Companies          |
|    15 | Odor Removal              |
|    16 | Painter / Paper           |
|    17 | Pest Inspections          |
|    18 | Radon Inspections         |
|    19 | Title Agency              |
|    20 | Well Inspections          |
+-------+---------------------------+