order 字段统计订单
精确行数与字段画像 · 估算行数 40 · 主键 id
类型分布
字段可空与键位
| 字段 | 类型 | 键 | 可空 | 注释 |
| id | bigint | PRI | NO | |
| order_no | varchar | UNI | NO | 订单号(对齐官网 yjgw.orders.order_no 长度) |
| tenant_id | bigint | — | NO | |
| user_id | bigint | MUL | YES | |
| merchant_id | bigint | MUL | YES | |
| 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 | |
| official_order_id | char | UNI | YES | yjgw.orders.id 镜像来源 |
相关
返回全景目录