bot_data

Relationships

erDiagram
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    }
    bot_guild_members {
        varchar bot_id
        varchar guild_id
    }
    bot_heal_rotation_members {
        varchar bot_id
        varchar heal_rotation_index
    }
    bot_inspect_messages {
        varchar bot_id
    }
    bot_inventories {
        varchar bot_id
        varchar item_id
        varchar augment_1
        varchar augment_2
        varchar augment_3
        varchar augment_4
        varchar augment_5
        varchar augment_6
    }
    bot_pets {
        varchar bot_id
        varchar pets_index
        varchar spell_id
    }
    bot_data ||--o{ bot_guild_members : "One-to-One"
    bot_data ||--o{ bot_heal_rotation_members : "Has-Many"
    bot_data ||--o{ bot_inspect_messages : "One-to-One"
    bot_data ||--o{ bot_inventories : "Has-Many"
    bot_data ||--o{ bot_pets : "One-to-One"

erDiagram
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    }
    bot_stances {
        varchar bot_id
        varchar stance_id
    }
    bot_timers {
        varchar bot_id
        varchar bot_data
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    npc_spells {
        intunsigned id
        intunsigned parent_list
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    bot_data ||--o{ bot_stances : "One-to-One"
    bot_data ||--o{ bot_timers : "Has-Many"
    bot_data ||--o{ character_data : "One-to-One"
    bot_data ||--o{ npc_spells : "One-to-One"
    bot_data ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	bot_id	bot_guild_members	bot_id
Has-Many	bot_id	bot_heal_rotation_members	bot_id
One-to-One	bot_id	bot_inspect_messages	bot_id
Has-Many	bot_id	bot_inventories	bot_id
One-to-One	bot_id	bot_pets	bot_id
One-to-One	bot_id	bot_stances	bot_id
Has-Many	bot_id	bot_timers	bot_id
One-to-One	owner_id	character_data	id
One-to-One	spells_id	npc_spells	id
One-to-One	zone_id	zone	zoneidnumber

Schema

Column	Data Type	Description
bot_id	int	Unique Bot Identifier
owner_id	int	Owner Character Identifier
spells_id	int	Bot Spell List Identifier
name	varchar	Name
last_name	varchar	Last Name
title	varchar	Title
suffix	varchar	Suffix
zone_id	smallint	Zone Identifier
gender	tinyint	Gender
race	smallint	Race
class	tinyint	Class
level	tinyint	Level
deity	int	Deity
creation_day	int	UNIX Timestamp of creation date
last_spawn	int	UNIX Timestamp of last spawn_conditions
time_spawned	int	Time spawned
size	float	Size
face	int	Face
hair_color	int	Hair Color
hair_style	int	Hair Style
beard	int	Beard
beard_color	int	Beard Color
eye_color_1	int	Eye Color 1
eye_color_2	int	Eye Color 2
drakkin_heritage	int	Drakkin Heritage
drakkin_tattoo	int	Drakkin Tattoo
drakkin_details	int	Drakkin Details
ac	smallint	Armor Class
atk	mediumint	Attack
hp	int	Health
mana	int	Mana
str	mediumint	Strength
sta	mediumint	Stamina
cha	mediumint	Charisma
dex	mediumint	Dexterity
int	mediumint	Intelligence
agi	mediumint	Agility
wis	mediumint	Wisdom
fire	smallint	Fire Resistance
cold	smallint	Cold Resistance
magic	smallint	Magic Resistance
poison	smallint	Poison Resistance
disease	smallint	Disease Resistance
corruption	smallint	Corruption Resistance
show_helm	int	Show Helm: 0 = False, 1= True
follow_distance	int	Follow Distance
stop_melee_level	tinyint	Stop Melee Level
expansion_bitmask	int	Expansion Bitmask
enforce_spell_settings	tinyint	Enforce Spell Settings: 0 = False, 1 = True
archery_setting	tinyint	Archery Setting: 0 = False, 1 = True
caster_range	int	Caster Range