[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