| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| ticket_no | varchar | UNI | NO | |
| user_id | bigint | MUL | NO | 发起人 |
| username | varchar | — | YES | |
| type | varchar | — | YES | REPAIR维修/COMPLAINT投诉/INQUIRY咨询 |
| title | varchar | — | NO | |
| description | varchar | — | YES | |
| priority | varchar | — | YES | LOW/NORMAL/HIGH |
| address | varchar | — | YES | |
| status | varchar | MUL | YES | PENDING/ACCEPTED/PROCESSING/RESOLVED/CLOSED |
| handler_id | bigint | — | YES | |
| handler | varchar | — | YES | |
| rating | tinyint | — | YES | 1-5满意度 |
| rate_comment | varchar | — | YES | |
| created_at | datetime | — | YES |