[RESOLVED] Table structure for an orders table query

[jme]

Hey,

I am in the middle of writing a webstore and have finally come to the checkout part of the site. My question relates to the best way to deal with the data of the ordered items that the customer has and what your thoughts are on the best table structure.

Obviously, customers can buy multiple numbers of many items and I need some way of creating a unique order number for the customer reference also.

Any thoughts, suggestions or comments will be great 🙂

Jamie

[leatherback]

Table users:
user_id | 'details'

Table orders
order_id | user_nr | date / payment / costs

Table ordered_products
order_nr | product_nr

table products
product_id | Product_name | 'details'

Where each nr refers to the id in the identifying table.

Hope it helks. Use joins to link the tables