Skip to content



    merc_merchant_entries {
        varchar merc_merchant_template_id
        varchar merchant_id
    merc_merchant_templates {
        varchar merc_merchant_template_id
        varchar qglobal
    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
    merc_merchant_entries ||--o{ merc_merchant_templates : "One-to-One"
    merc_merchant_entries ||--o{ npc_types : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One merc_merchant_template_id merc_merchant_templates merc_merchant_template_id
One-to-One merchant_id npc_types id


Column Data Type Description
merc_merchant_entry_id int Unique Mercenary Merchant Entry Identifier
merc_merchant_template_id int Mercenary Merchant Template Identifier
merchant_id int Merchant Identifier