« Hard work, cats, camels and now it's time for bed | Main | Life's like a movie, make your own ending »
July 23, 2008
Brain dead
Relational databases ate my brain this evening. Now I'm preparing to eat minestrone. If I were going to create a database about my soup, it would require only three tables: RECIPES, INGREDIENTS, RECIPE_INGREDIENT_INDEX. It would not be as tasty as fresh homemade stock simmered for hours with vegetables from the farmers market, home-grown beans from someone I know, sea shell pasta and a sprinkling of Parmesan cheese. This is a very large pot of soup. I'm looking forward to devouring it over the next few days.
Posted by Courtney_Sherwood at July 23, 2008 11:27 PM
Comments
Wouldn't you also need a MEASUREMENTS table or something? If you're going to make ingredients and recipes many-to-many, you probably don't want to keep the amount to add in the ingredients table; then you'd have multiple records in there for the same ingredient in different amounts.
Then you could put a measurement column in RECIPE_INGREDIENT_INDEX. And do they really suggest you put "index" in the name? I'd just call it RECIPE_INGREDIENTS.
:D
Posted by: Gregorus at July 24, 2008 04:54 AM
Great points. I'm going to adapt my recipe database. I have a feeling you have experience with this stuff that goes back to before Tuesday afternoon.
Posted by: Courtney at July 24, 2008 06:58 AM