| id |
bigint(20)
|
|
|
|
| topup_no |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| customer_user_id |
int(10)
|
|
|
|
| wallet_id |
bigint(20)
|
|
|
|
| amount |
decimal(15,2)
|
|
|
|
| fee_amount |
decimal(15,2)
|
|
|
|
| net_amount |
decimal(15,2)
|
|
|
|
| payment_method |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| provider |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| provider_transaction_id |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| provider_reference |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| qr_payload |
text
|
utf8mb4_unicode_ci
|
|
|
| qr_expires_at |
datetime
|
|
|
|
| status |
enum('pending', 'paid', 'expired', 'failed', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| paid_at |
datetime
|
|
|
|
| expired_at |
datetime
|
|
|
|
| failed_at |
datetime
|
|
|
|
| request_ip |
varchar(64)
|
utf8mb4_unicode_ci
|
|
|
| user_agent |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
