Subtitle: How to model a secure, escrow-based marketplace for emerging economies using Prisma and PostgreSQL. Schema. In my previous article on Medium, I discussed the sociotechnical challenge of Information Poverty in the African gig economy. But as engineers, we know that solving social problems requires more than vision it requires a robust, type-safe, and scalable data architecture. For LocalHands, I chose Prisma ORM with PostgreSQL. The goal was to build a "Technical Source of Truth" that could handle the complexity of service listings, competitive bidding (proposals), and secure escrow payments. Below, I break down the core relational logic of the LocalHands schema 1. The Core Actor Model: User vs. Profile In a marketplace, users often play multiple roles. However, security is paramount.…