全景目录 ›
数据库 › yjgw_ai › ai_consume_log
ai_consume_logAI· 消耗
yjgw_ai 库的实体表 · 9 个字段 · 主键 id · 数据行约 172
字段结构
| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|
| id | bigint(20) | PRI | NO | | |
| user_id | bigint(20) | MUL | NO | | |
| usage_id | bigint(20) | | YES | | |
| capability | varchar(32) | | YES | | |
| amount | decimal(12,4) | | NO | | |
| balance_before | decimal(12,4) | | NO | 0.0000 | |
| balance_after | decimal(12,4) | | NO | 0.0000 | |
| settled | tinyint(4) | MUL | NO | 0 | |
| created_at | datetime | | YES | CURRENT_TIMESTAMP | |
索引
| 索引名 | 字段 | 类型 |
|---|
| k_settled | settled | 普通 |
| k_user | user_id,created_at | 普通 |
| PRIMARY | id | 唯一 |
样本数据 · 已脱敏 · 前 3 行
| id | user_id | usage_id | capability | amount | balance_before | balance_after | settled | created_at |
|---|
| 1 | 7 | NULL | mixed | 0.0021 | 30.0000 | 29.9979 | 1 | 2026-11-09 19:38:25 |
| 2 | 7 | NULL | mixed | 0.0002 | 49.9979 | 49.9977 | 1 | 2026-11-09 19:39:52 |
| 3 | 7 | NULL | mixed | 0.0003 | 49.9977 | 49.9974 | 1 | 2026-11-09 19:45:29 |