Refactor Relationship Logic to Eliminate Relationship Table Dependency

Task

We need to refactor our codebase to eliminate the relationship table and rely solely on the field table for loading relationships. The current architecture using the relationship table creates potential failure points during content type updates. This will be implemented as a gradual change to avoid disrupting existing functionality until we can fully remove the table.

Proposed Objective

Please Select

Proposed Priority

Please Select

Acceptance Criteria

1. Identify all code paths that currently read from the relationship table
2. Create new methods that obtain the same relationship data from the field table
3. Implement feature flags to toggle between old and new implementations if needed
4. Add comprehensive tests comparing data retrieved via both methods
5. Create a migration plan for gradually deprecating the relationship table

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

Start by locating every code path that reads from the relationship table and trace how the field table represents the same relationship data. Compare both retrieval approaches with comprehensive tests, then document the feature-flag rollout and migration plan needed to deprecate the relationship table.