It seems like you want to retain the original price of each item ordered. What I'd do is go with option 1, then create another column in your table that holds a string that identifies each item in the order.
For example, if I were selling fruit, a banana could have iZ
as a unique key. And an apple could have 6U
as a unique key. When a user places an order, these unique keys would be inserted into your new column. So when you see this column's data is iZ6U
you'd know that the user ordered an apple and a banana.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…