ome_refund_apply_luban
抖音退款申请附加信息表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| apply_id | apply_id | mediumint(8) unsigned | Y | N | |
| refund_apply_bn | 退款申请单号 | varchar(32) | Y | N | |
| shop_id | 来源店铺 | varchar(32) | N | N | |
| refuse_message | 拒绝退款原因留言 | longtext | N | N | |
| refuse_proof | 拒绝退款举证上传 | varchar(255) | N | N | |
| outer_lastmodify | 数据推送的修改时间 | int(10) unsigned | N | N | |
| trade_status | trade_status | varchar(64) | N | N | |
| refund_type | refund_type refund:退款单;return:退货单; | enum('refund','return') | N | refund | N |
| bill_type | bill_type refund_bill:退款单;return_bill:退货单; | enum('refund_bill','return_bill') | N | refund_bill | N |
| oid | 子订单号 | varchar(50) | N | 0 | N |
| refund_fee | 需退金额 | decimal(20,3) | N | N | |
| message_text | 留言凭证 | longtext | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | apply_id | Y | |
| ind_refund_apply_bn_shop | refund_apply_bn, shop_id, apply_id | Y | |
| idx_c_shop_id | shop_id | N |
