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 |