[jokull]

The way to do it is to have foreign keys, but instead of hard delete you scrub data in the columns.

[snowwrestler]

Seems like if you can scrub data, it is mutable? Maybe I misunderstand what “immutable” means.