tblGameID1表解析

deepinet

名称： [RedMoon].[dbo].[tblGameID1]
用途： 记录角色信息

期待加一起参加本工作，个人能力有限，有空缺和不正确的理解，请大家跟帖，必有重谢！
列解析：
[Version] [int] NOT NULL,
[GameID] [varchar](14) NOT NULL, -- 玩家角色名，主键
[BillID] [varchar](14) NOT NULL, -- 玩家账号 参见tblBillID表
[Lvl] [int] NOT NULL, -- 角色等级
[Face] [tinyint] NOT NULL, -- 角色职业 参见tblFaceList表解析
[Map] [int] NOT NULL, -- 角色所在地图
[X] [int] NOT NULL, -- 角色所在X坐标 对应'xy命令
[Y] [int] NOT NULL, -- 角色所在Y坐标 对应'xy命令
[TileKind] [bit] NOT NULL,
[Item] [varchar](2000) NOT NULL,
[Equipment] [varchar](280) NOT NULL,
[Skill] [varchar](120) NOT NULL,
[SpecialSkill] [varchar](20) NOT NULL,
[Strength] [int] NOT NULL, -- 角色力量值
[Spirit] [int] NOT NULL, -- 角色意志值
[Dexterity] [int] NOT NULL, -- 角色敏捷值
[Power] [int] NOT NULL, -- 角色骨气值
[Fame] [int] NOT NULL, -- 角色名誉值 绝对值0-1000 负数为红名，正数为蓝名
[Experiment] [int] NOT NULL, -- 角色经验值
[HP] [int] NOT NULL, -- 生命值
[MP] [int] NOT NULL, -- 魔法值
[SP] [int] NOT NULL, -- 体力值
[DP] [int] NOT NULL, -- 怒气值
[Bonus] [int] NOT NULL,
[Money] [int] NOT NULL, -- F2随身地球币数量
[QuickItem] [varchar](160) NOT NULL, -- F8快捷栏普通物品
[QuickSkill] [int] NOT NULL, -- F8主技能
[QuickSpecialSkill] [int] NOT NULL, -- F8怒气技能
[BankMoney] [int] NOT NULL, -- 地球银行地球币数量
[BankItem] [varchar](400) NOT NULL, -- 地球银行普通物品
[SETimer] [varchar](400) NOT NULL,
[PKTimer] [int] NOT NULL,
[Color1] [int] NULL, -- 头发颜色
[Color2] [int] NULL, -- 衣服颜色
[PoisonUsedDate] [datetime] NOT NULL,
[LovePoint] [int] NOT NULL,
[ArmyHired] [int] NOT NULL,
[ArmyMarkIndex] [int] NOT NULL,
[Permission] [int] NOT NULL, -- 权限值
[BonusInitCount] [int] NOT NULL,
[StoryQuestState] [int] NOT NULL, -- 任务值！
[QuestItem] [varchar](100) NOT NULL,
[SubQuestKind] [int] NOT NULL,
[SubQuestDone] [int] NOT NULL,
[SubQuestClientNPCID] [varchar](14) NOT NULL,
[SubQuestClientNPCFace] [int] NOT NULL,
[SubQuestClientNPCMap] [int] NOT NULL,
[SubQuestItem] [varchar](20) NOT NULL,
[SubQuestDestFace] [int] NOT NULL,
[SubQuestDestMap] [int] NOT NULL,
[SubQuestTimer] [int] NOT NULL,
[SubQuestGiftExperience] [int] NOT NULL,
[SubQuestGiftFame] [int] NOT NULL,
[SubQuestGiftItem] [varchar](20) NOT NULL,
[OPArmy] [int] NOT NULL,
[OPPKTimer] [int] NOT NULL, -- 黄名时间
[SurvivalEvent] [int] NOT NULL,
[SurvivalTime] [int] NOT NULL,
[Bonus2] [int] NOT NULL,
[SBonus] [int] NOT NULL,
[STotalBonus] [int] NOT NULL,
[PKPenaltyCount] [int] NOT NULL,
[PKPenaltyDecreaseTimer] [int] NOT NULL,
[SigMoney] [int] NOT NULL, -- F2随身锡葛数量
[BankSigMoney] [int] NOT NULL, -- 宇宙银行锡葛数量
[BankItem2] [varchar](400) NOT NULL, -- 宇宙银行普通物品
[TLETimer] [varchar](400) NOT NULL, -- 针剂状态

China娃娃

好好学习,天天向上!