Draft: POC: Ignore `cluster_id` column in `deployments` table
What does this MR do and why?
The reference to deployments.cluster
is now delegated through the deployment_clusters
association table. This means that the cluster_id
column in the deployments
table is no longer needed and can be dropped.
As a first step in dropping the column, we need to ignore the cluster_id
in the code base first.
This column has one associated index (index_deployments_on_cluster_id_and_status
). However, we cannot drop this index without possibly causing problems due to an unindexed foreign key (see #402505 (comment 1596439811)). This column will be dropped following the guideline for dropping a column with a foreign key.
Screenshots or screen recordings
N/A
How to set up and validate locally
N/A
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #427386 (closed)