> With foreign key constraints, you have to delete all related records when a parent record is deleted.

ON DELETE SET NULL is a thing for a reason!