Add missing enum values to trading schema and refactor price_alerts table
structure to align with backend types. Addresses DDL gaps from analysis.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Document current TIMESTAMPTZ compliance across all schemas
- Create comprehensive migration template for future use
- Include validation queries and best practices
- Add examples for different timezone scenarios
- Added deleted_at and deleted_by columns for soft delete functionality
- Created migration 002-add_course_reviews_soft_delete.sql
- Added indexes for efficient active reviews queries
- Updated DDL schema definition with new columns and comments
- Gap: GAP-010
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Create migration 2026-02-03_add_auth_locked_index.sql
- Add partial index on locked_until with active lockout condition
- Replace previous generic locked_until index with optimized version
- Index filters for locked_until IS NOT NULL AND locked_until > NOW()
- Improves query performance for account unlock validation
- Resolves GAP-009
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
ST-3.1: Course tags system
- education.course_tags with slug, color, featured flag
- education.course_tag_assignments (M:N) with auto usage_count
- Seeds: 10 initial tags (forex, crypto, ICT, etc.)
ST-3.2: Drawing tools for charts
- Enum: trading.drawing_tool_type (18 types including ICT)
- trading.drawing_tools with JSONB points and styles
- trading.drawing_templates for reusable presets
ST-3.3: Complete agent_executions
- Added 10 columns: execution_time_ms, slippage, risk_score, etc.
- 5 new performance indexes
- Trigger for updated_at
ST-3.4: ML composite indexes
- 8 new composite/partial indexes for predictions
- Optimized for symbol+timeframe+date queries
- Partial indexes for high confidence and overlay display
New files: 7 DDL, 2 migrations, 1 seed
Modified: 3 existing DDL files
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Created feature_flags schema with:
- flags table: Global feature flag definitions
- user_flags table: User-level overrides
- evaluations table: Evaluation history for analytics
- evaluate_flag() function: PL/pgSQL evaluation with priorities
Features:
- Percentage-based rollout
- User override support
- Targeting rules (plan, role)
- Expiration support
- Initial flags for trading platform
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Created table to track user votes on course reviews:
- education.review_helpful_votes
- Constraint: one vote per user per review
- Indexes on user_id and review_id
This table supports the "mark as helpful" feature in course reviews.
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Added portfolio schema to 01-schemas.sql
- Created enums: risk_profile, goal_status, rebalance_action, allocation_status
- Created tables: portfolios, portfolio_allocations, portfolio_goals
- Created tables: rebalance_history, portfolio_snapshots
- Added triggers for updated_at and goal progress calculations
- Added indexes for performance
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
- Add auth.notifications table for storing user notifications
- Add auth.user_push_tokens table for FCM/APNs tokens
- Add investment.distribution_history for daily distribution records
- Add investment.distribution_runs for job execution logs
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
DDL schemas for Trading Platform:
- User management
- Authentication
- Payments
- Education
- ML predictions
- Trading data
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
