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 |