ome_reship_package
退货包裹表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| package_id | package_id | int(10) unsigned | Y | Y | |
| reship_id | 退货单ID | int(10) unsigned | Y | N | |
| order_id | 订单ID | int(10) unsigned | Y | N | |
| delivery_id | 发货单ID | int(10) unsigned | Y | N | |
| delivery_bn | 发货单号 | varchar(32) | N | N | |
| wms_channel_id | 渠道ID | varchar(30) | N | N | |
| wms_package_id | 发货包裹ID | int(10) unsigned | Y | N | |
| wms_package_bn | 发货包裹单号 | varchar(50) | N | N | |
| numbers | 退货总数量 | int(11) | N | N | |
| status | 退货包裹状态 | varchar(50) | N | N | |
| sync_status | 同步状态 normal:未推送;fail:推送失败;succ:推送成功; | enum('normal','fail','succ') | Y | normal | N |
| wms_order_code | 京东售后申请单号 | varchar(50) | N | N | |
| create_time | 创建时间 | int(10) unsigned | N | N | |
| last_time | 最后更新时间 | int(10) unsigned | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | package_id | Y | |
| in_reship_status | reship_id, sync_status | N | |
| in_reship_pagebn | reship_id, wms_package_bn | N |
