Skip to content

merc_types

Relationships

erDiagram
    merc_types {
        varchar dbstring
        varchar merc_type_id
    }
    db_str {
        int id
    }
    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_types ||--o{ db_str : "One-to-One"
    merc_types ||--o{ merc_templates : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One dbstring db_str id
Has-Many merc_type_id merc_templates merc_type_id

Schema

Column Data Type Description
merc_type_id int Unique Mercenary Type Identifier
race_id int Race Identifier
proficiency_id tinyint Proficiency Identifier
dbstring varchar DBString Identifier
clientversion int Client Version