Welcome Guest, Not a member yet? Register   Sign In
Help with datamapper database design and structure
#1

[eluser]Andy78[/eluser]
I am developing a sort of multiple takeaway online ordering website. I am struggling a bit with the database design especially to be optimised for datamapper orm. I have attached a ruff EER diagram to this post showing all the tables and their relationships to each other. If you look at the diagram and see how orders relate to takeaways and foods. I was planning just to store the food items for an order simply in a text field in the orders table just to keep it simple but I'm not sure if this is the best way to go about it. Looking at my diagram how should orders really be related to foods? Some kind of join table? Anything else you spot that is wrong with it let me know.

here is the image: EER


Messages In This Thread
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:01 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:33 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:45 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:58 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:22 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:54 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:38 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:51 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 11:04 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 04:37 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 07:36 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 09:27 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 10:34 AM
Help with datamapper database design and structure - by El Forum - 04-16-2012, 02:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB