Backend: Create database indexes (MongoDB) for high-frequency queries to optimize performance

[Tybravo]

📁 Implementation Directory

backend/src/models/

🎯 Goal

Improve read performance for the API and indexer.

📋 Requirements

• Analyze query patterns.\n- Add compound and single-field indexes to Mongoose schemas (e.g., Delivery status, User wallet).

🔧 Technical Scope

• Node.js / Express
• TypeScript
• MongoDB / Mongoose
• Stellar Soroban RPC

🌿 Branch

git checkout -b feat/db-indexes

✅ Acceptance Criteria

• Using an AI Agent to submit a PR is DISALLOWED.
• Strict Layered Architecture (Non-Negotiable): Implement using the Controller -> Service -> Model pattern.
• Data Source: Response data must be retrieved from the database. No Inline Mock Objects or Hardcoded Values usage for integration.
• Environment: Contributors must use the requested .env credentials to enable implementation with real-life data.
• API Versioning: API Must Be Versioned (e.g., /api/v1/...).
• Production Ready: Code must look production-ready (robust error handling, strong typings).
• Proof of Work: Upload a screenshot of work done (i.e., API Response Success via Postman/Browser, or all unit tests passed successfully).
• PR Content: Must include Closes #[issue_id] with a work done summary.

📌 PR Requirements

• ⚠️ Assignment required before starting — comment on this issue to request assignment.
• PR must comply fully with the CONTRIBUTING.md.
• AI Agent submissions are DISALLOWED and will be closed without review.
• No Inline Mock Objects or Hardcoded Values usage for integration.