Swapping bigint column for deployments

We need to first merge: Adding duplicate FK to deployments (!221759 - merged)

And then merge another MR Validating FKs that reference deployment bigint (!222511 - merged) that creates the FK sync

What does this MR do and why?

Swapping bigint column for deployments

This MR is phase one for deployment bigint migration. We swap both id and environment_id columns here, along with the associated indexes and FK.

First we validate the FK sync for SM and local environments. Then we swap/rename the columns, indexes and FKs And lastly we drop the swapped (old) indexes and FKs

Changelog: changed

References

Screenshots or screen recordings

Before	After

How to set up and validate locally

MR acceptance checklist

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

Related to #581422 (closed)