The loose foreign key was already added for this in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/77636 .  We've
confirmed in https://gitlab.com/gitlab-org/gitlab/-/issues/348269 that
it is indeed safe to swap these foreign keys for loose foreign keys.

Changelog: other