| Field Name | Field Description | Field Type | Field Default Value |
| id | The ID of the NPC. | int(11) | Auto Increment |
| name | The name of the NPC. | text(0) | Empty |
| lastname | The last name of the NPC. | varchar(32) | NULL |
| level | The level of the NPC. | tinyint(2) | 0 |
| race | The race ID of the NPC. Races | smallint(5) | 0 |
| class | The class ID of the NPC. Classes | tinyint(2) | 0 |
| bodytype | The body type of the NPC. Body Types | int(11) | NULL |
| hp | The health of the NPC. | int(11) | 0 |
| mana | The mana of the NPC. | int(11) | 0 |
| gender | The gender of the NPC. Genders | tinyint(2) | 0 |
| texture | The texture of the NPC. | tinyint(2) | 0 |
| helmtexture | The helmet texture of the NPC. | tinyint(2) | 0 |
| size | The size of the NPC. | float(0) | 0 |
| hp_regen_rate | The health regeneration rate of the NPC. | int(11) | 0 |
| mana_regen_rate | The mana regeneration rate of the NPC. | int(11) | 0 |
| loottable_id | The loottable ID used by the NPC. | int(11) | 0 |
| merchant_id | The merchant ID used by the NPC, must be Merchant class. Classes | int(11) | 0 |
| alt_currency_id | The alternate currency ID used in the merchant's shop. Alternate Currency | int(11) | 0 |
| npc_spells_id | The NPC spell list ID used by the NPC. | int(11) | 0 |
| npc_spells_effects_id |
The NPC spell effect list ID used by the NPC. npc_spells_effects |
int(11) | 0 |
| npc_faction_id | The faction ID of the NPC. | int(11) | 0 |
| adventure_template_id | The adventure template ID of the NPC. | int(10) | 0 |
| trap_template | The trap template ID of the NPC. | int(10) | 0 |
| mindmg | The minimum damage of the NPC. | int(10) | 0 |
| maxdmg | The maximum damage of the NPC. | int(10) | 0 |
| attack_count | The attack count of the NPC. | smallint(6) | -1 |
| npcspecialattks | DEPRECATED: The special attacks of the NPC. NPC Special Attacks | varchar(36) | Empty String |
| special_abilities | The special abilities of the NPC. NPC Special Attacks | text(0) | Empty |
| aggroradius | The aggro radius of the NPC. | int(10) | 0 |
| assistradius | The assist radius of the NPC. | int(10) | 0 |
| face | The face ID of the NPC. | int(10) | 1 |
| luclin_hairstyle | The hair ID of the NPC. | int(10) | 1 |
| luclin_haircolor | The hair color ID of the NPC. | int(10) | 1 |
| luclin_eyecolor | The eye one color ID of the NPC. | int(10) | 1 |
| luclin_eyecolor2 | The eye two color ID of the NPC. | int(10) | 1 |
| luclin_beardcolor | The beard color ID of the NPC. | int(10) | 1 |
| luclin_beard | The beard ID of the NPC. | int(10) | 0 |
| drakkin_heritage | The Drakkin heritage ID of the NPC. | int(10) | 0 |
| drakkin_tattoo | The Drakkin tattoo ID of the NPC. | int(10) | 0 |
| drakkin_details | The Drakkin details ID of the NPC. | int(10) | 0 |
| armortint_id | The armor tint ID of the NPC. | int(10) | 0 |
| armortint_red | The amount of Red coloring on the NPCs armor. | tinyint(3) | 0 |
| armortint_green | The amount of Green coloring on the NPCs armor. | tinyint(3) | 0 |
| armortint_blue | The amount of Blue coloring on the NPCs armor. | tinyint(3) | 0 |
| d_melee_texture1 | The model in the primary hand of the NPC. (Numeric part of raw field "IDFile" for melee item) | int(10) | 0 |
| d_melee_texture2 | The model in the secondary hand of the NPC. (Numeric part of raw field "IDFile" for melee item) | int(10) | 0 |
| prim_melee_type | The primary melee type of the NPC. (see Skills ) | tinyint(4) | 28 |
| sec_melee_type | The secondary melee type of the NPC. (see Skills ) | tinyint(4) | 28 |
| runspeed | The run speed of the NPC. | float(0) | 0 |
| MR | The Magic Resistance of the NPC. | smallint(5) | 0 |
| CR | The Cold Resistance of the NPC. | smallint(5) | 0 |
| DR | The Disease Resistance of the NPC. | smallint(5) | 0 |
| FR | The Fire Resistance of the NPC. | smallint(5) | 0 |
| PR | The Posion Resistance of the NPC. | smallint(5) | 0 |
| Corrup | The Corruption Resistance of the NPC. | smallint(5) | 0 |
| PhR | The Physical Resistance of the NPC. | smallint(5) | 0 |
| see_invis | Determines whether or not the NPC can see players using Invisibility. 0 = No, 1 = Yes | smallint(4) | 0 |
| see_invis_undead | Determines whether or not the NPC can see players using Invisibility VS. Undead. 0 = No, 1 = Yes | smallint(4) | 0 |
| qglobal | Determines whether or not the NPC can load quest globals. 0 = No, 1 = Yes | int(2) | 0 |
| AC | The Armor Class of the NPC. | smallint(5) | 0 |
| npc_aggro | Determines whether or not the NPC can aggro on other NPCs. 0 = No, 1 = Yes | tinyint(4) | 0 |
| spawn_limit | The spawn limit of the NPC. | tinyint(4) | 0 |
| attack_speed | The attack speed of the NPC. The lower the number, the faster the NPC hits. (Deprecated) | float(0) |
0 |
| attack_delay | The delay between the NPCs attack arounds in 10ths of a second (same as weapon's display) | tinyint(3) | 30 |
| findable | Determines whether or not the NPC is findable. 0 = No, 1 = Yes | tinyint(4) | 0 |
| STR | The Strength of the NPC. | mediumint(8) | 75 |
| STA | The Stamina of the NPC. | mediumint(8) | 75 |
| DEX | The Dexterity of the NPC. | mediumint(8) | 75 |
| AGI | The Agility of the NPC. | mediumint(8) | 75 |
| _INT | The Intelligence of the NPC. | mediumint(8) | 80 |
| WIS | The Wisdom of the NPC. | mediumint(8) | 75 |
| CHA | The Charisma of the NPC. | mediumint(8) | 75 |
| see_hide | Determines whether or not the NPC can see players using Hide. 0 = No, 1 = Yes | tinyint(4) | 0 |
| see_improved_hide | Determines whether or not the NPC can see players using Improved Hide. 0 = No, 1 = Yes | tinyint(4) | 0 |
| trackable | Determines whether or not the NPC is trackable. 0 = No, 1 = Yes | tinyint(4) | 1 |
| isbot | Determines whether or not the NPC is a bot. 0 = No, 1 = yes | tinyint(4) | 0 |
| exclude | Leave this at 1. | tinyint(4) | 1 |
| ATK | The Attack of the NPC. | mediumint(9) | 0 |
| Accuracy | The Accuracy of the NPC. | mediumint(9) | 0 |
| slow_mitigation | The slow mitigation of the NPC. | smallint(4) | NULL |
| version | The version of the NPC. | smallint(5) | 0 |
| maxlevel | The max level of the NPC. This makes the mob capable of spawning between levels 'level' to 'maxlevel'. Optionally can set mana regen, hp regen, mindmg and maxdmg to 0 to auto-set based on level or to a base level and use scalerate to scale these. HP and stats are scaled-only and should not be set to 0. | tinyint(3) | 0 |
| scalerate | The rate at which the NPC scales based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. | int(11) | 100 |
| private_corpse | Determines whether or not the NPC, when killed, is a private corpse. 0 = No, 1 = Yes | tinyint(3) | 0 |
| unique_spawn_by_name | Determines whether or not the NPC is a unique spawn. 0 = No, 1 = Yes | tinyint(3) | 0 |
| underwater | Determines whether or not the NPC is underwater. 0 = No, 1 = Yes | tinyint(3) | 0 |
| isquest | Determines whether or not the NPC is a quest NPC. 0 = No, 1 = Yes | tinyint(3) | 0 |
| emoteid | The emote ID of the NPC. | int(10) | 0 |
| spellscale | The rate at which the NPC spells scale based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. | float(0) | 100 |
| healscale | The rate at which the NPC heals scale based on level. 100 = 100%, 50 = 50%, 25 = 25%, etc. | float(0) | 100 |
| no_target_hotkey | Determines whether or not players can target the NPC with their target hotkey. 0 = Yes, 1 = No | tinyint(1) | 0 |