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