@Augustin the problem is that if a user placed an order in OFN and wants to leave the platform we’ll have a whole lot of chained relationships tied to that. The order cannot be deleted for instance since other users (e.g. hub admins) will need that historical info. In any case would be impractical to remove everything tied to that user.
At enterprise level would be even worst, so many relationships to take care of.
The “deleted user” pattern I propose is not a painless one, just a practical take on the issue. And it can garantee anonymization (if properly done). As per the email I mistyped, you need some more trick there, but that’s not the point of this discussion.
I cannot see a third option though. Any other idea?