Add Evaluation Data Storage to Projects Table Using JSONb #137
Description
Background
We need to enhance the projects table to store evaluation data for project assessments. This data needs to be persisted in a structured format using a JSONb field, allowing for flexible storage of evaluation metrics and results.
Requirements
-
Database Changes:
- Create a new migration file to add an
evaluationDataJSONb column to the projects table - The column should be nullable to maintain compatibility with existing records
- The JSONb field will store structured evaluation data including metrics, scores, and assessment results
- Create a new migration file to add an
-
Table Updates:
- Update the projects table definition in
/src/server/db/tables/projects.table.tsto include the new JSONb field - Ensure proper TypeScript typing for the new field
- Update the projects table definition in
-
TRPC Route Enhancement:
- Update the project creation route to handle evaluation data storage
- Add capability to save evaluation data during project creation process
- Maintain backwards compatibility for existing project creation flows
Expected Outcome
When implemented, the system will be able to:
- Store structured evaluation data alongside project information
- Persist evaluation results in a flexible JSONb format
- Save evaluation data automatically during project creation
- Maintain existing functionality while adding this new capability
The database structure will be updated to accommodate this new data storage requirement without breaking existing functionality or requiring data migration for existing records.
Technical Details
This implementation involves:
- Creating a new database migration
- Updating the projects table schema
- Enhancing the TRPC route for project creation
- Ensuring proper typing and validation for the new JSONb field
@jacob-ai-bot --skip-build