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