DB migrations to introduce organization_cluster_agent_mappings table and associated model

MR: add migrations and models for org level agent auth (!179604 - merged)

Description

We would need to create a new table to keep track of organizational cluster-agent mappings.

Proposed name: organization_cluster_agent_mappings Proposed Columns: id, created_at, updated_at, organization_id, cluster_agent_id, creator_id

This table will have a foreign-key constraint referencing the cluster_agents table. This table will have the sharding key be the organization_id

This table should have the combination of organization_id and cluster_agent_id as unique

Acceptance Criteria

• Introduce a migration creating the table with the above schema and constraints
• Generate the appropriate model to support the created table
• Ensure we use if_exists / if_not_exists

Technical Requirements

Design Requirements

Impact Assessment

User Story