VROOM_SSJUNN
Tables (5)
MEMBERS
- user_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- balance — DECIMAL(15,2)
- avail_balance — DECIMAL(15,2)
- real_account — VARCHAR(50)
- joined_at — TIMESTAMP
- updated_at — TIMESTAMP
PARTNERS
- id — BIGINT
- partner_name — VARCHAR(50) — NOT NULL
- client_id — VARCHAR(100) — NOT NULL
- api_key — VARCHAR(100) — NOT NULL
- is_active — CHAR(1)
- created_at — TIMESTAMP
PAYMENT_ORDERS
- id — BIGINT
- amount — DECIMAL(15,2) — NOT NULL
- status — ENUM('INIT', 'PENDING', 'COMPLETED', 'CANCELED')
- errands_id — BIGINT
- user_id — BIGINT — Foreign key → MEMBERS.user_id
- errander_id — BIGINT — Foreign key → MEMBERS.user_id
- created_at — TIMESTAMP
- paid_at — TIMESTAMP
PG_PAYMENT_LOGS
- log_id — BIGINT
- imp_uid — VARCHAR(100) — NOT NULL
- merchant_uid — VARCHAR(100)
- pg_provider — VARCHAR(20)
- amount — DECIMAL(15,2)
- status — VARCHAR(20)
- raw_response — TEXT
- created_at — TIMESTAMP
WALLET_TRANSACTIONS
- id — BIGINT
- txn_type — ENUM('CHARGE', 'HOLD', 'RELEASE', 'PAYOUT', 'WITHDRAW', 'REFUND') — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- balance_snapshot — DECIMAL(15,2)
- memo — TEXT
- created_at — TIMESTAMP
- user_id — BIGINT — Foreign key → MEMBERS.user_id — NOT NULL
- pg_log_id — BIGINT — Foreign key → PG_PAYMENT_LOGS.log_id