[mythtv-users] MythRecipe source code
Joseph A. Caputo
jcaputo1 at comcast.net
Mon Nov 8 20:39:13 UTC 2004
On Monday 08 November 2004 15:01, Christopher Flynn wrote:
> Ok, so there seems to be enough interest and everyone seems to think
> a rewrite of the sql structure is in order. So let's start with the
> sql and get a good database structure
[snip]
> Now for the ingredients:
> qty, amt, des, recID, ingID
> For something like 1 cup flour it would be as such:
> qty: 1
> amt: cup
> des: flour
Just one tiny suggestion: "qty" (quantity) and "amt" (amount) say
pretty much the same thing. What about changing "amt" to "units",
which more accurately describes its content.
Also, would it be advantageous to make the "unit" column an ID instead
of a string? That might facilitate conversions and scaling down the
road... just a thought. Might make sense to maintain a table of units
that can be cross-referenced to common conversions; i.e., 3 tsp = 1
tbsp, or metric <-> English, etc.
-JAC
More information about the mythtv-users
mailing list