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?
item_price table in the image is not i use. Please ignore that table while answering. Thanks