Mysql Database design structure

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.

Leave a Comment