Backend & Referral System Build
Budget: ₹600 – ₹1,500 INR
I need a clean, scalable backend drafted from scratch, starting with a solid PostgreSQL schema. The heart of the project is a referral module that pays out cash rewards when invitees convert, so the data model, triggers, and calculation logic must revolve around that requirement.
Here’s what I’m expecting:
• Database design in PostgreSQL, including all DDL scripts and a concise ER diagram.
• Core API endpoints (or documented stored procedures) that record a referral, verify the qualifying event, and trigger the cash-reward payout.
• Clear unit or integration tests demonstrating the reward rules in action.
While tracking links or status updates are not mandatory right now, structure the tables so those features can slot in later without rewrites. Hand-over will be complete when I can spin up the database, hit the endpoints, and see a cash reward logged against a referee’s account.
Here’s what I’m expecting:
• Database design in PostgreSQL, including all DDL scripts and a concise ER diagram.
• Core API endpoints (or documented stored procedures) that record a referral, verify the qualifying event, and trigger the cash-reward payout.
• Clear unit or integration tests demonstrating the reward rules in action.
While tracking links or status updates are not mandatory right now, structure the tables so those features can slot in later without rewrites. Hand-over will be complete when I can spin up the database, hit the endpoints, and see a cash reward logged against a referee’s account.