mercs¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| Has-Many | MercID | merc_buffs | MercId |
| One-to-One | OwnerCharacterID | character_data | id |
| Has-Many | StanceID | merc_spell_list_entries | stance_id |
| Has-Many | StanceID | merc_stance_entries | stance_id |
| One-to-One | TemplateID | merc_templates | merc_template_id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| MercID | int | Unique Mercenary Identifier |
| OwnerCharacterID | int | Owner Character Identifier |
| Slot | tinyint | Slot |
| Name | varchar | Name |
| TemplateID | int | Template Identifier |
| SuspendedTime | int | Suspended Time UNIX Timestamp |
| IsSuspended | tinyint | Is Suspended: 0 = False, 1 = True |
| TimerRemaining | int | Timer Remaining in Seconds |
| Gender | tinyint | Gender |
| MercSize | float | Mercenary Size |
| StanceID | tinyint | Stance Type Identifier |
| HP | int | Health |
| Mana | int | Mana |
| Endurance | int | Endurance |
| Face | int | Face |
| LuclinHairStyle | int | Hair Style |
| LuclinHairColor | int | Hair Color |
| LuclinEyeColor | int | Eye Color 1 |
| LuclinEyeColor2 | int | Eye Color 2 |
| LuclinBeardColor | int | Beard Color |
| LuclinBeard | int | Beard |
| DrakkinHeritage | int | Drakkin Heritage |
| DrakkinTattoo | int | Drakkin Tattoo |
| DrakkinDetails | int | Drakkin Details |