Re: Table Design Help

[Peter Brawley]

Three tables minimum. Each order may have 1 or more order_items rows. Order_items is a "bridge" table between orders and items in whuch each row points at one orders row and one items row, eg ...

orders(orderid int pk, ts timestamp, ...)
items(itemid, name, ...)
order_items(order_id,item_id)

For repeat customers you might want to add a customers table, and add an optional customerid to the orders table.

Read about database normalisation.