eCommerce - DB for Orders / Basket


I’m sure it is a stupid question… How would you organize the DB for orders?

I have a DB for Items - I was thinking to add this DB as a field (with multiple choice) in my DB orders.

My issue is then how do I manage the Qty? I’m sure it is stupid… but I’m blocked.

Thanks :blush: