Skip to content

bot_pets

Relationships

erDiagram
    bot_pets {
        varchar bot_id
        varchar pets_index
        varchar spell_id
    }
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    }
    bot_pet_buffs {
        varchar pets_index
        varchar spell_id
    }
    bot_pet_inventories {
        varchar pets_index
        varchar item_id
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    bot_pets ||--o{ bot_data : "One-to-One"
    bot_pets ||--o{ bot_pet_buffs : "Has-Many"
    bot_pets ||--o{ bot_pet_inventories : "Has-Many"
    bot_pets ||--o{ spells_new : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One bot_id bot_data bot_id
Has-Many pets_index bot_pet_buffs pets_index
Has-Many pets_index bot_pet_inventories pets_index
One-to-One spell_id spells_new id

Schema

Column Data Type Description
pets_index int Unique Bot Pet Identifier
spell_id int Spell Identifier
bot_id int Bot Identifier
name varchar Name
mana int Mana
hp int Health