| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| ticket_no | varchar(64) | UNI | YES | ||
| user_id | char(36) | MUL | YES | ||
| member_phone | varchar(32) | YES | |||
| order_id | char(36) | YES | |||
| order_no | varchar(64) | YES | |||
| merchant_id | char(36) | YES | |||
| store_id | char(36) | YES | |||
| category | varchar(32) | YES | consult咨询/aftersale售后/complaint投诉/logistics物流 | ||
| channel | varchar(32) | YES | online | online在线/phone电话/pos门店 | |
| title | varchar(255) | YES | |||
| content | longtext | YES | |||
| images | longtext | YES | |||
| priority | tinyint(4) | YES | 2 | 1紧急 2普通 3低 | |
| status | tinyint(4) | MUL | YES | 0 | 0待处理 1处理中 2已解决 3已关闭 |
| assignee_id | char(36) | MUL | YES | 客服专员 | |
| assignee_name | varchar(64) | YES | |||
| reply_content | longtext | YES | |||
| first_reply_at | datetime(3) | YES | |||
| closed_at | datetime(3) | YES | |||
| satisfaction | tinyint(4) | YES | 1-5 满意度 | ||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_cst_assignee | assignee_id,status | 普通 |
| idx_cst_status | status,priority | 普通 |
| idx_cst_user | user_id,created_at | 普通 |
| PRIMARY | id | 唯一 |
| uk_ticket_no | ticket_no | 普通 |
| id | ticket_no | user_id | member_phone | order_id | order_no | merchant_id | store_id | category | channel | title | content |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 27d2e1b1-fa53-565c-bda5-f674fe2dbcfe | GD20261109001 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 138****0002 | 802c8048-65ea-587f-a0c9-5f358ecc5cf2 | YJDEMO20261109001 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 物流 | app | 配送延迟 | 订单迟迟未送达 |
| 854d8572-5fa3-4329-8420-e815991371ed | KF20261107092120866 | a993e992-cb95-4afe-b6eb-3642b8704003 | NULL | 246971c9-9e23-4063-9740-80cabd02521e | YJ202611070844413883 | NULL | NULL | after_sale | online | 收到的湿巾包装破损 | 外包装挤压变形,内部未漏,希望补发一包 |
| 906d6671-2061-5717-9ddd-e5fa4448fd68 | GD20261109003 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 138****0002 | cf4f4bde-7634-53d7-b828-9dbe7823f4dc | YJDEMO20261109003 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 咨询 | phone | 如何开票 | 请问怎么开发票 |