Skip to content

Draft: POC: Ignore `cluster_id` column in `deployments` table

Pam Artiaga requested to merge 427386-ignore-deployments-cluster_id into master

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.

Related to #427386 (closed)

Edited by Pam Artiaga

Merge request reports