What is the user's list response when the product is removed?

want to ask a question
see what everyone does

suppose there is an item < 1
the user sets up a list after buying item A, and uses the relational database to find 1 and then go to the information table product to introduce purchased goods
suppose one day to delete item A, the user will make an error if he wants to view the product
think about how to do it
I have thought of two ways

when deleting, empty the item A data of product to a deleted item, but when the item is still
list, put the item name and product name of item An into the list

what do you think?

Database-design mysql mysqli php7 php

Apr.14,2021

I suggest that when creating an order, associate the product message with the order and make a snapshot , not necessarily delete. The product title pictures may all be open to merchant editors, and the order information should be unique. I can't buy a watermelon today, and tomorrow the merchant will change this link to banana . Then I went to see the historical order become that I bought a banana

yesterday.

instead of actually deleting the Product record, add a Bool field isDelete to identify whether the product was deleted.

Filter deletes the deleted product data when displaying the product list
products that are not deleted by Filter are not displayed when the order is displayed.

Previous: In Angluar, I need to use the data returned asynchronously to set a state to make the page display the corresponding page. What should I do?

Next: The vue, component calls the generic component, how to control the different content in different page display components?