Order table Database design I'm in need of some help with the database design of order table of a shopping cart for online food ordering system. I have a design below. Tables about which I'm Concerned  are order_details and order. Basically what is going to happen is user selects foods from restaurant menus and will place order, User details are stored in the user table (which is not shown in the image).

This is my first attempt, I was never good at Database. So please take it easy if you fill that the question is way too low for this site.

And my questions are:


Are the tables good enough?
Do I need to add any more fields?
And one more question I need to store multiple addresses of users(user can have multiple shipping address) how can I handle this?

http://i.stack.imgur.com/HCYBi.jpg


Note The item_price table in the image is not i use. Please ignore that table while answering. Thanks
And again ;) I recommend that too often these days.
The Data Model Resource Book, Volume 1.
Order management, address management - solved, problems explained, well documented. Complex but you can simplify - just reading it will really help you understand the problems at hand.