What happens to other related tables (Orders, Shipments, Addresses, Posts, Emails, etc) in the database when we delete a customer?
- how does a relational database stay intact with a missing reference to the Customers's table record?
- how can I make sure that all occurence of a customer's any personal data will get deleted (like Orders, Addresses, any addresses mentioned in the Enqued Emails archive table, shipments, forum posts, etc)
- how can I make sure at the same time that all bookkeeping-related data like the deleted customer's previous orders stay listable, reportable, so I can make correct financial reports required by tax authorities.
I am not crazy, just trying to implement the GDPR rules :-) Do you know of anybody being able to correctly do these in any ecommerce system in the world?