Change parent_id FK from ON DELETE SET NULL to ON DELETE CASCADE. Deleting a parent comment now deletes all its replies at the DB level. Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>