| Field Name | Primary key or not | Field Type | Number of bytes occupied | Whether empty is allowed | Description |
| order_id | Y | int | 11 |
| Order id |
| order_no |
| int | 11 |
| Order Number |
| total_price |
| varchar | 255 |
| Total price |
| order_price |
| decimal | 10 |
| Order Price |
| coupon_id |
| varchar | 100 |
| Coupon id |
| coupon_money |
| decimal | 10 |
| Preferential prices |
| line_price |
| int | 10 |
| Product Line Price |
| quantity |
| int | 11 |
| Number of products |
| goods_id |
| int | 11 |
| Product id |
| goods_no |
| varchar | 100 |
| Item number |