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 |