A Daily menu has four lists of recipes, once created they can be used quite easily by the gui, however, to store a list of recipes, I will have to find a way to represent a recipe as a string.
I'm thinking that I'll do this be appending the source field to the title field. I will have to enforce this as the unique key in the recipe table, but then I can store these two fields as the unique key in the menu table, then when a menu is requested, the daily menu can be reconstructed by querying the database for the matching recipes.
A Daily menu has four lists of recipes, once created they can be used quite easily by the gui, however, to store a list of recipes, I will have to find a way to represent a recipe as a string.
I'm thinking that I'll do this be appending the source field to the title field. I will have to enforce this as the unique key in the recipe table, but then I can store these two fields as the unique key in the menu table, then when a menu is requested, the daily menu can be reconstructed by querying the database for the matching recipes.