| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | varchar(40) | PRI | NO | ||
| algo_version | varchar(40) | YES | |||
| unit_count | int(11) | YES | 0 | ||
| order_count | int(11) | YES | 0 | ||
| gmv | decimal(14,2) | YES | 0.00 | ||
| avg_match | decimal(6,2) | YES | 0.00 | ||
| payload | longtext | YES | |||
| note | varchar(200) | YES | |||
| created_by | varchar(64) | YES | |||
| created_at | datetime | YES | CURRENT_TIMESTAMP |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | algo_version | unit_count | order_count | gmv | avg_match | payload | note | created_by | created_at |
|---|---|---|---|---|---|---|---|---|---|
| 296e2287-5bb2-47d3-8073-544f181d032a | ENGINE_V1 | 28 | 15 | 1323.70 | 0.60 | {"algo": "GRA+GEO+SD", "version": "ENGINE_… | 后台手动重算 | admin | 2026-11-09 07:29:31 |
| 6966a38d-01a7-4d2a-ad64-fe3ee58924c6 | ENGINE_V1 | 27 | 15 | 1323.70 | 0.60 | {"algo": "GRA+GEO+SD", "version": "ENGINE_… | manual run | admin | 2026-11-09 07:28:15 |
| 7265ea7f-3c2b-4e97-8ccc-221ae5755c69 | ENGINE_V1 | 28 | 15 | 1323.70 | 0.60 | {"algo": "GRA+GEO+SD", "version": "ENGINE_… | 归一化修正后重算 | admin | 2026-11-09 07:30:06 |