+-----------------------+
| Tables_in_RECIPE      |
+-----------------------+
| ingredient            | 
| recipe                | 
| recipe_ingredient_map | 
| recipe_part           | 
| recipe_part_map       | 
+-----------------------+
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| ingredient_id | int(11)      | NO   | PRI | NULL    | auto_increment | 
| name          | varchar(20)  | NO   | MUL |         |                | 
| description   | varchar(250) | YES  |     | NULL    |                | 
+---------------+--------------+------+-----+---------+----------------+
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| recipe_id   | int(11)      | NO   | PRI | NULL    | auto_increment | 
| name        | varchar(20)  | NO   | MUL |         |                | 
| description | varchar(250) | YES  |     | NULL    |                | 
| notes       | mediumtext   | YES  |     | NULL    |                | 
+-------------+--------------+------+-----+---------+----------------+
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| recipe_part_id | int(11)     | NO   | PRI |         |       | 
| ingredient_id  | int(11)     | NO   | PRI |         |       | 
| amount         | varchar(20) | NO   |     |         |       | 
+----------------+-------------+------+-----+---------+-------+
+----------------+-------------+------+-----+---------+----------------+
| Field          | Type        | Null | Key | Default | Extra          |
+----------------+-------------+------+-----+---------+----------------+
| recipe_part_id | int(11)     | NO   | PRI | NULL    | auto_increment | 
| name           | varchar(20) | NO   | MUL |         |                | 
| directions     | mediumtext  | YES  |     | NULL    |                | 
+----------------+-------------+------+-----+---------+----------------+
+----------------+---------+------+-----+---------+-------+
| Field          | Type    | Null | Key | Default | Extra |
+----------------+---------+------+-----+---------+-------+
| recipe_id      | int(11) | NO   | PRI |         |       | 
| recipe_part_id | int(11) | NO   | PRI |         |       | 
+----------------+---------+------+-----+---------+-------+