title: Modeling A Food Recipes Database
body: <p>I'm trying to design a "recipe box" database and I'm having trouble getting it right. I have no idea if I'm on the right track or not, but here's what I have. </p>
  
  <p>recipes(recipeID, etc.)<br>
  ingredient(ingredientID, etc.)<br>
  recipeIngredient(recipeID, ingredientID, amount)<br>
  category(categoryID, name)<br>
  recipeCategory(recipeID, categoryID, name, etc.)  </p>
  
  <p>So I have a couple of questions.</p>
  
  <ul>
  <li>How am I doing so far? Is this design okay from what you all know?</li>
  <li>How would I implement the preparation steps? Should I create an additional many-to-many implementation (something like preparation(prepID, etc.) and recipePrep(recipeID, prepID)) or just add the directions in the recipes table? I would like this to be an ordered list in the UI (webpage).</li>
  </ul>
  
  <p>Thank you for your help.</p>