| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| order_no | varchar | UNI | NO | |
| tenant_id | bigint | NO | ||
| user_id | bigint | MUL | NO | |
| merchant_id | bigint | MUL | NO | |
| store_id | bigint | YES | O2O自提门店 | |
| coupon_id | bigint | YES | 优惠券ID | |
| discount_amount | decimal | NO | 优惠金额 | |
| source | varchar | YES | H5/POS/ERP/AGENT | |
| total_amount | decimal | NO | ||
| pay_amount | decimal | NO | ||
| freight | decimal | YES | ||
| status | varchar | YES | CREATED已下单/PAID已支付/DELIVERED已发货/COMPLETED已完成/CANCELLED已取消 | |
| pay_type | varchar | YES | WECHAT/ALIPAY/WALLET | |
| pay_time | datetime | YES | ||
| receiver_name | varchar | YES | ||
| receiver_phone | varchar | YES | ||
| receiver_address | varchar | YES | ||
| distributor_id | bigint | MUL | YES | 成交分销员 |
| commission_amount | decimal | YES | ||
| remark | text | YES | ||
| created_at | datetime | YES |