We will remove the foreign key in a later MR but for now we can start
with adding the LFK. These have all been determined as safe to be
converted to a loose foreign key in https://gitlab.com/gitlab-org/gitlab/-/issues/348274.