bot_data¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
One-to-One | bot_id | bot_group_members | bot_id |
One-to-One | bot_id | bot_group_leaderss | group_leader_id |
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 | |
enforce_spell_settings | tinyint | |
archery_setting | tinyint | |
caster_range | int |