| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| q_code | varchar(32) | UNI | NO | 题目编码 | |
| title | varchar(64) | NO | |||
| question | varchar(200) | NO | |||
| qtype | varchar(16) | YES | single | ||
| options | json | YES | 每项 {label, weights:{basic,family,social,benefit,asset}} | ||
| sort | int(11) | YES | 0 | ||
| status | varchar(16) | YES | active | ||
| created_at | datetime(3) | YES | CURRENT_TIMESTAMP(3) |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| uk_qcode | q_code | 普通 |
| id | q_code | title | question | qtype | options | sort | status | created_at |
|---|---|---|---|---|---|---|---|---|
| 3a0fc7ab-5579-4f22-8516-91b63d41b7ef | Q4 | 孩子 | 家里有 12 岁以下的孩子吗? | multi | [{"label": "有", "weights": {"basic": 1, "f… | 4 | active | 2026-11-07 14:26:38.441000 |
| 44435b54-15d7-4119-adfe-2a0cdb64deeb | Q11 | 花钱意愿 | 最愿意为什么花钱? | multi | [{"label": "吃穿日用", "weights": {"basic": 3}… | 11 | active | 2026-11-07 14:26:38.450000 |
| 61ed09b9-faf1-4d77-84d5-61f77278e602 | Q9 | 邻里关系 | 和邻居熟吗? | multi | [{"label": "很熟,常串门", "weights": {"social":… | 9 | active | 2026-11-07 14:26:38.447000 |