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