npc_types

Relationships

erDiagram
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    adventure_template {
        intunsigned id
        intunsigned graveyard_zone_id
        varchar zone
        smallintunsigned zone_in_zone_id
        tinyintunsigned zone_version
        varchar version
    }
    alternate_currency {
        int id
        int item_id
    }
    npc_types_tint {
        intunsigned id
    }
    npc_emotes {
        intunsigned emoteid
    }
    fishing {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
        int npc_id
    }
    npc_types ||--o{ adventure_template : "One-to-One"
    npc_types ||--o{ alternate_currency : "One-to-One"
    npc_types ||--o{ npc_types_tint : "One-to-One"
    npc_types ||--o{ npc_emotes : "Has-Many"
    npc_types ||--o{ fishing : "Has-Many"

erDiagram
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    merchantlist_temp {
        intunsigned itemid
        intunsigned npcid
    }
    pets {
        int npcID
        varchar type
        int equipmentset
    }
    qs_player_handin_record {
        int char_id
        int npc_id
    }
    qs_player_npc_kill_record {
        int npc_id
        int zone_id
    }
    quest_globals {
        int charid
        varchar name
        int npcid
        int zoneid
    }
    npc_types ||--o{ merchantlist_temp : "Has-Many"
    npc_types ||--o{ pets : "One-to-One"
    npc_types ||--o{ qs_player_handin_record : "Has-Many"
    npc_types ||--o{ qs_player_npc_kill_record : "Has-Many"
    npc_types ||--o{ quest_globals : "Has-Many"

erDiagram
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    spawnentry {
        varchar content_flags
        varchar content_flags_disabled
        int npcID
        int spawngroupID
    }
    task_activities {
        intunsigned activityid
        varchar goalid
        varchar delivertonpc
        intunsigned taskid
        varchar zones
    }
    loottable {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    }
    merchantlist {
        varchar content_flags
        varchar content_flags_disabled
        varchar bucket_name
        int item
        varchar merchant_id
        int merchantid
    }
    horses {
        varchar filename
    }
    npc_types ||--o{ spawnentry : "Has-Many"
    npc_types ||--o{ task_activities : "Has-Many"
    npc_types ||--o{ loottable : "One-to-One"
    npc_types ||--o{ merchantlist : "Has-Many"
    npc_types ||--o{ horses : "One-to-One"

erDiagram
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    npc_faction {
        int id
        int primaryfaction
    }
    npc_spells {
        intunsigned id
        intunsigned parent_list
    }
    npc_spells_effects {
        intunsigned id
    }
    ldon_trap_templates {
        intunsigned id
        smallintunsigned spell_id
    }
    npc_types ||--o{ npc_faction : "Has-Many"
    npc_types ||--o{ npc_spells : "One-to-One"
    npc_types ||--o{ npc_spells_effects : "One-to-One"
    npc_types ||--o{ ldon_trap_templates : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	adventure_template_id	adventure_template	id
One-to-One	alt_currency_id	alternate_currency	id
One-to-One	armortint_id	npc_types_tint	id
Has-Many	emoteid	npc_emotes	emoteid
Has-Many	id	fishing	npc_id
Has-Many	id	merchantlist_temp	npcid
One-to-One	id	pets	npcID
Has-Many	id	qs_player_handin_record	npc_id
Has-Many	id	qs_player_npc_kill_record	npc_id
Has-Many	id	quest_globals	npcid
Has-Many	id	spawnentry	npcID
Has-Many	id	task_activities	delivertonpc
One-to-One	loottable_id	loottable	id
Has-Many	merchant_id	merchantlist	merchantid
One-to-One	name	horses	filename
Has-Many	npc_faction_id	npc_faction	id
One-to-One	npc_spells_id	npc_spells	id
One-to-One	npc_spells_effects_id	npc_spells_effects	id
One-to-One	trap_template	ldon_trap_templates	id

Schema

Column	Data Type	Description
id	int	Unique NPC Type Identifier
name	text	Name
lastname	varchar	Last Name
level	tinyint	Level
race	smallint	Race
class	tinyint	Class
bodytype	int	Body Type
hp	bigint	Health
mana	bigint	Mana
gender	tinyint	Gender
texture	tinyint	Texture
helmtexture	tinyint	Helmet Texture
herosforgemodel	int	Hero's Forge Model
size	float	Size
hp_regen_rate	bigint	Health Regeneration
hp_regen_per_second	bigint	Health Regeneration Per Second
mana_regen_rate	bigint	Mana Regeneration
loottable_id	int	Loottable Identifier
merchant_id	int	Merchant Identifier
alt_currency_id	int	Alternate Currency Identifier
npc_spells_id	int	NPC Spell Set Identifier
npc_spells_effects_id	int	NPC Spell Effects Identifier
npc_faction_id	int	NPC Faction Identifier
adventure_template_id	int	Adventure Template Identifier
trap_template	int	Trap Template Identifier
mindmg	int	Minimum Damage
maxdmg	int	Maximum Damage
attack_count	smallint	Attack Count
npcspecialattks	varchar	NPC Special Attacks (Deprecated)
special_abilities	text	NPC Special Abilities
aggroradius	int	Aggro Radius
assistradius	int	Assist Radius
face	int	Face
luclin_hairstyle	int	Hair Style
luclin_haircolor	int	Hair Color
luclin_eyecolor	int	Eye Color 1
luclin_eyecolor2	int	Eye Color 2
luclin_beardcolor	int	Beard Color
luclin_beard	int	Beard
drakkin_heritage	int	Drakkin Heritage
drakkin_tattoo	int	Drakkin Tattoo
drakkin_details	int	Drakkin Details
armortint_id	int	Armor Tint Identifier
armortint_red	tinyint	Armor Tint Red: 0 = None, 255 = Max
armortint_green	tinyint	Armor Tint Green: 0 = None, 255 = Max
armortint_blue	tinyint	Armor Tint Blue: 0 = None, 255 = Max
d_melee_texture1	int	Primary Weapon Texture
d_melee_texture2	int	Secondary Weapon Texture
ammo_idfile	varchar	Ammo Texture
prim_melee_type	tinyint	Primary Melee Type
sec_melee_type	tinyint	Secondary Melee Type
ranged_type	tinyint	Ranged Type
runspeed	float	Run Speed
MR	smallint	Magic Resistance
CR	smallint	Cold Resistance
DR	smallint	Disease Resistance
FR	smallint	Fire Resistance
PR	smallint	Poison Resistance
Corrup	smallint	Corruption Resistance
PhR	smallint	Physical Resistance
see_invis	smallint	See Invisible: 0 = False, 1 = True
see_invis_undead	smallint	See Invisible vs. Undread: 0 = False, 1 = True
qglobal	int	Quest Globals: 0 = Disabled, 1 = Enabled (Deprecated)
AC	smallint	Armor Class
npc_aggro	tinyint	NPC Aggro: 0 = False, 1 = True
spawn_limit	tinyint	Spawn Limit
attack_speed	float	Attack Speed: The lower the number, the faster the NPC hits. (Deprecated)
attack_delay	tinyint	Attack Delay: Delay between the attack arounds in 10ths of a second.
findable	tinyint	Findable: 0 = False, 1 = True
STR	mediumint	Strength
STA	mediumint	Stamina
DEX	mediumint	Dexterity
AGI	mediumint	Agility
_INT	mediumint	Intelligence
WIS	mediumint	Wisdom
CHA	mediumint	Charisma
see_hide	tinyint	See Hide: 0 = False, 1 = True
see_improved_hide	tinyint	See Improved Hide: 0 = False, 1 = True
trackable	tinyint	Trackable: 0 = False, 1 = True
isbot	tinyint	Is Bot: 0 = False, 1 = True
exclude	tinyint	Exclude: 0 = False, 1 = True
ATK	mediumint	Attack
Accuracy	mediumint	Accuracy
Avoidance	mediumint	Avoidance
slow_mitigation	smallint	Slow Mitigation
version	smallint	Version
maxlevel	tinyint	Maximum Level
scalerate	int	Scale Rate
private_corpse	tinyint	Private Corpse: 0 = False, 1 = True
unique_spawn_by_name	tinyint	Unique Spawn By Name: 0 = False, 1 = True
underwater	tinyint	Underwater: 0 = False, 1 = True
isquest	tinyint	Is Quest: 0 = False, 1 = True
emoteid	int	Emote Identifier
spellscale	float	Spell Scale: 50 = 50%, 100 = 100%, 150 = 150%
healscale	float	Heal Scale: 50 = 50%, 100 = 100%, 150 = 150%
no_target_hotkey	tinyint	No Target Hotkey: 0 = False, 1 = True
raid_target	tinyint	Raid Target: 0 = False, 1 = True
armtexture	tinyint	Arm Texture
bracertexture	tinyint	Bracer Texture
handtexture	tinyint	Hand Texture
legtexture	tinyint	Leg Texture
feettexture	tinyint	Feet Texture
light	tinyint	Light
walkspeed	tinyint	Walk Speed
peqid	int	PEQ Identifier
unique_	tinyint	Unique
fixed	tinyint	Fixed
ignore_despawn	tinyint	Ignore Despawn: 0 = False, 1 = True
show_name	tinyint	Show Name: 0 = False, 1 = True
untargetable	tinyint	Untargetable: 0 = False, 1 = True
charm_ac	smallint	Charmed Armor Class
charm_min_dmg	int	Charmed Minimum Damage
charm_max_dmg	int	Charmed Maximum Damage
charm_attack_delay	tinyint	Charmed Attack Delay
charm_accuracy_rating	mediumint	Charmed Accuracy
charm_avoidance_rating	mediumint	Charmed Avoidance
charm_atk	mediumint	Charmed Attack
skip_global_loot	tinyint	Skip Global Loot: 0 = False, 1 = True
rare_spawn	tinyint	Rare Spawn: 0 = False, 1 = True
stuck_behavior	tinyint	Stuck Behavior
model	smallint	Model
flymode	tinyint	Fly Mode
always_aggro	tinyint	Aggro regardless of _int or level : 0 = False, 1 = True
exp_mod	int	Experience Modifier (50 = 50%, 100 = 100%, 200 = 200%)
heroic_strikethrough	int	Heroic Strikethrough
faction_amount	int	Faction Amount
keeps_sold_items	tinyint	Keeps Sold Items: 0 = False, 1 = True