Repository navigation
Contracts docs: Database schema reference #441
Description
Write apps/backend/docs/contracts-database-schema.md documenting every table in db/schema.ts — users, wallets, conversations, conversationMembers, files, messages, messageEnvelopes, devices, devicePrekeys, tokenTransfers, treasuryProposals, proposalVotes, pushSubscriptions — with every column, type, default, index, and foreign-key relation.
Acceptance criteria:
- Every table has every column documented (name, type, nullability, default, constraint)
- Every index (including partial/unique) and every check constraint is documented with what it enforces and why
- Relations between tables (FKs, cascade behavior) are documented, ideally with a mermaid ER diagram
- Generated directly from the current schema file, then spot-checked against a real
pnpm db:generateoutput
Activity
SHEROSE0 commentedon Jul 29, 2026
@SHEROSE0 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @SHEROSE0 to this issue.
Fading-Dev commentedon Jul 29, 2026
@Godswillopeyemihub has applied to work on this issue as part of the Stellar Wave Program's 7th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Godswillopeyemihub to this issue.
drips-wave commentedon Jul 29, 2026
Congratulations, @Godswillopeyemihub! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.
🧑💻 @Godswillopeyemihub: 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 🌊
Benedict315 commentedon Aug 27, 2026
@Benedict315 has applied to work on this issue as part of the Stellar Wave Program's 8th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Benedict315 to this issue.
Horpeyehmi commentedon Aug 27, 2026
@Horpeyehmi has applied to work on this issue as part of the Stellar Wave Program's 8th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Horpeyehmi to this issue.
intelliDean commentedon Aug 27, 2026
@intelliDean has applied to work on this issue as part of the Stellar Wave Program's 8th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @intelliDean to this issue.
eischideraa-unn commentedon Sep 23, 2026
@eischideraa-unn has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @eischideraa-unn to this issue.
Dannyorji commentedon Sep 28, 2026
@Dannyorji has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Dannyorji to this issue.
drips-wave commentedon Sep 28, 2026
Congratulations, @Dannyorji! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on September 30, 2026.
🧑💻 @Dannyorji: 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 🌊
github-actions commentedon Oct 2, 2026
Closed by #615, merged into
dev.