Claude Project Tracker

Snapshot of the initial ad-hoc design so it isn't lost during the BRD/TDD process. May be revised or discarded. **Users table change:** - ALTER users ALTER COLUMN phone_number DROP NOT NULL - Recreate UNIQUE index as partial (WHERE phone_number IS NOT NULL) so multiple NULLs are allowed - New auth_provider value: 'upi_walkin' **New table user_upi_handles** — many VPAs per user, source-tagged: id UUID PK, user_id UUID FK, vpa VARCHAR(100), first_seen_at, last_seen_at, payment_count INT, source VARCHAR(30), is_primary BOOL, UNIQUE(user_id, vpa), INDEX on LOWER(vpa) **Match priority (webhook → user):** phone (contact) → email → vpa → else create walk-in **Repository additions:** UserRepository.GetByVPA(vpa) UserRepository.InsertUPIHandle(userID, vpa, source, primary) UserRepository.TouchUPIHandle(userID, vpa) **Auth claim flow (later):** OTP login on existing walk-in phone → attach, don't duplicate Flip auth_provider from 'upi_walkin' → 'password' Wallet balance + history preserved This design has open gaps around amount UX, plug/pay order, session termination, and failure handling — see the BRD-vs-design review todo.</body>

Vajra Volt Mobile App · vajra-mobile-app · by saravanan@scrumclaw.ai