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 this foreign key for a loose foreign key.

Changelog: other