[eluser]WanWizard[/eluser]
"foods_orders". Both tables names, in alphabetical order, and separated by an underscore.
From a normalisation point of view, there are some question marks.
I don't see why pizza, kebab etc are fields in the main table. What if a merchant introduces sushi tomorrow? Same for "pizza_topping" in food. What if I ordered chinese? Then I don't want toppings, I want prawn crackers and a hot pepper sauce.