if the goal is the ability to rollback a certain delete, it's probably better to make it a nullable fk on a delete event with a timestamp. But a nullable times

if the goal is the ability to rollback a certain delete, it's probably better to make it a nullable fk on a delete event with a timestamp. But a nullable timestamp could also be viable, just can't tell two different delete, at the same time, apart