Skip to content

merchantlist_temp

Relationships

erDiagram
    merchantlist_temp {
        intunsigned itemid
        intunsigned npcid
    }
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    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
    }
    merchantlist_temp ||--o{ items : "One-to-One"
    merchantlist_temp ||--o{ npc_types : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One itemid items id
One-to-One npcid npc_types id

Schema

Column Data Type Description
npcid int NPC Type Identifier
slot int Slot
zone_id int Zone Identifier
instance_id int Instance Identifier
itemid int Item Identifier
charges int Charges