Can I vibe code Antavo?

Build a scalable, robust Loyalty Engine API in Node.js (TypeScript) using PostgreSQL and Prisma ORM.

1. DATA MODEL:
- Customer (id, email, external_customer_id, created_at)
- LoyaltyAccount (id, customer_id, current_points_balance, lifetime_points, current_tier_id)
- Tier (id, name, minimum_spend, point_multiplier, created_at)
- PointLedger (id, account_id, amount, transaction_type [EARN, REDEEM, EXPIRE, REFUND], reference_id, metadata JSONB, created_at)
- Reward (id, title, point_cost, reward_type [DISCOUNT_CODE, GIFT_ITEM], payload JSONB)

2. CORE API ENDPOINTS:
- POST /api/loyalty/events: Accepts Webhook events (order_created, order_refunded, user_signup). Process points dynamically. 1 USD spent = 1 point * tier_multiplier. Ensure idempotency using reference_id.
- POST /api/loyalty/redeem: Atomic transaction deducting points for a chosen Reward ID. Return a generated unique discount code if valid.
- GET /api/loyalty/account/:id: Return current points, active tier, and history ledger.

3. FAILURE MODES & CONCURRENCY:
- Use database row-level locking (SELECT FOR UPDATE) on LoyaltyAccount during redemptions to prevent negative balances or race conditions.
- Handle partial order refunds by writing a negative EARN ledger entry and adjusting lifetime points accordingly.

4. OUT OF SCOPE:
- Do not build a front-end UI; restrict to pure REST API with JSON responses. Exclude physical POS integrations.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs