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)