Is there any particular reason why ONE table wouldn't do the trick just fine?
Title (varchar 255)
Recipe (long text)
or break it out to maybe refine ingredient searches and get a little fancier:
ShortDescr (long text)
Ingredients (long text)
Method (long text)
KeyWords (varchar 255)
If all the guy wants to do is type in his recipes and find them again, or search for
all recipes which contain chili peppers, wouldn't this be simpler for him to maintain
and deliver the same functionality?
---------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---------------------------------------
---------- Original Message ----------------------------------
from: "VAN VLIET, SCOTT E (SBCSI)" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 29 Mar 2002 13:49:16 -0800
Depending on the depth of you database, the best thing to do would to be
create a master RECIPE table, and a master INGREDIENT table. The, you could
create an linkage table that would like n number of ingredients to a recipe.
EXAMPLE:
RECIPE
==================================================
RC_ID RC_NAME RC_DESCRIPTION
--------------------------------------------------
10 Chocolate Cookies Yummy!
20 Chocolate Brownies More Yummy!
INGREDIENT
==================================================
IN_ID IG_NAME IN_DESCRIPTION
--------------------------------------------------
1 Flour White Stuff
2 Sugar Sweet Stuff
3 Egg Yolks & Stuff
4 Salt NaCl2
5 Chocolate Good Stuff
6 Chocolate Chips Little Stuff
RECIPE_INGREDIENT
=============================
RI_ID RC_ID IN_ID
-----------------------------
1 10 1
2 10 2
3 10 3
4 10 4
6 10 6
7 20 1
8 20 2
9 20 3
10 20 4
11 20 5
The table, RECIPE_INGREDIENT, would contain an identity for the relationship
(RI_ID), a reference to the recipe (RC_ID) and a reference to the related
ingredient (IN_ID).
So, to find out what ingredients are used in Chocolate Brownies, you could:
SELECT RI.IN_ID, IN.IN_NAME, IN.IN_DESCRIPTION
FROM RECIPE_INGREDIENT RI JOIN
INGREDIENT IN ON RI.IN_ID = IN.IN_ID
WHERE RI.RC_ID = 20
You can go even farther and attach the recipe details to this query. But I
hope this leads you in the right direction!
--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
-----Original Message-----
From: Deborah Curley [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 1:31 PM
To: CF-Talk
Subject: CF/Database Help
Hi,
I have a friend whose a chef and has asked me build him a database of
recipes and a web app he can use to search, enter new recipes, etc. What I'm
trying to figure out is the best way to store the ingredients since a recipe
can have anywhere from 5 to 20 ingredients? Any ideas on the best way to
handle that?
TIA,
Deb
_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
