wm_order_discounts
表 · 12 字段
微盟订单优惠明细表
字段信息
| 字段名 | 类型 | 必填 | 说明 | 关联关系 |
|---|---|---|---|---|
| id主键 | bigint(20) unsigned | 否 | 自增主键 | - |
| order_no索引 | bigint(20) unsigned | 否 | 订单号 | wm_order_discounts.order_no ↔ wm_orders.order_nowm_order_discounts.order_no → wm_order_items.order_nowm_order_discounts.order_no → wm_order_rights.order_no |
| item_id索引 | bigint(20) unsigned | 是 | 订单项ID(商品级优惠才有,订单级为NULL) | wm_order_discounts.item_id ↔ wm_order_items.item_id |
| discount_level索引 | tinyint(4) | 否 | 【优惠级别】0-商品级；2-订单级；11-附加费用 | - |
| discount_id索引 | varchar(100) | 否 | 优惠ID | - |
| discount_name | varchar(200) | 否 | 优惠名称 | - |
| discount_type索引 | tinyint(4) | 否 | 【优惠类型】6-立减券；42-余额抵扣。API:discountInfos.discountType | - |
| discount_sub_type | tinyint(4) | 是 | 优惠子类型 | - |
| discount_amount | decimal(10,2) | 否 | 优惠金额(元) | - |
| cost_amount | decimal(10,2) | 是 | 成本金额(分) | - |
| attribution_type | tinyint(4) | 是 | 【归属类型】1-平台承担；2-商家承担。API:discountInfos.discountExt.attributionType | - |
| discount_ext | json | 是 | 优惠扩展信息(JSON) | - |
索引信息
idx_discount_id
普通索引: discount_id
idx_discount_level
普通索引: discount_level
idx_discount_type
普通索引: discount_type
idx_item_id
普通索引: item_id
idx_order_no
普通索引: order_no
PRIMARY
唯一索引: id
外键约束
wm_order_discounts_ibfk_1
order_no → wm_orders.order_no