|
id
|
bigint(20) unsigned
|
|
|
|
|
order_id
|
varchar(64)
|
|
|
|
|
order_no
|
varchar(32)
|
|
|
|
|
player_id
|
varchar(64)
|
|
|
|
|
app_id
|
int(11)
|
|
|
|
|
game
|
varchar(64)
|
|
|
|
|
item_id
|
int(11)
|
|
|
|
|
product_code
|
varchar(16)
|
|
|
|
|
product_name
|
varchar(255)
|
|
|
|
|
quantity
|
int(11)
|
|
|
1
|
|
unit_price
|
decimal(10,2)
|
|
|
0.00
|
|
total_amount
|
decimal(10,2)
|
|
|
0.00
|
|
total_items
|
int(11)
|
|
|
0
|
|
status
|
varchar(16)
|
|
|
pending
|
|
payment_method
|
varchar(32)
|
|
|
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_email
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(32)
|
|
|
|
|
ip_address
|
varchar(45)
|
|
|
|
|
user_agent
|
varchar(512)
|
|
|
|
|
api_key_id
|
int(10) unsigned
|
|
|
|
|
error_message
|
text
|
|
|
|
|
completed_at
|
datetime
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|