Add references FKs to p_ci_job_artifacts

Ref: #439028 (closed)

What does this MR do and why?

Following up !145111 (merged) where we validated those FKs for self-managed.

This MR renames our temporary FKs and drop old ones to make sure they point to the new the routing table p_ci_job_artifacts.

Why are we doing this?

Remaining step to clean make sure the routing table matches the original table that we partition.

https://docs.gitlab.com/ee/development/database/partitioning/list.html#step-7---re-point-foreign-keys-to-parent-table