Skip to content



    horses {
        varchar filename
    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
    horses ||--o{ npc_types : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One filename npc_types name


Column Data Type Description
id int Unique Horse Identifier
filename varchar NPC Type Name
race smallint Race
gender tinyint Gender
texture tinyint Texture
mountspeed float Mount Run Speed
notes varchar Notes