This is a placeholder issue for removing all foreign keys between the Main and CI databases and replacing them with loose foreign keys. 51 foreign keys: - [ ] `ci_build_report_results fk_rails_056d298d48 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_builds fk_befce0568a (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_builds_metadata fk_rails_ffcf702a02 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_daily_build_group_report_results fk_fd1858fefd (group_id) namespaces(id) ON DELETE CASCADE;` - [ ] `ci_daily_build_group_report_results fk_rails_0667f7608c (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_freeze_periods fk_2e02bbd1a6 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_group_variables fk_33ae4d58d8 (group_id) namespaces(id) ON DELETE CASCADE;` - [ ] `ci_job_artifacts fk_rails_9862d392f9 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_job_token_project_scope_links fk_rails_35f7f506ce (added_by_id) users(id) ON DELETE SET NULL;` - [ ] `ci_job_token_project_scope_links fk_rails_4b2ee3290b (source_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_job_token_project_scope_links fk_rails_6904b38465 (target_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_minutes_additional_packs fk_rails_e0e0c4e4b1 (namespace_id) namespaces(id) ON DELETE CASCADE;` - [ ] `ci_pending_builds fk_fdc0137e4a (namespace_id) namespaces(id) ON DELETE CASCADE;` - [ ] `ci_pending_builds fk_rails_480669c3b3 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_pipeline_artifacts fk_rails_4a70390ca6 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_pipelines fk_190998ef09 (external_pull_request_id) external_pull_requests(id) ON DELETE SET NULL;` - [ ] `ci_pipelines fk_86635dbd80 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_pipelines fk_a23be95014 (merge_request_id) merge_requests(id) ON DELETE CASCADE;` - [ ] `ci_pipeline_schedules fk_8ead60fcc4 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_pipeline_schedules fk_9ea99f58d2 (owner_id) users(id) ON DELETE SET NULL;` - [ ] `ci_project_monthly_usages fk_rails_508bcd4aa6 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_refs fk_rails_4249db8cc3 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_resource_groups fk_774722d144 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_runner_namespaces fk_rails_f9d9ed3308 (namespace_id) namespaces(id) ON DELETE CASCADE;` - [ ] `ci_runner_projects fk_4478a6f1e4 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_running_builds fk_rails_dc1d0801e8 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_sources_pipelines fk_1e53c97c0a (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_sources_pipelines fk_acd9737679 (source_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_sources_projects fk_rails_64b6855cbc (source_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_stages fk_2360681d1d (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_subscriptions_projects fk_rails_0818751483 (downstream_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_subscriptions_projects fk_rails_7871f9a97b (upstream_project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_triggers fk_e3e63f966e (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_triggers fk_e8e10d1964 (owner_id) users(id) ON DELETE CASCADE;` - [ ] `ci_unit_tests fk_7a8fabf0a8 (project_id) projects(id) ON DELETE CASCADE;` - [ ] `ci_variables fk_ada5eb64b3 (project_id) projects(id) ON DELETE CASCADE;` - [x] `clusters_applications_runners fk_02de2ded36 (runner_id) ci_runners(id) ON DELETE SET NULL;` - [ ] `dast_profiles_pipelines fk_a60cad829d (ci_pipeline_id) ci_pipelines(id) ON DELETE CASCADE;` - [ ] `dast_scanner_profiles_builds fk_e4c49200f8 (ci_build_id) ci_builds(id) ON DELETE CASCADE;` - [ ] `dast_site_profiles_builds fk_a325505e99 (ci_build_id) ci_builds(id) ON DELETE CASCADE;` - [ ] `dast_site_profiles_pipelines fk_53849b0ad5 (ci_pipeline_id) ci_pipelines(id) ON DELETE CASCADE;` - [ ] `merge_request_metrics fk_rails_33ae169d48 (pipeline_id) ci_pipelines(id) ON DELETE CASCADE;` - [ ] `merge_requests fk_fd82eae0b9 (head_pipeline_id) ci_pipelines(id) ON DELETE SET NULL;` - [ ] `merge_trains fk_rails_f90820cb08 (pipeline_id) ci_pipelines(id) ON DELETE SET NULL;` - [x] `pages_deployments fk_rails_c3a90cf29b (ci_build_id) ci_builds(id) ON DELETE SET NULL;` - [ ] `project_pages_metadata fk_69366a119e (artifacts_archive_id) ci_job_artifacts(id) ON DELETE SET NULL;` - [ ] `requirements_management_test_reports fk_rails_e67d085910 (build_id) ci_builds(id) ON DELETE SET NULL;` - [ ] `security_scans fk_rails_4ef1e6b4c6 (build_id) ci_builds(id) ON DELETE CASCADE;` - [ ] `vulnerability_feedback fk_rails_20976e6fd9 (pipeline_id) ci_pipelines(id) ON DELETE SET NULL;` - [ ] `vulnerability_occurrence_pipelines fk_rails_6421e35d7d (pipeline_id) ci_pipelines(id) ON DELETE CASCADE;` - [ ] `vulnerability_statistics fk_e8b13c928f (latest_pipeline_id) ci_pipelines(id) ON DELETE SET NULL;`