Skip to content



    alternate_currency {
        int id
        int item_id
    character_alt_currency {
        intunsigned currency_id
        intunsigned char_id
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    alternate_currency ||--o{ character_alt_currency : "Has-Many"
    alternate_currency ||--o{ npc_types : "Has-Many"
    alternate_currency ||--o{ items : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id character_alt_currency currency_id
Has-Many id npc_types alt_currency_id
Has-Many item_id items id


Column Data Type Description
id int Alternate Currency Identifier
item_id int Item Identifier