Help with datamapper database design and structure

[eluser]North2Alaska[/eluser]
[quote author="Andy78" date="1334156496"]Looking at my diagram how should orders really be related to foods? Some kind of join table?[/quote]

With the idea that a food item can be on many orders and many orders have the same one food, you have a many to many relationship. Therefore, you need a table between the two. For DM it would be food_orders (or is that foods_orders?) it would have three columns; id, food_id, order_id.

And then in your food model you would have:
$has_many = array('order');

and in your order model you would have:
$has_many = array('food');