I'm using digiSHOP 7.9.00 PRO.

Which table in the database stores customer purchases?

I want to see a product number, matched with a customer number so I can see which customer bought which product.

I would think it would be the ds_orders table, but it doesn;t appear to have all the info I would expect (I can;t see a product number anywhere).

The site I am using uses events as products, so purchasing a product is purchasing a place at a table at an event.

There is something in the ds_carts table but that adds a record everytime somebody adds an item to their shopping cart, so I don;t know who has paid and who has just added to cart.

I want to see a list of all custmers who have paid for each event / product.