Can I vibe code Annex Cloud?

Build a lightweight, production-ready Customer Loyalty and Referral API using Node.js (TypeScript), Express, and PostgreSQL with Prisma ORM.

1. DATA MODEL:
- Customer: id, email, shopify_customer_id, current_points, total_earned_points, tier_id, referral_code, referred_by_id, created_at.
- LoyaltyLedger: id, customer_id, points_changed, reason (e.g. 'order_purchase', 'referral_bonus', 'redemption'), reference_id, created_at.
- RewardTier: id, name, min_spend_cents, point_multiplier.
- Referral: id, referrer_id, referee_id, status ('pending', 'completed'), order_id.

2. CORE API ENDPOINTS:
- POST /webhooks/shopify/orders-create: Parse paid Shopify orders. Verify webhook signature. Calculate points earned based on net spend (excluding tax/shipping) multiplied by customer's tier rate. Insert ledger entry and atomically increment Customer.current_points.
- POST /referrals/verify: Input referral code and new customer email. Ensure new customer is not referring themselves and has no prior orders. Assign referred_by_id.
- POST /webhooks/shopify/orders-fulfilled: If order belongs to a referred customer on their first purchase, credit referrer with 500 points and set Referral status to 'completed'.
- POST /rewards/redeem: Customer requests a $10 discount code for 1000 points. Check atomic point balance. Deduct points, write ledger entry, call Shopify Admin REST API to generate a single-use price rule discount code, and return code to client.

3. FRAUD & EDGE CASES:
- Wrap all point adjustments in SQL transactions with row-level locks (SELECT FOR UPDATE) to prevent race conditions.
- Handle order refunds via /webhooks/shopify/refunds-create to claw back points. If balance drops below zero, allow negative balance but prevent reward redemption.

4. OUT OF SCOPE:
- Offline POS syncing, complex UI admin panel, physical receipt scanning.

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