order订单
交易与商城域的实体表,23 个字段 · 主键 id · 外键候选 3 个
字段结构
| 字段 | 类型 | 键 | 可空 | 注释 |
| 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 镜像来源 |
同域接口
相关角色
所属域
返回全景目录