temp

Tables (18)

Admins

  • id — NUMBER
  • user_id — NUMBER

Customers

  • id — NUMBER
  • user_id — NUMBER

DepositTokens

  • id — NUMBER
  • wallet_id — NUMBER
  • amount — NUMBER(18,2)
  • issued_at — TIMESTAMP

Events

  • id — NUMBER
  • title — VARCHAR2(255)
  • body — CLOB
  • start_at — TIMESTAMP
  • end_at — TIMESTAMP
  • reward — CLOB
  • type — VARCHAR2(20)

Inquiries

  • id — NUMBER
  • user_id — NUMBER
  • title — VARCHAR2(255)
  • content — CLOB
  • status — VARCHAR2(20)
  • created_at — TIMESTAMP

Logs

  • id — NUMBER
  • user_id — NUMBER
  • type — VARCHAR2(50)
  • action — CLOB
  • timestamp — TIMESTAMP

Merchants

  • id — NUMBER
  • user_id — NUMBER
  • biz_reg_no — VARCHAR2(30) — NOT NULL

Notices

  • id — NUMBER
  • title — VARCHAR2(255)
  • content — CLOB
  • created_at — TIMESTAMP

Notifications

  • id — NUMBER
  • user_id — NUMBER
  • message — CLOB
  • is_read — CHAR(1)
  • created_at — TIMESTAMP

QrPayments

  • id — NUMBER
  • from_wallet_id — NUMBER
  • to_store_id — NUMBER
  • amount — NUMBER(18,2)
  • scanned_by_user_id — NUMBER
  • created_at — TIMESTAMP

StoreSettlements

  • id — NUMBER
  • store_id — NUMBER
  • voucher_id — NUMBER
  • balance — NUMBER(18,2)
  • last_updated — TIMESTAMP

Stores

  • id — NUMBER
  • merchant_id — NUMBER
  • name — VARCHAR2(255)
  • region — VARCHAR2(50)
  • category — VARCHAR2(50)
  • brand — VARCHAR2(50)

TokenTx

  • id — NUMBER
  • token_id — NUMBER
  • from_wallet — NUMBER
  • to_wallet — NUMBER
  • amount — NUMBER(18,2)
  • timestamp — TIMESTAMP

Users

  • id — NUMBER
  • email — VARCHAR2(255) — NOT NULL
  • phone — VARCHAR2(20)
  • password — VARCHAR2(255)
  • type — VARCHAR2(20)
  • ADMIN)) — NOT — NOT NULL
  • status — VARCHAR2(20)
  • push_enabled — CHAR(1)
  • created_at — TIMESTAMP

VoucherFavorites

  • id — NUMBER
  • user_id — NUMBER
  • voucher_id — NUMBER
  • created_at — TIMESTAMP

VoucherTx

  • id — NUMBER
  • voucher_id — NUMBER
  • from_user — NUMBER
  • to_merchant — NUMBER
  • amount — NUMBER(18,2)
  • timestamp — TIMESTAMP

Vouchers

  • id — NUMBER
  • title — VARCHAR2(255)
  • balance — NUMBER(18,2)
  • expiry — DATE
  • status — VARCHAR2(20)

Wallets

  • id — NUMBER
  • user_id — NUMBER
  • balance — NUMBER(18,2)