| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| refund_no | varchar(64) | UNI | YES | ||
| order_id | char(36) | MUL | YES | ||
| order_no | varchar(64) | YES | |||
| merchant_id | char(36) | MUL | YES | ||
| store_id | char(36) | YES | |||
| user_id | char(36) | YES | |||
| refund_type | varchar(32) | YES | only_money | only_money仅退款/return_refund退货退款 | |
| amount | decimal(12,2) | YES | 0.00 | ||
| reason | longtext | YES | |||
| images | longtext | YES | 凭证图 | ||
| status | tinyint(4) | MUL | YES | 0 | 0待审核 1审核通过 2已退款 3已拒绝 4已关闭 |
| audit_by | char(36) | YES | |||
| audit_name | varchar(64) | YES | |||
| audit_at | datetime(3) | YES | |||
| audit_remark | longtext | YES | |||
| refund_channel | varchar(32) | YES | original原路/balance余额/cash现金 | ||
| refund_at | datetime(3) | YES | |||
| third_refund_no | varchar(64) | YES | 微信退款单号 | ||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_ro_merchant | merchant_id,status | 普通 |
| idx_ro_order | order_id | 普通 |
| idx_ro_status | status,created_at | 普通 |
| PRIMARY | id | 唯一 |
| uk_refund_no | refund_no | 普通 |
| id | refund_no | order_id | order_no | merchant_id | store_id | user_id | refund_type | amount | reason | images | status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9ae208dc-0d0a-5647-8e45-a7d02720f6f1 | YJDEMO20261109009 | abbdb60d-7ae1-557e-b3e9-4efac473930b | YJDEMO20261109009 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | REFUND_ONLY | 41.06 | 商品外包装破损 | NULL | 0 |
| 9ee83788-4fd7-5900-a4b1-7aaa2c23090c | YJDEMO20261109008 | adf09c9b-79aa-5fd2-8f29-23237f396158 | YJDEMO20261109008 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 99a9baad-a7d3-4d36-9609-c761a9f63e7d | REFUND_ONLY | 125.78 | 商品外包装破损 | NULL | 0 |