Skip to content

merc_merchant_templates

Relationships

erDiagram
    merc_merchant_templates {
        varchar merc_merchant_template_id
        varchar qglobal
    }
    merc_merchant_entries {
        varchar merc_merchant_template_id
        varchar merchant_id
    }
    merc_merchant_template_entries {
        varchar merc_merchant_template_id
        varchar merc_template_id
        varchar merc_merchant_template_entry_id
    }
    quest_globals {
        int charid
        varchar name
        int npcid
        int zoneid
    }
    merc_merchant_templates ||--o{ merc_merchant_entries : "Has-Many"
    merc_merchant_templates ||--o{ merc_merchant_template_entries : "Has-Many"
    merc_merchant_templates ||--o{ quest_globals : "Has-Many"
Relationship Type Local Key Relates to Table Foreign Key
Has-Many merc_merchant_template_id merc_merchant_entries merc_merchant_template_id
Has-Many merc_merchant_template_id merc_merchant_template_entries merc_merchant_template_id
Has-Many qglobal quest_globals name

Schema

Column Data Type Description
merc_merchant_template_id int Unique Mercenary Merchant Template Identifier
name varchar Name
qglobal varchar Quest Global (Deprecated)