Hello everybody, i got new challenge, and its how to create DB architecture for eshop. For example, if i delete item, this item deleted from order? If i change price, name, qty, etc., change it in order also? I found some thing like soft delete - set up item with infomation for example "deactivated" and do not delete any items. Next is robust architecture from example Shopify, new table for versions of items. Or the easiest way what i had in the beginning, just copy same data about item to the order. But data in DB should not be same (double), for these i created M-M tables. What is classis approach of that? PS: I use Postgres DB. Thank you 🤖