Design Portfolio Data Model & Database Schema

[grantfox-oss]

Description:
Design and implement the portfolio data model including tables for portfolios, holdings, transactions, performance metrics, and allocation tracking. Ensure schema supports multi-chain assets and complex structures.

Acceptance Criteria:

• Portfolio table with metadata (name, type, description, created_at, updated_at)
• Holdings table with asset information (symbol, chain, quantity, cost_basis, current_value)
• Transaction history table (type, date, amount, price, fees, chain)
• Portfolio metrics table (total_value, ROI, allocation)
• Performance history for backtesting (daily snapshots)
• Soft delete support for portfolios and holdings
• Indexes on frequently queried columns
• Database migrations using TypeORM

Definition of Done:

• Schema reviewed and approved
• All tables created with migrations
• Relationships properly defined
• Performance: queries execute in < 100ms for typical portfolio

Test Requirements:

• Migration test
• Schema validation test
• Query performance test

---

[dorisadams]

I would love to work on this issue, please assign the issues to me so i Can work on it ASAP

[michaelvic123]

I’d love to work on this issue. I’m a full-stack developer with experience building and maintaining web applications across both frontend and backend technologies. The issue looks interesting, and I’m confident I can contribute a solid solution.

[grantfox-oss]

🦊 GrantFox — @michaelvic123 has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #28)
2. Your PR will be reviewed by the SourceXXL maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign campaign!

@michaelvic123's PR #44 was approved and merged by @memplethee-lab.

🏆 @michaelvic123: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (723 total points). Track your full progress on GrantFox.

👏 Great work, @michaelvic123! Keep contributing to SourceXXL.