Skip to content



    character_pet_info {
        int char_id
        int spell_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    character_pet_info ||--o{ character_data : "One-to-One"
    character_pet_info ||--o{ spells_new : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
One-to-One spell_id spells_new id


Column Data Type Description
char_id int Character Identifier
pet int Pet
petname varchar Pet Name
petpower int Pet Power
spell_id int Spell Identifier
hp int Health
mana int Mana
size float Size
taunting tinyint Taunting: 0 = False, 1 = True