What's pending across every project
4 open · sorted by priority then due-date
Filtered by tag schema clear
todo
high
Migration 0028: walk-in user schema (nullable phone + user_upi_handles)
Per BRD v1 §7.3 + Appendix B.\n\n- ALTER users ALTER COLUMN phone_number DROP NOT NULL\n- Recreate phone UNIQUE as partial index (WHERE phone_number IS NOT NULL)\n- CREATE TABLE user_upi_handles (per WIP schema in #51)\n- Register 'upi_walkin' as an accepted auth_provider value (no enum in Postgres — code-side check only)\n\nDoes NOT touch existing wallets/ledger/sessions/reservations tables.\n\nBlocked on TDD lock (#50).</body>
Vajra Volt Mobile App
· vajra-mobile-app
· by saravanan@scrumclaw.ai
6d ago
08-02 11:52
08-02 11:52
todo
high
Migration 0029: charger_qr_codes table
Per BRD v1 §7.1 FR3.\n\nCREATE TABLE charger_qr_codes (\n id UUID PK,\n charger_id VARCHAR(50) NOT NULL,\n connector_id INT NOT NULL,\n razorpay_qr_id VARCHAR(100) UNIQUE NOT NULL,\n razorpay_qr_short_url TEXT,\n razorpay_qr_image_url TEXT,\n status VARCHAR(20) NOT NULL DEFAULT 'active',\n created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),\n UNIQUE (charger_id, connector_id)\n);\n\nBlocked on TDD lock (#50).</body>
Vajra Volt Mobile App
· vajra-mobile-app
· by saravanan@scrumclaw.ai
6d ago
08-02 11:52
08-02 11:52
todo
Migration 0030: session_code column on charging_sessions
Per BRD v1 §7.6 FR26 — for phone-less walk-in recovery.\n\nALTER TABLE charging_sessions ADD COLUMN session_code VARCHAR(10);\nCREATE UNIQUE INDEX charging_sessions_session_code_idx ON charging_sessions (session_code) WHERE session_code IS NOT NULL;\n\nOnly populated for walk-in sessions where contact is missing. Short human-readable code (e.g. V-4F2A9) customer can quote to support.\n\nBlocked on TDD lock (#50).</body>
Vajra Volt Mobile App
· vajra-mobile-app
· by saravanan@scrumclaw.ai
6d ago
08-02 11:52
08-02 11:52
note
low
WIP walk-in user schema (from initial design — NOT locked)
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
8d ago
07-31 03:24
07-31 03:24