chihlasm/resolutionflow
1
0
Fork 0
Code Issues 23 Pull Requests 1 Actions Packages Projects Releases Wiki Activity

Step Library - database schema and migrations #6

New Issue
Closed
opened 2026-02-03 04:40:59 +00:00 by chihlasm · 1 comment
chihlasm commented 2026-02-03 04:40:59 +00:00 (Migrated from github.com)
Copy Link

Create step_library table for reusable troubleshooting steps:

  • Create Alembic migration
  • Add SQLAlchemy model with fields: title, step_type, content (JSONB), visibility, category_id, tags, ratings aggregates
  • Add indexes for search and filtering
  • Add step_ratings table for user ratings/reviews
  • Add step_usage_log table for "Verified Use" tracking

Reference: PHASE-2.5-PERSONAL-BRANCHING.md

Create step_library table for reusable troubleshooting steps: - [ ] Create Alembic migration - [ ] Add SQLAlchemy model with fields: title, step_type, content (JSONB), visibility, category_id, tags, ratings aggregates - [ ] Add indexes for search and filtering - [ ] Add step_ratings table for user ratings/reviews - [ ] Add step_usage_log table for "Verified Use" tracking Reference: PHASE-2.5-PERSONAL-BRANCHING.md
chihlasm commented 2026-02-03 07:05:49 +00:00 (Migrated from github.com)
Copy Link

Completed in PR #24. Implemented:

  • Migration 008 with step_library, step_ratings, step_usage_log tables
  • StepLibrary model with JSONB content, visibility levels (private/team/public), tags array
  • StepRating model with 1-5 star rating, helpful flag, verified use tracking
  • StepUsageLog model for tracking step usage in sessions
  • Full-text search index on title
Completed in PR #24. Implemented: - Migration 008 with step_library, step_ratings, step_usage_log tables - StepLibrary model with JSONB content, visibility levels (private/team/public), tags array - StepRating model with 1-5 star rating, helpful flag, verified use tracking - StepUsageLog model for tracking step usage in sessions - Full-text search index on title
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
10x-analysis
From 10x product analysis
 backend
FastAPI/Python work
 bug
Something isn't working
 collaboration
Team sharing, escalation, notifications
 database
PostgreSQL/schema changes
 documentation
Documentation updates
 duplicate
This issue or pull request already exists
 enhancement
Improvement to existing feature
 feature
New functionality
 frontend
React work
 good first issue
Good for newcomers
 help wanted
Extra attention is needed
 integration
PSA, external service integrations
 intelligence
Analytics, AI, data-driven features
 invalid
This doesn't seem right
 priority: high
Do this soon
 priority: low
Nice to have
 priority: medium
Important but not urgent
 question
Further information is requested
 quick-win
Low effort, high value
 strategic
Long-term strategic bet
 ux
User experience improvements
 wontfix
This will not be worked on
No Label backend database feature priority: high
Milestone
No items
No Milestone Phase 2.5
Projects
Clear projects
No project
Assignees
Clear assignees
chihlasm
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: chihlasm/resolutionflow#6
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?