Skip to content



    mercs {
        intunsigned OwnerCharacterID
        intunsigned TemplateID
        intunsigned MercID
        tinyintunsigned StanceID
    merc_buffs {
        intunsigned MercId
        intunsigned SpellId
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    merc_spell_list_entries {
        varchar merc_spell_list_id
        varchar spell_id
        varchar stance_id
    merc_stance_entries {
        varchar stance_id
    merc_templates {
        varchar dbstring
        varchar merc_template_id
        varchar name_type_id
        varchar merc_npc_type_id
        varchar merc_subtype_id
        varchar merc_type_id
    mercs ||--o{ merc_buffs : "Has-Many"
    mercs ||--o{ character_data : "One-to-One"
    mercs ||--o{ merc_spell_list_entries : "Has-Many"
    mercs ||--o{ merc_stance_entries : "Has-Many"
    mercs ||--o{ merc_templates : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
Has-Many MercID merc_buffs MercId
One-to-One OwnerCharacterID character_data id
Has-Many StanceID merc_spell_list_entries stance_id
Has-Many StanceID merc_stance_entries stance_id
One-to-One TemplateID merc_templates merc_template_id


Column Data Type Description
MercID int Unique Mercenary Identifier
OwnerCharacterID int Owner Character Identifier
Slot tinyint Slot
Name varchar Name
TemplateID int Template Identifier
SuspendedTime int Suspended Time UNIX Timestamp
IsSuspended tinyint Is Suspended: 0 = False, 1 = True
TimerRemaining int Timer Remaining in Seconds
Gender tinyint Gender
MercSize float Mercenary Size
StanceID tinyint Stance Type Identifier
HP int Health
Mana int Mana
Endurance int Endurance
Face int Face
LuclinHairStyle int Hair Style
LuclinHairColor int Hair Color
LuclinEyeColor int Eye Color 1
LuclinEyeColor2 int Eye Color 2
LuclinBeardColor int Beard Color
LuclinBeard int Beard
DrakkinHeritage int Drakkin Heritage
DrakkinTattoo int Drakkin Tattoo
DrakkinDetails int Drakkin Details