I am building a recipe app for a fast food chain
The fast food chain sells burgers and fries.
I have a table for cost prices and I have a parent and child relationship going whereby the user can add food items in and put the qty in and arrive at a cos price per menu item.
But I have a few things which are confusing to me about how to structure the rest.
Most of the items have standardised pricing, but the bread and vegetables are priced differently across the country.
To account for this there are two tables which take into account the variances in pricing across the country to get average costs.
I’d like to take those two tables and then incorporate those average prices in the price list so that the user uses a REF drop down to select an item and gets the dereferenced price for that particular item but I can’t think about how to bring these tables into the price list table I want to use to have all the cost prices in.
How do best incorporate the other two tables in?
There is a 4th table whereby the user can enter recipe items in and get the cost of the recipe.
It had too many fields to include here
