[eluser]Andy78[/eluser]
Just to be clear I have inherited this project and I am converting a half finished very poorly put together project over from raw php to codeigniter and have just tried my best to convert over the existing database so there are still some anomalies lol
The pizza, kebab etc are in the main takeaways table to determine if that takeaway sells that food type, from the existing records these fields just contain a 1 for yes or a 0 no. So for example a kebab shop in the uk will more than likely also sell Indian food and Pizza's as well. Also the client is insisting that pizza toppings be classed as food type the same as everything else so that it will work with his web-service which another developer has set-up. So the “pizza_topping” in food just contains a 1 or 0 to determine if this food item is a pizza-topping or not.
As I set this is how it was setup by the developer who initially started the project I am open to suggestions on how to make it better.