Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One merc_spell_list_id merc_spell_lists merc_spell_list_id
One-to-One spell_id spells_new id
Has-Many stance_id merc_stance_entries stance_id


Column Data Type Description
merc_spell_list_entry_id int Unique Mercenary Spell List Entry Identifier
merc_spell_list_id int Mercenary Spell List Identifier
spell_id int Spell Identifier
spell_type int Spell Type
stance_id tinyint Stance Type Identifier
minlevel tinyint Minimum Level
maxlevel tinyint Maximum Level
slot tinyint Slot
procChance tinyint Proc Chance: 0 = Never, 100 = Always