| id |
int(11)
|
|
|
|
| order_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(11)
|
|
|
 浏览不相关的值
|
| total_amount |
decimal(10,2)
|
|
|
|
| packaging_fee |
decimal(10,2)
|
|
|
|
| commission |
decimal(10,2)
|
|
|
|
| shipping_fee |
decimal(10,2)
|
|
|
|
| status |
int(11)
|
|
|
|
| name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| address |
text
|
utf8mb4_unicode_ci
|
|
|
| province |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| city |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| express_company |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
| product_details |
text
|
utf8mb4_unicode_ci
|
|
|
| expired_at |
datetime
|
|
|
|
| paid_at |
datetime
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| payment_method |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| original_total |
decimal(10,2)
|
|
|
|
| adjustment_status |
tinyint(4)
|
|
|
|
| order_source |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| order_quantity |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
