Prisma and Database

Prisma setup

• Prisma schema: backend/prisma/schema.prisma.
• Prisma client wrapper: backend/src/Infrastructure/Repositories/Prisma/PrismaClient.ts.
• DB provider: PostgreSQL via @prisma/adapter-pg.

Data model highlights

• Users, wallets, categories, transactions, budgets.
• Join tables for wallet membership and budget membership.
• Allocation model links budgets, members, and transactions.

Repository implementations

• backend/src/Infrastructure/Repositories/Prisma/UserRepositoryImpl.ts
• backend/src/Infrastructure/Repositories/Prisma/WalletRepositoryImpl.ts
• backend/src/Infrastructure/Repositories/Prisma/CategoryRepositoryImpl.ts
• backend/src/Infrastructure/Repositories/Prisma/TransactionRepositoryImpl.ts
• backend/src/Infrastructure/Repositories/Prisma/BudgetRepositoryImpl.ts
• backend/src/Infrastructure/Repositories/Prisma/BudgetAllocationRepositoryImpl.ts

Migration and startup commands

pnpm prisma migrate deploy
pnpm dev

Production startup includes migrations before serving (pnpm start).