Define Streams database schema

[pragmaticAweds]

Repository

This issue belongs in Fundable-Protocol/Backend under indexer/.

Migrated from Fundable-Protocol/stellar_indexer#13.

Context

The streams domain needs database tables before stream event handlers and API resolvers can persist/query data.

Scope

• Define Stream table
• Define WithdrawalAction table
• Define CancelAction table
• Add migrations and indexes for common queries
• Represent token amounts without floating-point precision loss

Out of Scope

• Unrelated package work
• Docker, CI, or deployment work unless named in scope
• Broad refactors outside the touched package

Acceptance Criteria

• Scope items are complete
• Relevant tests are added or updated
• Documentation is updated when needed
• bun run type-check passes
• bun run test passes
• bun run lint passes
• bun run indexer:type-check passes
• bun run indexer:test passes
• bun run indexer:lint passes

Dependencies

• Add database dependency and migration tooling #20
• Create indexed events idempotency table #25

Suggested Files or Packages

• indexer/streams/
• indexer/common/src/db/
• migration files

[Properprogress1]

@Properprogress1 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Let me quickly work on this and will deliver within 6hrs

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Properprogress1 to this issue.

[ayomideadeniran]

@ayomideadeniran has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I'm a full-stack developer and I'd like to take this issue.
I understand the requirements and will follow the existing project structure, keep the implementation clean, and include proper tests where applicable.

ETA: 1–3 days (depending on scope)

ℹ️ Repo Maintainers: To accept this application, review their application or assign @ayomideadeniran to this issue.

[drips-wave]

Congratulations, @ayomideadeniran! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @ayomideadeniran: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[drips-wave]

This issue has been completed by @ayomideadeniran as part of the Stellar Wave Program's 6th Wave 🥳

😎 @ayomideadeniran: You earned 400 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.