The database is built on the server side, and a detailed database dictionary

Original address: http://bbs.gameres.com/forum.php?mod=viewthread&tid=227372

The database dictionary is as follows:
table: Tb_skill_info

Columns (+)

calculate the appropriate data class
find the best data type for the table by reading the existing data. Learn more about

Field Type Comment
ID of Skillid Int (ten) not NULL skill
Name of SkillName varchar (255) Not NULL skill
Skillgroup Int (ten) not a NULL skill group ID
level Int (ten) NULL skill levels
Icon Int () not NULL skill icons
type int (a) Not NULL skill icon types
Skilltype Int (a) Not NULL skill type 0 Active skill 1 passive skill 2 applied Skill 3 Combat Skill
profession Int (a) Not NULL occupation limit 0 Unrestricted 1 Warrior 2 Mage 3 Ranger 4 priest 6 Monster 9 All characters common attack skill
Description of Skilldescript varchar (255) Not NULL skill
weaponrequied Int (ten) not NULL skill required weapon
ReleaseType Int (ten) not NULL skill release Type 1 active 2 passive
levelrequired Int (ten) not NULL skill requirement level
itemrequired Int (ten) Not NULL skill Item demand
itemcountrequired Int (ten) not NULL skill Item number requirement
Levelupmoney Int (ten) not NULL skill requires money
RELEASECD Int (ten) not NULL skill CD time (number of rounds)
Distancetype Int (ten) not NULL skill distance Type 1 remote 2 near body
RangeType Int (ten) not NULL skill range Type 1 monomer 2 all.
AttributeType Int (1) Not NULL the attribute type of the Skill 2 magic of physics
TargetType Int (ten) not NULL skill target type 1 = own 2= teammate 3 = enemy
Expendpower Int (ten) not NULL skill energy consumption
EXPENDHP Int (ten) not NULL skill amount of blood consumption
effect Int (ten) not NULL skill's effect ID
Releaseeffect Int (ten) not NULL skill release effect
Beareffect Int (ten) not NULL ability to withstand effects
Throweffectid Int (ten) not NULL skill cast effect
Aoeeffectid Int (ten) Not NULL full screen effect


table: Tb_skill_effect

Columns (6)

calculate the appropriate data class
find the best data type for the table by reading the existing data. Learn more about

Field Type Comment
effectid Int (ten) unsigned the effect ID of not NULL skill
formula varchar (255) Not NULL skill effect Calculation Formula
Clearbuffid Int (ten) not NULL clears the buff's ID
clearrate Int (ten) not NULL the probability of clearing the buff
Addbuffid Int (Ten) not NULL add buff ID
addrate Int (ten) not NULL the probability of adding a buff
table: Tb_buff_info

Columns (Ten)

calculate the appropriate data class
find the best data type for the table by reading the existing data. Learn more about

Field Type Comment
ID of Buffid Int (ten) not NULL buff
name of the buffname varchar () not NULL buff
description of the buffdes varchar (255) NULL Buff
TRACECD Int (ten) not NULL buff number of continuous rounds
replacebuff varchar (a) not NULL replaceable buff ID
type of Bufftype int (ten) not NULL buff
maxstack Int (ten) not NULL buff the maximum number of stacking layers
ID of the effect of the Buffeffectid Int (ten) not NULL buff
resource ID of Buffeffectresource int (ten) not NULL buff
Bufficon Int (ten) not NULL buff icon ID

Table Tb_buff_effect

Columns (9)

calculate the appropriate data class
find the best data type for the table by reading the existing data. Learn more about

Field Type Comment
Buffeffectid Int (ten) not NULL buff effect ID
AttributeType Int (ten) not NULL Buff Property 1 Physical 2 Magic
effecttriggercondition varchar (255) Not NULL buff trigger condition
triggereffectformula varchar (255) NULL Passive-triggered buff or debuff effect calculation formula
triggerdothotformula varchar (255) NULL passive triggered dot or hot effect calculation formula
effectformula varchar (255) not NULL buff or debuff effect calculation formula
dothotformula varchar (255) NULL dot or hot effect formula
effectdropformula varchar (255) Not NULL effect when the skill disappears (skill effect added inverse)
Addbuffid Int (a) not NULL buff trigger buff ID

table: Tb_buff_effect

Columns (9)

calculate the appropriate data class
find the best data type for the table by reading the existing data. Learn more about

Field Type Comment
Buffeffectid Int (ten) not NULL buff effect ID
AttributeType Int (ten) not NULL Buff Property 1 Physical 2 Magic
effecttriggercondition varchar (255) Not NULL buff trigger condition
triggereffectformula varchar (255) NULL Passive-triggered buff or debuff effect calculation formula
triggerdothotformula varchar (255) NULL passive triggered dot or hot effect calculation formula
effectformula varchar (255) not NULL buff or debuff effect calculation formula
dothotformula varchar (255) NULL dot or hot effect formula
effectdropformula varchar (255) Not NULL effect when the skill disappears (skill effect added inverse)
Addbuffid Int (a) not NULL buff trigger buff ID