| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | int(11) | PRI | NO | ||
| goods_id | varchar(64) | MUL | YES | ||
| goods_name | varchar(160) | YES | |||
| step | varchar(24) | YES | |||
| model | varchar(64) | YES | |||
| ok | tinyint(4) | YES | 0 | ||
| cost | decimal(10,4) | YES | 0.0000 | ||
| payload | mediumtext | YES | |||
| created_at | datetime | YES | CURRENT_TIMESTAMP |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_goods | goods_id | 普通 |
| PRIMARY | id | 唯一 |
| id | goods_id | goods_name | step | model | ok | cost | payload | created_at |
|---|---|---|---|---|---|---|---|---|
| 1 | 0000d2f3-1978-4e23-aa87-b47796611b06 | 川至美藤椒酸菜鱼调料378g | ocr | RecognizeGeneral | 1 | 0.1200 | {"step": "ocr", "ok": true, "model": "Reco… | 2026-11-09 20:30:01 |
| 2 | 0000d2f3-1978-4e23-aa87-b47796611b06 | 川至美藤椒酸菜鱼调料378g | copy | qwen-plus | 1 | 0.0009 | {"step": "copy", "ok": true, "model": "qwe… | 2026-11-09 20:30:01 |
| 3 | 0000d2f3-1978-4e23-aa87-b47796611b06 | 川至美藤椒酸菜鱼调料378g | image | qwen-image-2.0 | 1 | 0.0001 | {"step": "image", "ok": true, "model": "qw… | 2026-11-09 20:30:01 |