Skip to content

spell_globals

Relationships

erDiagram
    spell_globals {
        varchar qglobal
        int spellid
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    quest_globals {
        int charid
        varchar name
        int npcid
        int zoneid
    }
    spell_globals ||--o{ spells_new : "One-to-One"
    spell_globals ||--o{ quest_globals : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One spellid spells_new id
One-to-One qglobal quest_globals name

Schema

Column Data Type Description
spellid int Unique Spell Identifier
spell_name varchar Spell Name
qglobal varchar Quest Global Name
value varchar Quest Global Value