Skip to content



    item_tick {
        varchar it_itemid
        varchar it_qglobal
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    quest_globals {
        int charid
        varchar name
        int npcid
        int zoneid
    item_tick ||--o{ items : "One-to-One"
    item_tick ||--o{ quest_globals : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One it_itemid items id
Has-Many it_qglobal quest_globals name


Column Data Type Description
it_itemid int Item Identifier
it_chance int Chance: 0 = Never, 100 = Always
it_level int Level
it_id int Spell Identifier
it_qglobal varchar Quest Global Identifier (Deprecated)
it_bagslot tinyint Bag Slot