characters_character_stats表存储角色的基础属性统计数据,包括生命值、法力值和五大基础属性(力量、敏捷、耐力、智力、精神)。
| 序号 | 字段名 | 数据类型 | 默认值 | 是否为空 | 键类型 | 说明 |
|---|---|---|---|---|---|---|
| 1 | guid | int(10) unsigned | 0 | NOT NULL | PRIMARY KEY | 角色唯一标识符,关联characters表的guid字段 |
| 2 | maxhealth | int(10) unsigned | 0 | NOT NULL | 角色的最大生命值 | |
| 3 | maxpower1 | int(10) unsigned | 0 | NOT NULL | 角色能量类型1的最大值 | |
| 4 | maxpower2 | int(10) unsigned | 0 | NOT NULL | 角色能量类型2的最大值 | |
| 5 | maxpower3 | int(10) unsigned | 0 | NOT NULL | 角色能量类型3的最大值 | |
| 6 | maxpower4 | int(10) unsigned | 0 | NOT NULL | 角色能量类型4的最大值 | |
| 7 | maxpower5 | int(10) unsigned | 0 | NOT NULL | 角色能量类型5的最大值 | |
| 8 | maxpower6 | int(10) unsigned | 0 | NOT NULL | 角色能量类型6的最大值 | |
| 9 | maxpower7 | int(10) unsigned | 0 | NOT NULL | 角色能量类型7的最大值 | |
| 10 | strength | int(10) unsigned | 0 | NOT NULL | 力量属性值 | |
| 11 | agility | int(10) unsigned | 0 | NOT NULL | 敏捷属性值 | |
| 12 | stamina | int(10) unsigned | 0 | NOT NULL | 耐力属性值 | |
| 13 | intellect | int(10) unsigned | 0 | NOT NULL | 智力属性值 | |
| 14 | spirit | int(10) unsigned | 0 | NOT NULL | 精神属性值 | |
| 15 | armor | int(10) unsigned | 0 | NOT NULL | 护甲值 | |
| 16 | resHoly | int(10) unsigned | 0 | NOT NULL | 神圣抗性 | |
| 17 | resFire | int(10) unsigned | 0 | NOT NULL | 火焰抗性 | |
| 18 | resNature | int(10) unsigned | 0 | NOT NULL | 自然抗性 | |
| 19 | resFrost | int(10) unsigned | 0 | NOT NULL | 冰霜抗性 | |
| 20 | resShadow | int(10) unsigned | 0 | NOT NULL | 暗影抗性 | |
| 21 | resArcane | int(10) unsigned | 0 | NOT NULL | 奥术抗性 | |
| 22 | blockPct | float | 0 | NOT NULL | 格挡百分比 | |
| 23 | dodgePct | float | 0 | NOT NULL | 躲闪百分比 | |
| 24 | parryPct | float | 0 | NOT NULL | 招架百分比 | |
| 25 | critPct | float | 0 | NOT NULL | 暴击百分比 | |
| 26 | rangedCritPct | float | 0 | NOT NULL | 远程暴击百分比 | |
| 27 | spellCritPct | float | 0 | NOT NULL | 法术暴击百分比 | |
| 28 | attackPower | int(10) unsigned | 0 | NOT NULL | 攻击强度 | |
| 29 | rangedAttackPower | int(10) unsigned | 0 | NOT NULL | 远程攻击强度 | |
| 30 | spellPower | int(10) unsigned | 0 | NOT NULL | 法术强度 | |
| 31 | resilience | int(10) unsigned | 0 | NOT NULL | 韧性值 |