| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| total_amount |
decimal(10,2)
|
|
|
|
| currency |
char(3)
|
utf8mb4_unicode_ci
|
|
|
| payment_method |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| gateway_name |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| gateway_payment_id |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| payment_status |
varchar(40)
|
utf8mb4_unicode_ci
|
|
|
| gateway_status |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| payment_verified |
tinyint(1)
|
|
|
|
| payment_ref |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| payment_session_token |
varchar(96)
|
utf8mb4_unicode_ci
|
|
|
| paid_at |
timestamp
|
|
|
|
| payment_attempted_at |
timestamp
|
|
|
|
| payment_verified_at |
timestamp
|
|
|
|
| reviewed_at |
timestamp
|
|
|
|
| reviewed_by_admin_id |
int(11)
|
|
|
|
| buyer_ip |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| buyer_visitor_key |
varchar(96)
|
utf8mb4_unicode_ci
|
|
|
| payment_payload_json |
longtext
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
