Page is a not externally linkable
RWSteele - 6:23 pm on Nov 15, 2006 (gmt 0)
order orderitems Just my .02.
I've always worked with a OrderItems/OrderDetails table. Why wouldn't you?
Just off the top of my head I can think of a few reasons.
-------------
orderId
customerID
orderDate
paymentType
lastModifed
orderStatus
dateShipped
-------------
orderitemID
orderId
productId
quantity
inventoryStatus (out of stock, backordered,etc)
shippingAmount
discountAmount (coupons, discounts, etc)
productTotal