Looking for some help on how I might design a database for meal plans.
I'm following Kevin Yank's book on PHP & MySQL and I think I have a case for many to many relationships. I have the following structure so far, but I am not sure if it is the most efficient design?
The problem I am solving for is to create a Plan consisiting of n number of meals (meal 1, 2, 3, 4, 5) with various selections of food per meal.
Example: Plan A contains 6 meals(breakfast, snack, lunch, snack, dinner, snack) with 3 food types per meal(eggs, oats, banana).
The coachid is used to allow different coaches to have different names for food, meals, plans. I'm trying to make this multi tenant as well.
Any help would be much appreciated and please be gentle, this is my first database driven design