Untitled

mysql> describe Ingredient;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| IngredientID | int(11)      | NO   | PRI | NULL    | auto_increment | 
| Name         | varchar(255) | NO   | UNI |         |                | 
| IsVegitarian | bit(1)       | NO   |     |         |                | 
+--------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> describe Recipe;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| RecipeID    | int(11)      | NO   | PRI | NULL    | auto_increment | 
| Title       | varchar(255) | NO   |     |         |                | 
| Description | text         | NO   |     |         |                | 
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> describe IngredientToRecipe;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| RecipeRef        | int(11)      | NO   | PRI |         |       | 
| IngredientRef    | int(11)      | NO   | PRI |         |       | 
| Amount           | varchar(64)  | NO   |     |         |       | 
| Unit             | varchar(32)  | NO   |     |         |       | 
| PreparationHints | varchar(255) | YES  |     | NULL    |       | 
+------------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)