Drop the foreign key constraint from detached partitions

What does this MR do and why?

Some of the batched background migrations fail due to an issue related to partition management logic when the pipeline runs while moving from one month to another(e.g. April to May).

See gitlab-org/quality/engineering-productivity/master-broken-incidents#12512 (comment 2481372699) for more details.