Skip to content

mercs

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

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