Add readiness_score column to work_item_agent_plans

Naman Jagdish Galarequested to merge
duo/feature/611320-workplan-readiness-score-backend into master

What does this MR do and why?

Adds a nullable integer readiness_score column (range 0-100) to the work_item_agent_plans table. This is the storage layer for the work plan readiness score, which signals how ready an AI-generated work plan is for an agent to act on.

  • null means the score is not yet available (written by an external/agent process)
  • 0-100 integer range enforced by model validation
  • No computation logic — storage only

This is MR 1 of 2 for #611320 (closed). MR 2 (stacked on this) will expose the score via GraphQL.

References

Screenshots or screen recordings

N/A — backend-only change.

How to set up and validate locally

  1. Run the migration: bundle exec rails db:migrate
  2. In rails console, verify the column and validation work as expected.

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.

Merge request reports