craft database design spec

CRAFT DATABASE DESIGN SPEC

DATA TO STORE FOR COOKING DESIGNS:
-number (eg 10043)
-recipe name (eg 'a crusty loaf of bread')
-recipe type (eg 'bread')
-recipe ingredients (an array with numbers of things- eg '2 flour, 1 salt, 1 milk')
-recipe tags (eg 'bread, meals, mediterranean, component')

DATA TO DISPLAY - returned data would be number and recipe name together for each item.
-Search by number (output all recipe data for that number)
-search by name (output all recipes with keyword in name)
-search by type (output all recipes with keyword type)
-search by ingredients (output all recipes with keyword ingredient- potentially search by multiple ingredients?)
-search by tag (output all recipes with keyword tag)

SHOPPING LIST
-Add recipes by number to shopping list
-output condensed list of ingredients- total numbers of everything needed (ie 23 flour, 4 salt, 2 milk, 1 chocolate)


DATA TO STORE FOR INGREDIENTS
-ingredient name (eg 'a bucket of clams')
-ingredient type (eg 'clams')
-ingredient location (eg 'riparium')
-ingredient method (eg 'foraged')
-ingredient cost (eg '100' - not applicable to all)

SHOPPING LIST OUTPUT
-categorise ingredients by location ('riparium' separate from 'shamtota' etc)
-output total cost