Add security_policy_id to compliance_framework_security_policies

What does this MR do and why?

This MR adds security_policy_id to compliance_framework_security_policies table to store the relationship between a security policy and a compliance framework. Currently, it is done through policy_index and policy_configuration_id but if there are multiple policy types using a same compliance framework, it will not store the link for all the policies.

➡️ 1️⃣ Add security_policy_id to compliance_framework_... (!185962 - merged)

2️⃣ Set security_policy_id to compliance_framework_... (!186019 - merged)

3️⃣ Update compliance framework graphql type to rea... (!186080 - closed)

4️⃣ Backfill security_policy_id in compliance_frame... (!186097 - merged)

References

• #481786 (closed)
• #524405 (closed)

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.