Skip to content

merc_merchant_template_entries

Relationships

erDiagram
    merc_merchant_template_entries {
        varchar merc_merchant_template_id
        varchar merc_template_id
        varchar merc_merchant_template_entry_id
    }
    merc_merchant_templates {
        varchar merc_merchant_template_id
        varchar qglobal
    }
    merc_templates {
        varchar dbstring
        varchar merc_template_id
        varchar name_type_id
        varchar merc_npc_type_id
        varchar merc_subtype_id
        varchar merc_type_id
    }
    merc_merchant_template_entries ||--o{ merc_merchant_templates : "One-to-One"
    merc_merchant_template_entries ||--o{ merc_templates : "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 merc_template_id merc_templates merc_template_id

Schema

Column Data Type Description
merc_merchant_template_entry_id int Unique Mercenary Merchant Template Entry Identifier
merc_merchant_template_id int Mercenary Merchant Template Identifier
merc_template_id int Mercenary Template Identifier