mercs

Relationships

erDiagram
    mercs {
        intunsigned OwnerCharacterID
        intunsigned TemplateID
        intunsigned MercID
        tinyintunsigned StanceID
    }
    merc_buffs {
        intunsigned MercId
        intunsigned SpellId
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    merc_spell_list_entries {
        varchar merc_spell_list_id
        varchar spell_id
        varchar stance_id
    }
    merc_stance_entries {
        varchar stance_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
    }
    mercs ||--o{ merc_buffs : "Has-Many"
    mercs ||--o{ character_data : "One-to-One"
    mercs ||--o{ merc_spell_list_entries : "Has-Many"
    mercs ||--o{ merc_stance_entries : "Has-Many"
    mercs ||--o{ merc_templates : "One-to-One"

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