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)