is deletion actually a thing or just formality in production?
Let's take shopify as an example, if a product is deleted, and as they claim deleted product can't be restored, how do they do their stats and other things related to orders
Because the relationships in database will be
Product -> Orders
So technically if a product is deleted orders is supposed to be cascade deleted
Or they have a boolean were on delete it sets thr product to deleted
(or how do you handle such cases at work)
Or will Orders be an Orhan were the relationship will be null on product deletion
Because the relationships in database will be
Product -> Orders
So technically if a product is deleted orders is supposed to be cascade deleted
Or they have a boolean were on delete it sets thr product to deleted
(or how do you handle such cases at work)Or will Orders be an Orhan were the relationship will be null on product deletion
