Initialize Prisma Schema for the Fastify Indexer

[AlAfiz]

Description

The backend needs its relational schema defined so it can properly index the events emitted by the Soroban payout registry.

Acceptance Criteria

• Initialize Prisma in packages/backend (npx prisma init).
• Define Organization model (id, adminAddress, name, totalBudget).
• Define Maintainer model (address, totalEarned).
• Define PayoutEvent model (txHash, orgId, maintainerAddress, amount, type: 'ALLOCATED' | 'CLAIMED', timestamp).
• Generate the Prisma client and run the initial migration.

Technical Details

• Map the totalBudget and amount fields to Strings or BigInts in Postgres to prevent JavaScript from rounding large Stroop values.

[faith3310]

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

good day maintainer,i would love to handle this issue

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

[Husten150]

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

i would like to work on these

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

[drips-wave]

Congratulations, @Husten150! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on April 29, 2026.

🧑‍💻 @Husten150: 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 🌊