Yep sometimes a FK row needs to be separated from the parent row. And I don't want to hard delete it. That can be really problematic if there are enforced integrity constraints. And lots of FKs directly reference parent PKs. signed int keys really help here