| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| order_id | char(36) | YES | |||
| order_no | longtext | YES | |||
| user_id | char(36) | YES | |||
| merchant_id | char(36) | YES | |||
| store_id | char(36) | YES | |||
| type | longtext | YES | |||
| status | longtext | YES | |||
| reason | longtext | YES | |||
| description | longtext | YES | |||
| images | longtext | YES | |||
| amount | decimal(12,2) | YES | |||
| refund_amount | decimal(12,2) | YES | |||
| refunded_online | tinyint(1) | YES | |||
| refunded_at | datetime(3) | YES | |||
| reject_reason | longtext | YES | |||
| contact_name | longtext | YES | |||
| contact_phone | longtext | YES | |||
| handled_by | char(36) | YES | |||
| handled_at | datetime(3) | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| items | longtext | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | order_id | order_no | user_id | merchant_id | store_id | type | status | reason | description | images | amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7fd6e047-999c-585d-9875-f20202130c49 | 5838682a-90cd-5258-89df-bf213f81a2bb | YJDEMO20261109009 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | REFUND | REFUNDED | 商品破损 | 收到商品外包装破损,申请退款 | NULL | 41.06 |
| 8f56a855-cf98-5d1c-9d13-78f6bc998de2 | 957ca818-b7f9-56c3-9693-d960d2cacc6a | YJDEMO20261109008 | 99a9baad-a7d3-4d36-9609-c761a9f63e7d | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | REFUND | PENDING | 商品破损 | 收到商品外包装破损,申请退款 | NULL | 125.78 |