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.
recipeIngredient(recipeID, ingredientID, amount)
recipeCategory(recipeID, categoryID, etc.)
So I have a couple of questions.
* How am I doing so far? Is this design okay from what you all know?
* 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).
Thank you for your help.