1DELETE FROM project_repositories
 2WHERE project_id NOT IN (SELECT id FROM projects);
 3
 4ALTER TABLE project_repositories
 5    ADD CONSTRAINT fk_project_repositories_project_id
 6        FOREIGN KEY (project_id)
 7        REFERENCES projects (id)
 8        ON DELETE CASCADE
 9        NOT VALID;
10
11ALTER TABLE project_repositories
12    VALIDATE CONSTRAINT fk_project_repositories_project_id;
13
14DELETE FROM project_repository_statuses
15WHERE project_id NOT IN (SELECT id FROM projects);
16
17ALTER TABLE project_repository_statuses
18    ADD CONSTRAINT fk_project_repository_statuses_project_id
19        FOREIGN KEY (project_id)
20        REFERENCES projects (id)
21        ON DELETE CASCADE
22        NOT VALID;
23
24ALTER TABLE project_repository_statuses
25    VALIDATE CONSTRAINT fk_project_repository_statuses_project_id;