Skip to content

merc_spell_list_entries

Relationships

erDiagram
    merc_spell_list_entries {
        varchar merc_spell_list_id
        varchar spell_id
        varchar stance_id
    }
    merc_spell_lists {
        varchar merc_spell_list_id
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    merc_stance_entries {
        varchar stance_id
    }
    merc_spell_list_entries ||--o{ merc_spell_lists : "One-to-One"
    merc_spell_list_entries ||--o{ spells_new : "One-to-One"
    merc_spell_list_entries ||--o{ merc_stance_entries : "Has-Many"
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

Schema

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