Swap FK projects.pool_repository_id to pool_repositories.id for LFK

Douglas Barbosa Alexandrerequested to merge
521717-org-mover-swap-fk-pool_repositories-to-projects-for-lfk into master

What does this MR do and why?

As part of our "sharding key" efforts we need to mark the pool_repositories table as exempt from sharding in !182030 (comment 2356809867), but it has foreign key references to it. The table with foreign key references is: projects. This MR replaces the foreign key with "loose foreign keys".

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports