| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| 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 |