database-schema-reference.yml

aa_ability:
  id:
    dataType: int
    nullable: NO
    description: Unique AA Identifier
  name:
    dataType: text
    nullable: NO
    description: Name
  category:
    dataType: int
    nullable: NO
    description: >-
      [AA
      Category](https://eqemu.gitbook.io/server/categories/aas/aa-categories)
  classes:
    dataType: int
    nullable: NO
    description: >-
      [Classes](https://eqemu.gitbook.io/server/categories/player/class-list)
      Bitmasks
  races:
    dataType: int
    nullable: NO
    description: '[Races](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  drakkin_heritage:
    dataType: int
    nullable: NO
    description: 'Drakkin Heritage: 127 = All'
  deities:
    dataType: int
    nullable: NO
    description: '[Deities](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  status:
    dataType: int
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  type:
    dataType: int
    nullable: NO
    description: '[AA Type](https://eqemu.gitbook.io/server/categories/aas/aa-types)'
  charges:
    dataType: int
    nullable: NO
    description: Number of Charges
  grant_only:
    dataType: tinyint
    nullable: NO
    description: 'Grant Only Flag: 0 = No, 1 = Yes'
  first_rank_id:
    dataType: int
    nullable: NO
    description: First Rank Identifier
  enabled:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = No, 1 = Yes'
  reset_on_death:
    dataType: tinyint
    nullable: NO
    description: ''
aa_actions:
  aaid:
    dataType: mediumint
    nullable: NO
    description: AA Identifier
  rank:
    dataType: tinyint
    nullable: NO
    description: 'Rank: Starts at 0'
  reuse_time:
    dataType: mediumint
    nullable: NO
    description: Reuse timer in seconds
  spell_id:
    dataType: mediumint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  target:
    dataType: tinyint
    nullable: NO
    description: >-
      [AA Target
      Type](https://eqemu.gitbook.io/server/categories/aas/aa-target-types)
  nonspell_action:
    dataType: tinyint
    nullable: NO
    description: >-
      [AA Nonspell
      Action](https://eqemu.gitbook.io/server/categories/aas/aa-nonspell-actions)
  nonspell_mana:
    dataType: mediumint
    nullable: NO
    description: Mana that the nonspell action consumes.
  nonspell_duration:
    dataType: mediumint
    nullable: NO
    description: Duration which may be used by the nonspell action.
  redux_aa:
    dataType: mediumint
    nullable: NO
    description: The AA which reduces the reuse timer of the skill.
  redux_rate:
    dataType: tinyint
    nullable: NO
    description: 'The multiplier of redux_aa, as a percentage of total rate.'
  redux_aa2:
    dataType: mediumint
    nullable: NO
    description: The second AA which reduces the reuse timer of the skill.
  redux_rate2:
    dataType: tinyint
    nullable: NO
    description: 'The multiplier of redux_aa2, as a percentage of total rate.'
aa_effects:
  id:
    dataType: int
    nullable: NO
    description: Unique Entry Identifier
  aaid:
    dataType: mediumint
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  effectid:
    dataType: mediumint
    nullable: NO
    description: >-
      [Spell Effect
      Identifier](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  base1:
    dataType: mediumint
    nullable: NO
    description: First Base Value
  base2:
    dataType: mediumint
    nullable: NO
    description: Second Base Value
aa_ranks:
  id:
    dataType: int
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  upper_hotkey_sid:
    dataType: int
    nullable: NO
    description: Upper Hotkey SID
  lower_hotkey_sid:
    dataType: int
    nullable: NO
    description: Lower Hotkey SID
  title_sid:
    dataType: int
    nullable: NO
    description: Title SID
  desc_sid:
    dataType: int
    nullable: NO
    description: Description SID
  cost:
    dataType: int
    nullable: NO
    description: Cost in AA Points
  level_req:
    dataType: int
    nullable: NO
    description: Level Required
  spell:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  spell_type:
    dataType: int
    nullable: NO
    description: >-
      [Spell
      Type](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  recast_time:
    dataType: int
    nullable: NO
    description: Recast Timer
  expansion:
    dataType: int
    nullable: NO
    description: >-
      [Expansion
      Identifier](https://eqemu.gitbook.io/server/categories/operation/expansion-list)
  prev_id:
    dataType: int
    nullable: NO
    description: Previous Rank Identifier
  next_id:
    dataType: int
    nullable: NO
    description: Next Rank Identifier
aa_rank_effects:
  rank_id:
    dataType: int
    nullable: NO
    description: '[Rank Identifier](aa_ranks.md)'
  slot:
    dataType: int
    nullable: NO
    description: AA Slot
  effect_id:
    dataType: int
    nullable: NO
    description: >-
      [Spell Effect
      Identifier](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  base1:
    dataType: int
    nullable: NO
    description: First Base Value
  base2:
    dataType: int
    nullable: NO
    description: Second Base Value
aa_rank_prereqs:
  rank_id:
    dataType: int
    nullable: NO
    description: '[Rank Identifier](aa_ranks.md)'
  aa_id:
    dataType: int
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  points:
    dataType: int
    nullable: NO
    description: Cost in AA Points
aa_required_level_cost:
  skill_id:
    dataType: int
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  level:
    dataType: int
    nullable: NO
    description: Required Level
  cost:
    dataType: int
    nullable: NO
    description: Cost in AA Points
  description:
    dataType: varchar
    nullable: YES
    description: Name of AA
aa_timers:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  ability:
    dataType: smallint
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  begin:
    dataType: int
    nullable: NO
    description: When the timer began.
  end:
    dataType: int
    nullable: NO
    description: When the timer ends.
account:
  id:
    dataType: int
    nullable: NO
    description: Unique Account Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  charname:
    dataType: varchar
    nullable: NO
    description: Character name last logged in on this account.
  sharedplat:
    dataType: int
    nullable: NO
    description: Platinum in Shared Bank.
  password:
    dataType: varchar
    nullable: NO
    description: Private loginserver password.
  status:
    dataType: int
    nullable: NO
    description: '[Status](https://eqemu.gitbook.io/server/categories/player/status-levels)'
  lsaccount_id:
    dataType: int
    nullable: YES
    description: Loginserver Account Identifier
  gmspeed:
    dataType: tinyint
    nullable: NO
    description: 'GM Speed: 0 = Disabled, 1 = Enabled'
  revoked:
    dataType: tinyint
    nullable: NO
    description: 'OOC Revoked: 0 = False, 1 = True'
  karma:
    dataType: int
    nullable: NO
    description: Karma
  minilogin_ip:
    dataType: varchar
    nullable: NO
    description: Minilogin IP Address
  hideme:
    dataType: tinyint
    nullable: NO
    description: 'Hide Me: 0 = Disabled, 1 = Enabled'
  rulesflag:
    dataType: tinyint
    nullable: NO
    description: Rules Flag
  suspendeduntil:
    dataType: datetime
    nullable: NO
    description: Time Suspension of the Account ends
  time_creation:
    dataType: int
    nullable: NO
    description: Time Creation UNIX Timestamp
  expansion:
    dataType: tinyint
    nullable: NO
    description: Expansion
  ban_reason:
    dataType: text
    nullable: YES
    description: Ban Reason
  suspend_reason:
    dataType: text
    nullable: YES
    description: Suspension Reason
  ls_id:
    dataType: varchar
    nullable: YES
    description: ''
account_flags:
  p_accid:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  p_flag:
    dataType: varchar
    nullable: NO
    description: Name
  p_value:
    dataType: varchar
    nullable: NO
    description: Value
account_ip:
  accid:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  ip:
    dataType: varchar
    nullable: NO
    description: IP Address
  count:
    dataType: int
    nullable: NO
    description: Number of times logged in from this IP
  lastused:
    dataType: timestamp
    nullable: NO
    description: Timestamp of when account was last logged in
account_rewards:
  account_id:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  reward_id:
    dataType: int
    nullable: NO
    description: '[Veteran Reward Identifier](veteran_reward_templates.md)'
  amount:
    dataType: int
    nullable: NO
    description: Amount
adventure_details:
  id:
    dataType: int
    nullable: NO
    description: Unique Entry Identifier
  adventure_id:
    dataType: smallint
    nullable: NO
    description: Unique Adventure Identifier
  instance_id:
    dataType: int
    nullable: NO
    description: '[Instance Identifier](instance_list.md)'
  count:
    dataType: smallint
    nullable: NO
    description: Count
  assassinate_count:
    dataType: smallint
    nullable: NO
    description: Assassinate Count
  status:
    dataType: tinyint
    nullable: NO
    description: Status
  time_created:
    dataType: int
    nullable: NO
    description: Time Created UNIX Timestamp
  time_zoned:
    dataType: int
    nullable: NO
    description: Time Zoned UNIX Timestamp
  time_completed:
    dataType: int
    nullable: NO
    description: Time Completed UNIX Timestamp
adventure_members:
  id:
    dataType: int
    nullable: NO
    description: '[Adventure Identifier](adventure_details.md)'
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
adventure_stats:
  player_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  guk_wins:
    dataType: mediumint
    nullable: NO
    description: Deepest Guk Wins
  mir_wins:
    dataType: mediumint
    nullable: NO
    description: Miragul's Menagerie Wins
  mmc_wins:
    dataType: mediumint
    nullable: NO
    description: Mistmoore Catacombs Wins
  ruj_wins:
    dataType: mediumint
    nullable: NO
    description: Rujarkian Hills Wins
  tak_wins:
    dataType: mediumint
    nullable: NO
    description: Takish-Hiz Wins
  guk_losses:
    dataType: mediumint
    nullable: NO
    description: Deepest Guk Losses
  mir_losses:
    dataType: mediumint
    nullable: NO
    description: Miragul's Menagerie Losses
  mmc_losses:
    dataType: mediumint
    nullable: NO
    description: Mistmoore Catacombs Losses
  ruj_losses:
    dataType: mediumint
    nullable: NO
    description: Rujarkian Hills Losses
  tak_losses:
    dataType: mediumint
    nullable: NO
    description: Takish-Hiz Losses
adventure_template:
  id:
    dataType: int
    nullable: NO
    description: '[Adventure Identifier](adventure_details.md)'
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  zone_version:
    dataType: tinyint
    nullable: NO
    description: Zone Version
  is_hard:
    dataType: tinyint
    nullable: NO
    description: 'Hard: 0 = False, 1 = True'
  is_raid:
    dataType: tinyint
    nullable: NO
    description: 'Raid: 0 = False, 1 = True'
  min_level:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  max_level:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  type:
    dataType: tinyint
    nullable: NO
    description: Type
  type_data:
    dataType: int
    nullable: NO
    description: Type Data
  type_count:
    dataType: smallint
    nullable: NO
    description: Type Count
  assa_x:
    dataType: float
    nullable: NO
    description: Assassination X Coordinate
  assa_y:
    dataType: float
    nullable: NO
    description: Assassination Y Coordinate
  assa_z:
    dataType: float
    nullable: NO
    description: Assassination Z Coordinate
  assa_h:
    dataType: float
    nullable: NO
    description: Assassination Heading Coordinate
  text:
    dataType: varchar
    nullable: YES
    description: Text
  duration:
    dataType: int
    nullable: NO
    description: Duration
  zone_in_time:
    dataType: int
    nullable: NO
    description: Zone In Duration
  win_points:
    dataType: smallint
    nullable: NO
    description: LDoN Points for Winning
  lose_points:
    dataType: smallint
    nullable: NO
    description: LDoN Points for Losing
  theme:
    dataType: tinyint
    nullable: NO
    description: '[LDoN Theme](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)'
  zone_in_zone_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Zone In Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  zone_in_x:
    dataType: float
    nullable: NO
    description: Zone In X Coordinate
  zone_in_y:
    dataType: float
    nullable: NO
    description: Zone In Y Coordinate
  zone_in_object_id:
    dataType: smallint
    nullable: NO
    description: Zone In Object Identifier
  dest_x:
    dataType: float
    nullable: NO
    description: Destination X Coordinate
  dest_y:
    dataType: float
    nullable: NO
    description: Destination Y Coordinate
  dest_z:
    dataType: float
    nullable: NO
    description: Destination Z Coordinate
  dest_h:
    dataType: float
    nullable: NO
    description: Destination Heading Coordinate
  graveyard_zone_id:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  graveyard_x:
    dataType: float
    nullable: NO
    description: Graveyard X Coordinate
  graveyard_y:
    dataType: float
    nullable: NO
    description: Graveyard Y Coordinate
  graveyard_z:
    dataType: float
    nullable: NO
    description: Graveyard Z Coordinate
  graveyard_radius:
    dataType: float
    nullable: NO
    description: Graveyard Radius
adventure_template_entry:
  id:
    dataType: int
    nullable: NO
    description: '[Adventure Identifier](adventure_details.md)'
  template_id:
    dataType: int
    nullable: NO
    description: '[Template Identifier](adventure_template.md)'
adventure_template_entry_flavor:
  id:
    dataType: int
    nullable: NO
    description: '[Adventure Identifier](adventure_details.md)'
  text:
    dataType: varchar
    nullable: NO
    description: Text
altadv_vars:
  skill_id:
    dataType: int
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  name:
    dataType: varchar
    nullable: YES
    description: Name
  cost:
    dataType: int
    nullable: YES
    description: Cost
  max_level:
    dataType: int
    nullable: YES
    description: Maximum Level
  hotkey_sid:
    dataType: int
    nullable: NO
    description: Hotkey SID
  hotkey_sid2:
    dataType: int
    nullable: NO
    description: Hotkey SID 2
  title_sid:
    dataType: int
    nullable: NO
    description: Title SID
  desc_sid:
    dataType: int
    nullable: NO
    description: Description SID
  type:
    dataType: tinyint
    nullable: NO
    description: Type
  spellid:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  prereq_skill:
    dataType: int
    nullable: NO
    description: Prerequisite Skill Level
  prereq_minpoints:
    dataType: int
    nullable: NO
    description: Prerequisite Minimum Points
  spell_type:
    dataType: int
    nullable: NO
    description: >-
      [Spell
      Type](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  spell_refresh:
    dataType: int
    nullable: NO
    description: Spell Refresh
  classes:
    dataType: int
    nullable: NO
    description: '[Classes](https://eqemu.gitbook.io/server/categories/player/class-list)'
  berserker:
    dataType: int
    nullable: NO
    description: 'Berseker: 0 = False, 1 = True'
  class_type:
    dataType: int
    nullable: NO
    description: Level
  cost_inc:
    dataType: tinyint
    nullable: NO
    description: Cost Increase
  aa_expansion:
    dataType: smallint
    nullable: NO
    description: >-
      [AA Expansion
      Identifier](https://eqemu.gitbook.io/server/categories/operation/expansion-list)
  special_category:
    dataType: int
    nullable: NO
    description: Special Category
  sof_type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Secrets of Faydwer
      Type](https://eqemu.gitbook.io/server/categories/aas/aa-categories)
  sof_cost_inc:
    dataType: tinyint
    nullable: NO
    description: Secrets of Faydwer Cost Increase
  sof_max_level:
    dataType: tinyint
    nullable: NO
    description: Secrets of Faydwer Maximum Level
  sof_next_skill:
    dataType: int
    nullable: NO
    description: Secrets of Faydwer Next Skill
  clientver:
    dataType: tinyint
    nullable: NO
    description: >-
      [Client
      Version](https://eqemu.gitbook.io/server/categories/operation/expansion-list)
  account_time_required:
    dataType: int
    nullable: NO
    description: Account Time Required in Seconds
  sof_current_level:
    dataType: tinyint
    nullable: NO
    description: Secrets of Faydwer Current Level
  sof_next_id:
    dataType: int
    nullable: NO
    description: Secrets of Faydwer Next Identifier
  level_inc:
    dataType: tinyint
    nullable: NO
    description: Secrets of Faydwer Level Increase
alternate_currency:
  id:
    dataType: int
    nullable: NO
    description: >-
      [Alternate Currency
      Identifier](https://eqemu.gitbook.io/server/categories/items/alternate-currencies)
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
auras:
  type:
    dataType: int
    nullable: NO
    description: Unique Aura Identifier
  npc_type:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  name:
    dataType: varchar
    nullable: NO
    description: Name
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  distance:
    dataType: int
    nullable: NO
    description: Distance
  aura_type:
    dataType: int
    nullable: NO
    description: '[Aura Type](https://eqemu.gitbook.io/server/categories/spells/aura-types)'
  spawn_type:
    dataType: int
    nullable: NO
    description: >-
      [Aura Spawn
      Type](https://eqemu.gitbook.io/server/categories/spells/aura-spawn-types)
  movement:
    dataType: int
    nullable: NO
    description: >-
      [Aura Movement
      Type](https://eqemu.gitbook.io/server/categories/spells/aura-movement-types)
  duration:
    dataType: int
    nullable: NO
    description: Duration
  icon:
    dataType: int
    nullable: NO
    description: Icon
  cast_time:
    dataType: int
    nullable: NO
    description: Cast Time
banned_ips:
  ip_address:
    dataType: varchar
    nullable: NO
    description: '[IP Address](account_ip.md)'
  notes:
    dataType: varchar
    nullable: YES
    description: Ban reason
base_data:
  level:
    dataType: int
    nullable: NO
    description: Level
  class:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  hp:
    dataType: double
    nullable: NO
    description: Health
  mana:
    dataType: double
    nullable: NO
    description: Mana
  end:
    dataType: double
    nullable: NO
    description: Endurance
  unk1:
    dataType: double
    nullable: NO
    description: Unknown
  unk2:
    dataType: double
    nullable: NO
    description: Unknown
  hp_fac:
    dataType: double
    nullable: NO
    description: Health Factor
  mana_fac:
    dataType: double
    nullable: NO
    description: Mana Factor
  end_fac:
    dataType: double
    nullable: NO
    description: Endurance Factor
blocked_spells:
  id:
    dataType: int
    nullable: NO
    description: Unique Blocked Spells Identifier
  spellid:
    dataType: mediumint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Blocked Spell
      Type](https://eqemu.gitbook.io/server/categories/spells/blocked-spell-types)
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  x_diff:
    dataType: float
    nullable: NO
    description: X Radius
  y_diff:
    dataType: float
    nullable: NO
    description: Y Radius
  z_diff:
    dataType: float
    nullable: NO
    description: Z Radius
  message:
    dataType: varchar
    nullable: NO
    description: Message when blocked
  description:
    dataType: varchar
    nullable: NO
    description: Blocked spells description
books:
  name:
    dataType: varchar
    nullable: NO
    description: Unique Book Identifier
  txtfile:
    dataType: text
    nullable: NO
    description: >-
      The text in the book. ` Represents line spaces, `` is two line spaces, ```
      is three line spaces, etc. (13 lines per book page)
  language:
    dataType: int
    nullable: NO
    description: '[Language](https://eqemu.gitbook.io/server/categories/player/languages)'
bot_buffs:
  buffs_index:
    dataType: int
    nullable: NO
    description: Unique Entry Identifier
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  caster_level:
    dataType: tinyint
    nullable: NO
    description: Caster level
  duration_formula:
    dataType: int
    nullable: NO
    description: Duration Formula
  tics_remaining:
    dataType: int
    nullable: NO
    description: Tics Remaining
  poison_counters:
    dataType: int
    nullable: NO
    description: Poison Counter
  disease_counters:
    dataType: int
    nullable: NO
    description: Disease Counter
  curse_counters:
    dataType: int
    nullable: NO
    description: Curse Counter
  corruption_counters:
    dataType: int
    nullable: NO
    description: Corruption Counter
  numhits:
    dataType: int
    nullable: NO
    description: Number of Hits
  melee_rune:
    dataType: int
    nullable: NO
    description: Melee Rune
  magic_rune:
    dataType: int
    nullable: NO
    description: Magic Rune
  dot_rune:
    dataType: int
    nullable: NO
    description: Damage Over Time Rune
  persistent:
    dataType: tinyint
    nullable: NO
    description: 'Persistent: 0 = False, 1 = True'
  caston_x:
    dataType: int
    nullable: NO
    description: X Coordinate
  caston_y:
    dataType: int
    nullable: NO
    description: Y Coordinate
  caston_z:
    dataType: int
    nullable: NO
    description: Z Coordinate
  extra_di_chance:
    dataType: int
    nullable: NO
    description: Extra DI Chance
  instrument_mod:
    dataType: int
    nullable: NO
    description: Instrument Modifier
bot_command_settings:
  bot_command:
    dataType: varchar
    nullable: NO
    description: Unique Bot Command Identifier
  access:
    dataType: int
    nullable: NO
    description: '[Required Status](account.md)'
  aliases:
    dataType: varchar
    nullable: NO
    description: Aliases
bot_data:
  bot_id:
    dataType: int
    nullable: NO
    description: Unique Bot Identifier
  owner_id:
    dataType: int
    nullable: NO
    description: '[Owner Character Identifier](character_data.md)'
  spells_id:
    dataType: int
    nullable: NO
    description: >-
      [Bot Spell List
      Identifier](https://eqemu.gitbook.io/server/categories/spells/bot-spell-list-ids)
  name:
    dataType: varchar
    nullable: NO
    description: Name
  last_name:
    dataType: varchar
    nullable: NO
    description: Last Name
  title:
    dataType: varchar
    nullable: NO
    description: Title
  suffix:
    dataType: varchar
    nullable: NO
    description: Suffix
  zone_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  race:
    dataType: smallint
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  level:
    dataType: tinyint
    nullable: NO
    description: Level
  deity:
    dataType: int
    nullable: NO
    description: '[Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  creation_day:
    dataType: int
    nullable: NO
    description: UNIX Timestamp of creation date
  last_spawn:
    dataType: int
    nullable: NO
    description: UNIX Timestamp of last spawn_conditions
  time_spawned:
    dataType: int
    nullable: NO
    description: Time spawned
  size:
    dataType: float
    nullable: NO
    description: Size
  face:
    dataType: int
    nullable: NO
    description: Face
  hair_color:
    dataType: int
    nullable: NO
    description: Hair Color
  hair_style:
    dataType: int
    nullable: NO
    description: Hair Style
  beard:
    dataType: int
    nullable: NO
    description: Beard
  beard_color:
    dataType: int
    nullable: NO
    description: Beard Color
  eye_color_1:
    dataType: int
    nullable: NO
    description: Eye Color 1
  eye_color_2:
    dataType: int
    nullable: NO
    description: Eye Color 2
  drakkin_heritage:
    dataType: int
    nullable: NO
    description: Drakkin Heritage
  drakkin_tattoo:
    dataType: int
    nullable: NO
    description: Drakkin Tattoo
  drakkin_details:
    dataType: int
    nullable: NO
    description: Drakkin Details
  ac:
    dataType: smallint
    nullable: NO
    description: Armor Class
  atk:
    dataType: mediumint
    nullable: NO
    description: Attack
  hp:
    dataType: int
    nullable: NO
    description: Health
  mana:
    dataType: int
    nullable: NO
    description: Mana
  str:
    dataType: mediumint
    nullable: NO
    description: Strength
  sta:
    dataType: mediumint
    nullable: NO
    description: Stamina
  cha:
    dataType: mediumint
    nullable: NO
    description: Charisma
  dex:
    dataType: mediumint
    nullable: NO
    description: Dexterity
  int:
    dataType: mediumint
    nullable: NO
    description: Intelligence
  agi:
    dataType: mediumint
    nullable: NO
    description: Agility
  wis:
    dataType: mediumint
    nullable: NO
    description: Wisdom
  fire:
    dataType: smallint
    nullable: NO
    description: Fire Resistance
  cold:
    dataType: smallint
    nullable: NO
    description: Cold Resistance
  magic:
    dataType: smallint
    nullable: NO
    description: Magic Resistance
  poison:
    dataType: smallint
    nullable: NO
    description: Poison Resistance
  disease:
    dataType: smallint
    nullable: NO
    description: Disease Resistance
  corruption:
    dataType: smallint
    nullable: NO
    description: Corruption Resistance
  show_helm:
    dataType: int
    nullable: NO
    description: 'Show Helm: 0 = False, 1= True'
  follow_distance:
    dataType: int
    nullable: NO
    description: Follow Distance
  stop_melee_level:
    dataType: tinyint
    nullable: NO
    description: Stop Melee Level
bot_groups:
  groups_index:
    dataType: int
    nullable: NO
    description: Unique Group Identifier
  group_leader_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  group_name:
    dataType: varchar
    nullable: NO
    description: Group Name
bot_group_members:
  group_members_index:
    dataType: int
    nullable: NO
    description: Unique Group Member Identifier
  groups_index:
    dataType: int
    nullable: NO
    description: '[Group Identifier](bot_groups.md)'
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
bot_guild_members:
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  guild_id:
    dataType: mediumint
    nullable: NO
    description: '[Guild Identifier](guilds.md)'
  rank:
    dataType: tinyint
    nullable: NO
    description: >-
      [Guild
      Rank](https://eqemu.gitbook.io/server/categories/player/guild-ranks)
  tribute_enable:
    dataType: tinyint
    nullable: NO
    description: 'Tribute Enabled: 0 = False, 1= True'
  total_tribute:
    dataType: int
    nullable: NO
    description: Total Tribute
  last_tribute:
    dataType: int
    nullable: NO
    description: Last Tribute
  banker:
    dataType: tinyint
    nullable: NO
    description: 'Banker: 0 = False, 1 = True'
  public_note:
    dataType: text
    nullable: YES
    description: Public Note
  alt:
    dataType: tinyint
    nullable: NO
    description: 'Alt: 0 = False, 1 = True'
bot_heal_rotations:
  heal_rotation_index:
    dataType: int
    nullable: NO
    description: Unique Heal Rotation Identifier
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  interval:
    dataType: int
    nullable: NO
    description: Interval
  fast_heals:
    dataType: int
    nullable: NO
    description: Fast Heals
  adaptive_targeting:
    dataType: int
    nullable: NO
    description: Adaptive Targeting
  casting_override:
    dataType: int
    nullable: NO
    description: Casting Override
  safe_hp_base:
    dataType: float
    nullable: NO
    description: Safe Health Base
  safe_hp_cloth:
    dataType: float
    nullable: NO
    description: Safe Health Cloth
  safe_hp_leather:
    dataType: float
    nullable: NO
    description: Safe Health Leather
  safe_hp_chain:
    dataType: float
    nullable: NO
    description: Safe Health Chain
  safe_hp_plate:
    dataType: float
    nullable: NO
    description: Safe Health Plate
  critical_hp_base:
    dataType: float
    nullable: NO
    description: Critical Health Base
  critical_hp_cloth:
    dataType: float
    nullable: NO
    description: Critical Health Cloth
  critical_hp_leather:
    dataType: float
    nullable: NO
    description: Critical Health Leather
  critical_hp_chain:
    dataType: float
    nullable: NO
    description: Critical Health Chain
  critical_hp_plate:
    dataType: float
    nullable: NO
    description: Critical Health Plate
bot_heal_rotation_members:
  member_index:
    dataType: int
    nullable: NO
    description: Unique Bot Heal Rotation Member Identifier
  heal_rotation_index:
    dataType: int
    nullable: NO
    description: '[Heal Rotation Identifier](bot_heal_rotations.md)'
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
bot_heal_rotation_targets:
  target_index:
    dataType: int
    nullable: NO
    description: Unique Bot Heal Rotation Target Identifier
  heal_rotation_index:
    dataType: int
    nullable: NO
    description: '[Heal Rotation Identifier](bot_heal_rotations.md)'
  target_name:
    dataType: varchar
    nullable: NO
    description: Target Name
bot_inspect_messages:
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  inspect_message:
    dataType: varchar
    nullable: NO
    description: Inspect Message
bot_inventories:
  inventories_index:
    dataType: int
    nullable: NO
    description: Unique Bot Inventory Identifier
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  slot_id:
    dataType: mediumint
    nullable: NO
    description: >-
      [Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  inst_charges:
    dataType: smallint
    nullable: YES
    description: Charges
  inst_color:
    dataType: int
    nullable: NO
    description: Color
  inst_no_drop:
    dataType: tinyint
    nullable: NO
    description: 'No Drop: 0 = False, 1=  True'
  inst_custom_data:
    dataType: text
    nullable: YES
    description: Custom Data
  ornament_icon:
    dataType: int
    nullable: NO
    description: Ornamentation Icon
  ornament_id_file:
    dataType: int
    nullable: NO
    description: Ornamentation Item Texture
  ornament_hero_model:
    dataType: int
    nullable: NO
    description: Ornamentation Hero's Forge Model
  augment_1:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 1
  augment_2:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 2
  augment_3:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 3
  augment_4:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 4
  augment_5:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 5
  augment_6:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 6
bot_owner_options:
  owner_id:
    dataType: int
    nullable: NO
    description: '[Owner Character Identifier](character_data.md)'
  death_marquee:
    dataType: smallint
    nullable: YES
    description: 'Death Marquee Message: 0 = False, 1 = True'
bot_pets:
  pets_index:
    dataType: int
    nullable: NO
    description: Unique Bot Pet Identifier
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  name:
    dataType: varchar
    nullable: YES
    description: Name
  mana:
    dataType: int
    nullable: NO
    description: Mana
  hp:
    dataType: int
    nullable: NO
    description: Health
bot_pet_buffs:
  pet_buffs_index:
    dataType: int
    nullable: NO
    description: Unique Bot Pet Buffs Identifier
  pets_index:
    dataType: int
    nullable: NO
    description: '[Bot Pet Identifier](bot_pets.md)'
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  caster_level:
    dataType: int
    nullable: NO
    description: Caster Level
  duration:
    dataType: int
    nullable: NO
    description: Duration of buff
bot_pet_inventories:
  pet_inventories_index:
    dataType: int
    nullable: NO
    description: Unique Bot Pet Inventory Identifier
  pets_index:
    dataType: int
    nullable: NO
    description: '[Bot Pet Identifier](bot_pets.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
bot_spells_entries:
  id:
    dataType: int
    nullable: NO
    description: Unique Bot Spell Entry Identifier
  npc_spells_id:
    dataType: int
    nullable: NO
    description: >-
      [Bot Spell List
      Identifier](https://eqemu.gitbook.io/server/categories/spells/bot-spell-list-ids)
  spellid:
    dataType: smallint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  type:
    dataType: int
    nullable: NO
    description: >-
      [Spell
      Type](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  manacost:
    dataType: smallint
    nullable: NO
    description: Mana Cost
  recast_delay:
    dataType: int
    nullable: NO
    description: Recast Delay
  priority:
    dataType: smallint
    nullable: NO
    description: 'Bot Spell Priority: Lower is better'
  resist_adjust:
    dataType: int
    nullable: YES
    description: Resist Adjustment
  min_hp:
    dataType: smallint
    nullable: YES
    description: Minimum Health Percentage
  max_hp:
    dataType: smallint
    nullable: YES
    description: Maximum Health Percentage
bot_spell_casting_chances:
  id:
    dataType: int
    nullable: NO
    description: Unique Bot Spell Casting Chance Identifier
  spell_type_index:
    dataType: tinyint
    nullable: NO
    description: >-
      [Spell Type
      Identifier](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  class_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  stance_index:
    dataType: tinyint
    nullable: NO
    description: >-
      [Stance Type
      Identifier](https://eqemu.gitbook.io/server/categories/bots/stance-types)
  nHSND_value:
    dataType: tinyint
    nullable: NO
    description: nHSND Value
  pH_value:
    dataType: tinyint
    nullable: NO
    description: pH Value
  pS_value:
    dataType: tinyint
    nullable: NO
    description: pS Value
  pHS_value:
    dataType: tinyint
    nullable: NO
    description: pHS Value
  pN_value:
    dataType: tinyint
    nullable: NO
    description: pN Value
  pHN_value:
    dataType: tinyint
    nullable: NO
    description: pHN Value
  pSN_value:
    dataType: tinyint
    nullable: NO
    description: pSN Value
  pHSN_value:
    dataType: tinyint
    nullable: NO
    description: pHSN Value
  pD_value:
    dataType: tinyint
    nullable: NO
    description: pD Value
  pHD_value:
    dataType: tinyint
    nullable: NO
    description: pHD Value
  pSD_value:
    dataType: tinyint
    nullable: NO
    description: pSD Value
  pHSD_value:
    dataType: tinyint
    nullable: NO
    description: pHSD Value
  pND_value:
    dataType: tinyint
    nullable: NO
    description: pND Value
  pHND_value:
    dataType: tinyint
    nullable: NO
    description: pHND Value
  pSND_value:
    dataType: tinyint
    nullable: NO
    description: pSND Value
  pHSND_value:
    dataType: tinyint
    nullable: NO
    description: pHSND Value
bot_stances:
  bot_id:
    dataType: int
    nullable: NO
    description: '[Bot Identifier](bot_data.md)'
  stance_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Stance
      Identifier](https://eqemu.gitbook.io/server/categories/bots/stance-types)
bot_timers:
  bot_id:
    dataType: int
    nullable: NO
    description: '[Unique Bot Identifier](bot_data.md)'
  timer_id:
    dataType: int
    nullable: NO
    description: Timer Identifier
  timer_value:
    dataType: int
    nullable: NO
    description: Timer Expiration
bugs:
  id:
    dataType: int
    nullable: NO
    description: Unique Bug Identifier
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  name:
    dataType: varchar
    nullable: NO
    description: Player Name
  ui:
    dataType: varchar
    nullable: NO
    description: UI
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  type:
    dataType: varchar
    nullable: NO
    description: Type
  flag:
    dataType: tinyint
    nullable: NO
    description: Flag
  target:
    dataType: varchar
    nullable: YES
    description: Target when reported
  bug:
    dataType: varchar
    nullable: NO
    description: Bug reported
  date:
    dataType: date
    nullable: NO
    description: Date when reported
  status:
    dataType: tinyint
    nullable: NO
    description: >-
      [Account Status of
      Reporter](https://eqemu.gitbook.io/server/categories/player/status-levels
bug_reports:
  id:
    dataType: int
    nullable: NO
    description: Unique Bug Report Identifier
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  client_version_id:
    dataType: int
    nullable: NO
    description: >-
      [Client Version
      Identifier](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
  client_version_name:
    dataType: varchar
    nullable: NO
    description: >-
      [Client Version
      Name](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
  account_id:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  character_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  character_name:
    dataType: varchar
    nullable: NO
    description: '[Character Name](character_data.md)'
  reporter_spoof:
    dataType: tinyint
    nullable: NO
    description: Reporter Spoof
  category_id:
    dataType: int
    nullable: NO
    description: Category Identifier
  category_name:
    dataType: varchar
    nullable: NO
    description: Category Name
  reporter_name:
    dataType: varchar
    nullable: NO
    description: Reporter Name
  ui_path:
    dataType: varchar
    nullable: NO
    description: UI Path
  pos_x:
    dataType: float
    nullable: NO
    description: Position X Coordinate
  pos_y:
    dataType: float
    nullable: NO
    description: Position Y Coordinate
  pos_z:
    dataType: float
    nullable: NO
    description: Position Z Coordinate
  heading:
    dataType: int
    nullable: NO
    description: Heading Coordinate
  time_played:
    dataType: int
    nullable: NO
    description: Time Played in Seconds
  target_id:
    dataType: int
    nullable: NO
    description: Target Identifier
  target_name:
    dataType: varchar
    nullable: NO
    description: Target Name
  optional_info_mask:
    dataType: int
    nullable: NO
    description: 'Optional Info Mask: 0 = False, 1 = True'
  _can_duplicate:
    dataType: tinyint
    nullable: NO
    description: 'Can Duplicate: 0 = False, 1 = True'
  _crash_bug:
    dataType: tinyint
    nullable: NO
    description: Crash Bug
  _target_info:
    dataType: tinyint
    nullable: NO
    description: Target Info
  _character_flags:
    dataType: tinyint
    nullable: NO
    description: Character Flags
  _unknown_value:
    dataType: tinyint
    nullable: NO
    description: Unknown
  bug_report:
    dataType: varchar
    nullable: NO
    description: Bug Report
  system_info:
    dataType: varchar
    nullable: NO
    description: System Information
  report_datetime:
    dataType: datetime
    nullable: NO
    description: Report Datetime
  bug_status:
    dataType: tinyint
    nullable: NO
    description: Bug Status
  last_review:
    dataType: datetime
    nullable: NO
    description: Last Review Datetime
  last_reviewer:
    dataType: varchar
    nullable: NO
    description: Last Reviewer
  reviewer_notes:
    dataType: varchar
    nullable: NO
    description: Reviewer Notes
buyer:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  buyslot:
    dataType: int
    nullable: NO
    description: Slot
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  itemname:
    dataType: varchar
    nullable: NO
    description: '[Item Name](items.md)'
  quantity:
    dataType: int
    nullable: NO
    description: Quantity
  price:
    dataType: int
    nullable: NO
    description: Price
character_activities:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
  activityid:
    dataType: int
    nullable: NO
    description: '[Activity Identifier](task_activities.md)'
  donecount:
    dataType: int
    nullable: NO
    description: Done Count
  completed:
    dataType: tinyint
    nullable: YES
    description: 'Completed: 0 = False, 1 = True'
character_alternate_abilities:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  aa_id:
    dataType: smallint
    nullable: NO
    description: '[AA Identifier](aa_ability.md)'
  aa_value:
    dataType: smallint
    nullable: NO
    description: AA Value
  charges:
    dataType: smallint
    nullable: NO
    description: Charges
character_alt_currency:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  currency_id:
    dataType: int
    nullable: NO
    description: '[Currency Identifier](alternate_currency.md)'
  amount:
    dataType: int
    nullable: NO
    description: Amount
character_auras:
  id:
    dataType: int
    nullable: NO
    description: '[Unique Character Identifier](character_data.md)'
  slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
character_bandolier:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  bandolier_id:
    dataType: tinyint
    nullable: NO
    description: Bandolier Identifier
  bandolier_slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  icon:
    dataType: int
    nullable: NO
    description: Icon
  bandolier_name:
    dataType: varchar
    nullable: NO
    description: Name
character_bind:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot:
    dataType: int
    nullable: NO
    description: Slot
  zone_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  instance_id:
    dataType: mediumint
    nullable: NO
    description: Instance Identifier
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
character_buffs:
  character_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot_id:
    dataType: tinyint
    nullable: NO
    description: Buff Slot
  spell_id:
    dataType: smallint
    nullable: NO
    description: '[Buff Spell Identifier](spells_new.md)'
  caster_level:
    dataType: tinyint
    nullable: NO
    description: Caster Level
  caster_name:
    dataType: varchar
    nullable: NO
    description: Caster Name
  ticsremaining:
    dataType: int
    nullable: NO
    description: Tics Remaining
  counters:
    dataType: int
    nullable: NO
    description: Counters
  numhits:
    dataType: int
    nullable: NO
    description: Number of Hits
  melee_rune:
    dataType: int
    nullable: NO
    description: Melee Rune
  magic_rune:
    dataType: int
    nullable: NO
    description: Magic Rune
  persistent:
    dataType: tinyint
    nullable: NO
    description: 'Persistent: 0 = False, 1 = True'
  dot_rune:
    dataType: int
    nullable: NO
    description: Damage Over Time Rune
  caston_x:
    dataType: int
    nullable: NO
    description: X Coordinate
  caston_y:
    dataType: int
    nullable: NO
    description: Y Coordinate
  caston_z:
    dataType: int
    nullable: NO
    description: Z Coordinate
  ExtraDIChance:
    dataType: int
    nullable: NO
    description: Extra DI Chance
  instrument_mod:
    dataType: int
    nullable: NO
    description: Instrument Modifier
character_corpses:
  id:
    dataType: int
    nullable: NO
    description: Unique Corpse Identifier
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  charname:
    dataType: varchar
    nullable: NO
    description: Character Name
  zone_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  instance_id:
    dataType: smallint
    nullable: NO
    description: Instance Identifier
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  time_of_death:
    dataType: datetime
    nullable: NO
    description: Time of Death
  is_rezzed:
    dataType: tinyint
    nullable: YES
    description: 'Is Rezzed: 0 = False, 1 = True'
  is_buried:
    dataType: tinyint
    nullable: NO
    description: 'Is Buried: 0 = False, 1 = True'
  was_at_graveyard:
    dataType: tinyint
    nullable: NO
    description: 'Was At Graveyard: 0 = False, 1 = True'
  is_locked:
    dataType: tinyint
    nullable: YES
    description: 'Is Locked: 0 = False, 1 = True'
  exp:
    dataType: int
    nullable: YES
    description: Experience
  size:
    dataType: int
    nullable: YES
    description: Size
  level:
    dataType: int
    nullable: YES
    description: Level
  race:
    dataType: int
    nullable: YES
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  gender:
    dataType: int
    nullable: YES
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  class:
    dataType: int
    nullable: YES
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  deity:
    dataType: int
    nullable: YES
    description: '[Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  texture:
    dataType: int
    nullable: YES
    description: '[Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  helm_texture:
    dataType: int
    nullable: YES
    description: '[Helm Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  copper:
    dataType: int
    nullable: YES
    description: Copper
  silver:
    dataType: int
    nullable: YES
    description: Silver
  gold:
    dataType: int
    nullable: YES
    description: Gold
  platinum:
    dataType: int
    nullable: YES
    description: Platinum
  hair_color:
    dataType: int
    nullable: YES
    description: Hair Color
  beard_color:
    dataType: int
    nullable: YES
    description: Beard Color
  eye_color_1:
    dataType: int
    nullable: YES
    description: Eye Color 1
  eye_color_2:
    dataType: int
    nullable: YES
    description: Eye Color 2
  hair_style:
    dataType: int
    nullable: YES
    description: Hair Style
  face:
    dataType: int
    nullable: YES
    description: Face
  beard:
    dataType: int
    nullable: YES
    description: Beard
  drakkin_heritage:
    dataType: int
    nullable: YES
    description: Drakkin Heritage
  drakkin_tattoo:
    dataType: int
    nullable: YES
    description: Drakkin Tattoo
  drakkin_details:
    dataType: int
    nullable: YES
    description: Drakkin Details
  wc_1:
    dataType: int
    nullable: YES
    description: Wear Change 1
  wc_2:
    dataType: int
    nullable: YES
    description: Wear Change 2
  wc_3:
    dataType: int
    nullable: YES
    description: Wear Change 3
  wc_4:
    dataType: int
    nullable: YES
    description: Wear Change 4
  wc_5:
    dataType: int
    nullable: YES
    description: Wear Change 5
  wc_6:
    dataType: int
    nullable: YES
    description: Wear Change 6
  wc_7:
    dataType: int
    nullable: YES
    description: Wear Change 7
  wc_8:
    dataType: int
    nullable: YES
    description: Wear Change 8
  wc_9:
    dataType: int
    nullable: YES
    description: Wear Change 9
  guild_consent_id:
    dataType: int
    nullable: NO
    description: ''
character_corpse_items:
  corpse_id:
    dataType: int
    nullable: NO
    description: '[Corpse Identifier](character_corpses.md)'
  equip_slot:
    dataType: int
    nullable: NO
    description: Equipment Slot
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: int
    nullable: YES
    description: Item Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Item Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Item Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Item Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Item Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Item Augment Slot 5
  aug_6:
    dataType: int
    nullable: NO
    description: Item Augment Slot 6
  attuned:
    dataType: smallint
    nullable: NO
    description: 'Item Attuned: 0 = False, 1 = True'
character_currency:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  platinum:
    dataType: int
    nullable: NO
    description: Platinum
  gold:
    dataType: int
    nullable: NO
    description: Gold
  silver:
    dataType: int
    nullable: NO
    description: Silver
  copper:
    dataType: int
    nullable: NO
    description: Copper
  platinum_bank:
    dataType: int
    nullable: NO
    description: Banked Platinum
  gold_bank:
    dataType: int
    nullable: NO
    description: Banked Gold
  silver_bank:
    dataType: int
    nullable: NO
    description: Banked Silver
  copper_bank:
    dataType: int
    nullable: NO
    description: Banked Copper
  platinum_cursor:
    dataType: int
    nullable: NO
    description: Cursor Platinum
  gold_cursor:
    dataType: int
    nullable: NO
    description: Cursor Gold
  silver_cursor:
    dataType: int
    nullable: NO
    description: Cursor Silver
  copper_cursor:
    dataType: int
    nullable: NO
    description: Cursor Copper
  radiant_crystals:
    dataType: int
    nullable: NO
    description: Radiant Crystals
  career_radiant_crystals:
    dataType: int
    nullable: NO
    description: Career Radiant Crystals
  ebon_crystals:
    dataType: int
    nullable: NO
    description: Ebon Crystals
  career_ebon_crystals:
    dataType: int
    nullable: NO
    description: Career Ebon Crystals
character_data:
  id:
    dataType: int
    nullable: NO
    description: Unique Character Identifier
  account_id:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  name:
    dataType: varchar
    nullable: NO
    description: Name
  last_name:
    dataType: varchar
    nullable: NO
    description: Last Name
  title:
    dataType: varchar
    nullable: NO
    description: Title
  suffix:
    dataType: varchar
    nullable: NO
    description: Suffix
  zone_id:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  zone_instance:
    dataType: int
    nullable: NO
    description: Zone Instance Identifier
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  race:
    dataType: smallint
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  level:
    dataType: int
    nullable: NO
    description: Level
  deity:
    dataType: int
    nullable: NO
    description: '[Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  birthday:
    dataType: int
    nullable: NO
    description: UNIX Timestamp of Birthday
  last_login:
    dataType: int
    nullable: NO
    description: UNIX Timestamp of Last Login
  time_played:
    dataType: int
    nullable: NO
    description: Time Played
  level2:
    dataType: tinyint
    nullable: NO
    description: Level 2
  anon:
    dataType: tinyint
    nullable: NO
    description: 'Anon: 0 = False, 1 = Anonymous, 2 = Roleplaying'
  gm:
    dataType: tinyint
    nullable: NO
    description: 'GM: 0 = False, 1 = True'
  face:
    dataType: int
    nullable: NO
    description: Face
  hair_color:
    dataType: tinyint
    nullable: NO
    description: Hair Color
  hair_style:
    dataType: tinyint
    nullable: NO
    description: Hair Style
  beard:
    dataType: tinyint
    nullable: NO
    description: Beard
  beard_color:
    dataType: tinyint
    nullable: NO
    description: Beard Color
  eye_color_1:
    dataType: tinyint
    nullable: NO
    description: Eye Color 1
  eye_color_2:
    dataType: tinyint
    nullable: NO
    description: Eye Color 2
  drakkin_heritage:
    dataType: int
    nullable: NO
    description: Drakkin Heritage
  drakkin_tattoo:
    dataType: int
    nullable: NO
    description: Drakkin Tattoo
  drakkin_details:
    dataType: int
    nullable: NO
    description: Drakkin Details
  ability_time_seconds:
    dataType: tinyint
    nullable: NO
    description: Ability Timer in Seconds
  ability_number:
    dataType: tinyint
    nullable: NO
    description: '[Ability Number](aa_ability.md)'
  ability_time_minutes:
    dataType: tinyint
    nullable: NO
    description: Ability Timer in Minutes
  ability_time_hours:
    dataType: tinyint
    nullable: NO
    description: Ability Timer in Hours
  exp:
    dataType: int
    nullable: NO
    description: Experience
  aa_points_spent:
    dataType: int
    nullable: NO
    description: AA Points Spent
  aa_exp:
    dataType: int
    nullable: NO
    description: AA Experience
  aa_points:
    dataType: int
    nullable: NO
    description: AA Points
  group_leadership_exp:
    dataType: int
    nullable: NO
    description: Group Leadership Experience
  raid_leadership_exp:
    dataType: int
    nullable: NO
    description: Raid Leadership Experience
  group_leadership_points:
    dataType: int
    nullable: NO
    description: Group Leadership Points
  raid_leadership_points:
    dataType: int
    nullable: NO
    description: Raid Leadership Points
  points:
    dataType: int
    nullable: NO
    description: Points
  cur_hp:
    dataType: int
    nullable: NO
    description: Health
  mana:
    dataType: int
    nullable: NO
    description: Mana
  endurance:
    dataType: int
    nullable: NO
    description: Endurance
  intoxication:
    dataType: int
    nullable: NO
    description: Intoxication
  str:
    dataType: int
    nullable: NO
    description: Strength
  sta:
    dataType: int
    nullable: NO
    description: Stamina
  cha:
    dataType: int
    nullable: NO
    description: Charisma
  dex:
    dataType: int
    nullable: NO
    description: Dexterity
  int:
    dataType: int
    nullable: NO
    description: Intelligence
  agi:
    dataType: int
    nullable: NO
    description: Agility
  wis:
    dataType: int
    nullable: NO
    description: Wisdom
  zone_change_count:
    dataType: int
    nullable: NO
    description: Zone Change Count
  toxicity:
    dataType: int
    nullable: NO
    description: Toxicity
  hunger_level:
    dataType: int
    nullable: NO
    description: Hunger Level
  thirst_level:
    dataType: int
    nullable: NO
    description: Thirst Level
  ability_up:
    dataType: int
    nullable: NO
    description: Ability Up
  ldon_points_guk:
    dataType: int
    nullable: NO
    description: >-
      LDoN Points - [Deepest
      Guk](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)
  ldon_points_mir:
    dataType: int
    nullable: NO
    description: >-
      LDoN Points - [Miragul's
      Menagerie](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)
  ldon_points_mmc:
    dataType: int
    nullable: NO
    description: >-
      LDoN Points - [Mistmoore
      Catacombs](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)
  ldon_points_ruj:
    dataType: int
    nullable: NO
    description: >-
      LDoN Points - [Rujarkian
      Hills](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)
  ldon_points_tak:
    dataType: int
    nullable: NO
    description: >-
      LDoN Points -
      [Takish-Hiz](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)
  ldon_points_available:
    dataType: int
    nullable: NO
    description: LDoN Points Available
  tribute_time_remaining:
    dataType: int
    nullable: NO
    description: Tribute Time Remaining
  career_tribute_points:
    dataType: int
    nullable: NO
    description: Career Tribute Points
  tribute_points:
    dataType: int
    nullable: NO
    description: Tribute Points
  tribute_active:
    dataType: int
    nullable: NO
    description: 'Tribute Active: 0 = False, 1 = True'
  pvp_status:
    dataType: tinyint
    nullable: NO
    description: 'PVP Status: 0 = False, 1 = True'
  pvp_kills:
    dataType: int
    nullable: NO
    description: PVP Kills
  pvp_deaths:
    dataType: int
    nullable: NO
    description: PVP Deaths
  pvp_current_points:
    dataType: int
    nullable: NO
    description: PVP Points
  pvp_career_points:
    dataType: int
    nullable: NO
    description: Career PVP Points
  pvp_best_kill_streak:
    dataType: int
    nullable: NO
    description: Best Kill Streak
  pvp_worst_death_streak:
    dataType: int
    nullable: NO
    description: Worse Death Streak
  pvp_current_kill_streak:
    dataType: int
    nullable: NO
    description: Current Kill Streak
  pvp2:
    dataType: int
    nullable: NO
    description: 'PVP Status: 0 = False, 1 = True'
  pvp_type:
    dataType: int
    nullable: NO
    description: PVP Type
  show_helm:
    dataType: int
    nullable: NO
    description: 'Show Helm: 0 = False, 1 = True'
  group_auto_consent:
    dataType: tinyint
    nullable: NO
    description: 'Group Auto Consent: 0 = False, 1 = True'
  raid_auto_consent:
    dataType: tinyint
    nullable: NO
    description: 'Raid Auto Consent: 0 = False, 1 = True'
  guild_auto_consent:
    dataType: tinyint
    nullable: NO
    description: 'Guild Auto Consent: 0 = False, 1 = True'
  leadership_exp_on:
    dataType: tinyint
    nullable: NO
    description: 'Leadership Experience On : 0 = False, 1 = True'
  RestTimer:
    dataType: int
    nullable: NO
    description: Rest Timer
  air_remaining:
    dataType: int
    nullable: NO
    description: Air Remaining
  autosplit_enabled:
    dataType: int
    nullable: NO
    description: 'Autosplit Enabled: 0 = False, 1 = True'
  lfp:
    dataType: tinyint
    nullable: NO
    description: 'Looking For Party: 0 = False, 1 = True'
  lfg:
    dataType: tinyint
    nullable: NO
    description: 'Looking For Guild: 0 = False, 1 = True'
  mailkey:
    dataType: char
    nullable: NO
    description: Mail Key
  xtargets:
    dataType: tinyint
    nullable: NO
    description: XTargets
  firstlogon:
    dataType: tinyint
    nullable: NO
    description: First Logon
  e_aa_effects:
    dataType: int
    nullable: NO
    description: Experience AA Effects
  e_percent_to_aa:
    dataType: int
    nullable: NO
    description: Experience Percentage to AA Points
  e_expended_aa_spent:
    dataType: int
    nullable: NO
    description: Expended AA Points Spent
  aa_points_spent_old:
    dataType: int
    nullable: NO
    description: AA Points Spent Old
  aa_points_old:
    dataType: int
    nullable: NO
    description: AA Points Old
  e_last_invsnapshot:
    dataType: int
    nullable: NO
    description: Last Inventory Snapshot
  deleted_at:
    dataType: datetime
    nullable: YES
    description: ''
character_disciplines:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot_id:
    dataType: smallint
    nullable: NO
    description: Slot Identifier
  disc_id:
    dataType: smallint
    nullable: NO
    description: '[Discipline Identifier](spells_new.md)'
character_enabledtasks:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
character_inspect_messages:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  inspect_message:
    dataType: varchar
    nullable: NO
    description: Inspect Message
character_item_recast:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  recast_type:
    dataType: smallint
    nullable: NO
    description: Recast Type
  timestamp:
    dataType: int
    nullable: NO
    description: Recast Timestamp
character_languages:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  lang_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Language
      Identifier](https://eqemu.gitbook.io/server/categories/player/languages)
  value:
    dataType: smallint
    nullable: NO
    description: Skill Level
character_leadership_abilities:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot:
    dataType: smallint
    nullable: NO
    description: Slot
  rank:
    dataType: smallint
    nullable: NO
    description: Rank
character_material:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  blue:
    dataType: tinyint
    nullable: NO
    description: 'Blue: 0 = None, 255 = Max'
  green:
    dataType: tinyint
    nullable: NO
    description: 'Green: 0 = None, 255 = Max'
  red:
    dataType: tinyint
    nullable: NO
    description: 'Red: 0 = None, 255 = Max'
  use_tint:
    dataType: tinyint
    nullable: NO
    description: 'Tint: 0 = None, 255 = MAx'
  color:
    dataType: int
    nullable: NO
    description: Color
character_memmed_spells:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot_id:
    dataType: smallint
    nullable: NO
    description: Slot Identifier
  spell_id:
    dataType: smallint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
character_pet_buffs:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  pet:
    dataType: int
    nullable: NO
    description: Pet
  slot:
    dataType: int
    nullable: NO
    description: Slot
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  caster_level:
    dataType: tinyint
    nullable: NO
    description: Caster Level
  castername:
    dataType: varchar
    nullable: NO
    description: Caster Name
  ticsremaining:
    dataType: int
    nullable: NO
    description: Tics Remaining
  counters:
    dataType: int
    nullable: NO
    description: Counters
  numhits:
    dataType: int
    nullable: NO
    description: Number of Hits
  rune:
    dataType: int
    nullable: NO
    description: Rune
  instrument_mod:
    dataType: tinyint
    nullable: NO
    description: Instrument Modifier
character_pet_info:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  pet:
    dataType: int
    nullable: NO
    description: Pet
  petname:
    dataType: varchar
    nullable: NO
    description: Pet Name
  petpower:
    dataType: int
    nullable: NO
    description: Pet Power
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  hp:
    dataType: int
    nullable: NO
    description: Health
  mana:
    dataType: int
    nullable: NO
    description: Mana
  size:
    dataType: float
    nullable: NO
    description: Size
character_pet_inventory:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  pet:
    dataType: int
    nullable: NO
    description: Pet
  slot:
    dataType: int
    nullable: NO
    description: Slot
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
character_potionbelt:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  potion_id:
    dataType: tinyint
    nullable: NO
    description: Potion Identifier
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  icon:
    dataType: int
    nullable: NO
    description: Icon
character_skills:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  skill_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Skill
      Identifier](https://eqemu.gitbook.io/server/categories/player/skills)
  value:
    dataType: smallint
    nullable: NO
    description: Skill Level
character_spells:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slot_id:
    dataType: smallint
    nullable: NO
    description: Slot Identifier
  spell_id:
    dataType: smallint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
character_tasks:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
  slot:
    dataType: int
    nullable: NO
    description: Slot
  type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Task
      Type](https://eqemu.gitbook.io/server/categories/task-system-guide/task-types)
  acceptedtime:
    dataType: int
    nullable: YES
    description: Accepted Time UNIX Timestamp
character_tribute:
  id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  tier:
    dataType: tinyint
    nullable: NO
    description: Tier
  tribute:
    dataType: int
    nullable: NO
    description: Tribute
char_create_combinations:
  allocation_id:
    dataType: int
    nullable: NO
    description: '[Allocation Identifier](char_create_point_allocations.md)'
  race:
    dataType: int
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  class:
    dataType: int
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  deity:
    dataType: int
    nullable: NO
    description: '[Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  start_zone:
    dataType: int
    nullable: NO
    description: >-
      [Start Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  expansions_req:
    dataType: int
    nullable: NO
    description: >-
      [Expansions
      Required](https://eqemu.gitbook.io/server/categories/operation/expansion-bitmasks)
char_create_point_allocations:
  id:
    dataType: int
    nullable: NO
    description: Allocation Identifier
  base_str:
    dataType: int
    nullable: NO
    description: Base Strength
  base_sta:
    dataType: int
    nullable: NO
    description: Base Stamina
  base_dex:
    dataType: int
    nullable: NO
    description: Base Dexterity
  base_agi:
    dataType: int
    nullable: NO
    description: Base Agility
  base_int:
    dataType: int
    nullable: NO
    description: Base Intelligence
  base_wis:
    dataType: int
    nullable: NO
    description: Base Wisdom
  base_cha:
    dataType: int
    nullable: NO
    description: Base Charisma
  alloc_str:
    dataType: int
    nullable: NO
    description: Allocated Strength
  alloc_sta:
    dataType: int
    nullable: NO
    description: Allocated Stamina
  alloc_dex:
    dataType: int
    nullable: NO
    description: Allocated Dexterity
  alloc_agi:
    dataType: int
    nullable: NO
    description: Allocated Agility
  alloc_int:
    dataType: int
    nullable: NO
    description: Allocated Intelligence
  alloc_wis:
    dataType: int
    nullable: NO
    description: Allocated Wisdom
  alloc_cha:
    dataType: int
    nullable: NO
    description: Allocated Charisma
char_recipe_list:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  recipe_id:
    dataType: int
    nullable: NO
    description: '[Recipe Identifier](tradeskill_recipe.md)'
  madecount:
    dataType: int
    nullable: NO
    description: Made Count
chatchannels:
  name:
    dataType: varchar
    nullable: NO
    description: Name
  owner:
    dataType: varchar
    nullable: NO
    description: '[Owner Character Identifier](character_data.md)'
  password:
    dataType: varchar
    nullable: NO
    description: Password
  minstatus:
    dataType: int
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
class_skill:
  class:
    dataType: smallint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  name:
    dataType: varchar
    nullable: NO
    description: '[Name](https://eqemu.gitbook.io/server/categories/player/class-list)'
  skill_0:
    dataType: smallint
    nullable: YES
    description: Required Level for 1H Blunt
  skill_1:
    dataType: smallint
    nullable: YES
    description: Required Level for 1H Slashing
  skill_2:
    dataType: smallint
    nullable: YES
    description: Required Level for 2H Blunt
  skill_3:
    dataType: smallint
    nullable: YES
    description: Required Level for 2H Slashing
  skill_4:
    dataType: smallint
    nullable: YES
    description: Required Level for Abjuration
  skill_5:
    dataType: smallint
    nullable: YES
    description: Required Level for Alteration
  skill_6:
    dataType: smallint
    nullable: YES
    description: Required Level for Apply Poison
  skill_7:
    dataType: smallint
    nullable: YES
    description: Required Level for Archery
  skill_8:
    dataType: smallint
    nullable: YES
    description: Required Level for Backstab
  skill_9:
    dataType: smallint
    nullable: YES
    description: Required Level for Bind Wound
  skill_10:
    dataType: smallint
    nullable: YES
    description: Required Level for Bash
  skill_11:
    dataType: smallint
    nullable: YES
    description: Required Level for Block
  skill_12:
    dataType: smallint
    nullable: YES
    description: Required Level for Brass Instruments
  skill_13:
    dataType: smallint
    nullable: YES
    description: Required Level for Channeling
  skill_14:
    dataType: smallint
    nullable: YES
    description: Required Level for Conjuration
  skill_15:
    dataType: smallint
    nullable: YES
    description: Required Level for Defense
  skill_16:
    dataType: smallint
    nullable: YES
    description: Required Level for Disarm
  skill_17:
    dataType: smallint
    nullable: YES
    description: Required Level for Disarm Traps
  skill_18:
    dataType: smallint
    nullable: YES
    description: Required Level for Divination
  skill_19:
    dataType: smallint
    nullable: YES
    description: Required Level for Dodge
  skill_20:
    dataType: smallint
    nullable: YES
    description: Required Level for Double Attack
  skill_21:
    dataType: smallint
    nullable: YES
    description: Required Level for Dragon Punch
  skill_22:
    dataType: smallint
    nullable: YES
    description: Required Level for Dual Wield
  skill_23:
    dataType: smallint
    nullable: YES
    description: Required Level for Eagle Strike
  skill_24:
    dataType: smallint
    nullable: YES
    description: Required Level for Evocation
  skill_25:
    dataType: smallint
    nullable: YES
    description: Required Level for Feign Death
  skill_26:
    dataType: smallint
    nullable: YES
    description: Required Level for Flying Kick
  skill_27:
    dataType: smallint
    nullable: YES
    description: Required Level for Forage
  skill_28:
    dataType: smallint
    nullable: YES
    description: Required Level for Hand to Hand
  skill_29:
    dataType: smallint
    nullable: YES
    description: Required Level for Hide
  skill_30:
    dataType: smallint
    nullable: YES
    description: Required Level for Kick
  skill_31:
    dataType: smallint
    nullable: YES
    description: Required Level for Meditate
  skill_32:
    dataType: smallint
    nullable: YES
    description: Required Level for Mend
  skill_33:
    dataType: smallint
    nullable: YES
    description: Required Level for Offense
  skill_34:
    dataType: smallint
    nullable: YES
    description: Required Level for Parry
  skill_35:
    dataType: smallint
    nullable: YES
    description: Required Level for Pick Lock
  skill_36:
    dataType: smallint
    nullable: YES
    description: Required Level for 1H Piercing
  skill_37:
    dataType: smallint
    nullable: YES
    description: Required Level for Riposte
  skill_38:
    dataType: smallint
    nullable: YES
    description: Required Level for Round Kick
  skill_39:
    dataType: smallint
    nullable: YES
    description: Required Level for Safe Fall
  skill_40:
    dataType: smallint
    nullable: YES
    description: Required Level for Sense Heading
  skill_41:
    dataType: smallint
    nullable: YES
    description: Required Level for Singing
  skill_42:
    dataType: smallint
    nullable: YES
    description: Required Level for Sneak
  skill_43:
    dataType: smallint
    nullable: YES
    description: Required Level for Abjuration Specialization
  skill_44:
    dataType: smallint
    nullable: YES
    description: Required Level for Alteration Specialization
  skill_45:
    dataType: smallint
    nullable: YES
    description: Required Level for Conjuration Specialization
  skill_46:
    dataType: smallint
    nullable: YES
    description: Required Level for Divination Specialization
  skill_47:
    dataType: smallint
    nullable: YES
    description: Required Level for Evocation Specialization
  skill_48:
    dataType: smallint
    nullable: YES
    description: Required Level for Pick Pocket
  skill_49:
    dataType: smallint
    nullable: YES
    description: Required Level for Stringed Instruments
  skill_50:
    dataType: smallint
    nullable: YES
    description: Required Level for Swimming
  skill_51:
    dataType: smallint
    nullable: YES
    description: Required Level for Throwing
  skill_52:
    dataType: smallint
    nullable: YES
    description: Required Level for Tiger Claw
  skill_53:
    dataType: smallint
    nullable: YES
    description: Required Level for Tracking
  skill_54:
    dataType: smallint
    nullable: YES
    description: Required Level for Wind Instruments
  skill_55:
    dataType: smallint
    nullable: YES
    description: Required Level for Fishing
  skill_56:
    dataType: smallint
    nullable: YES
    description: Required Level for Make Poison
  skill_57:
    dataType: smallint
    nullable: YES
    description: Required Level for Tinkering
  skill_58:
    dataType: smallint
    nullable: YES
    description: Required Level for Research
  skill_59:
    dataType: smallint
    nullable: YES
    description: Required Level for Alchemy
  skill_60:
    dataType: smallint
    nullable: YES
    description: Required Level for Baking
  skill_61:
    dataType: smallint
    nullable: YES
    description: Required Level for Tailoring
  skill_62:
    dataType: smallint
    nullable: YES
    description: Required Level for Sense Traps
  skill_63:
    dataType: smallint
    nullable: YES
    description: Required Level for Blacksmithing
  skill_64:
    dataType: smallint
    nullable: YES
    description: Required Level for Fletching
  skill_65:
    dataType: smallint
    nullable: YES
    description: Required Level for Brewing
  skill_66:
    dataType: smallint
    nullable: YES
    description: Required Level for Alcohol Tolerance
  skill_67:
    dataType: smallint
    nullable: YES
    description: Required Level for Begging
  skill_68:
    dataType: smallint
    nullable: YES
    description: Required Level for Jewelry Making
  skill_69:
    dataType: smallint
    nullable: YES
    description: Required Level for Pottery
  skill_70:
    dataType: smallint
    nullable: YES
    description: Required Level for Percussion Instruments
  skill_71:
    dataType: smallint
    nullable: YES
    description: Required Level for Intimidation
  skill_72:
    dataType: smallint
    nullable: YES
    description: Required Level for Berserking
  skill_73:
    dataType: smallint
    nullable: YES
    description: Required Level for Taunt
client_faction_associations:
  faction_id:
    dataType: int
    nullable: NO
    description: '[Faction Identifier](faction_list.md)'
  other_faction_id:
    dataType: int
    nullable: NO
    description: '[Other Faction Identifier](faction_list.md)'
  mod:
    dataType: int
    nullable: YES
    description: Modifier
client_faction_names:
  id:
    dataType: int
    nullable: NO
    description: '[Faction Identifier](faction_list.md)'
  name:
    dataType: varchar
    nullable: NO
    description: Name
client_server_faction_map:
  clientid:
    dataType: int
    nullable: NO
    description: '[Client Faction Identifier](faction_list.md)'
  serverid:
    dataType: int
    nullable: NO
    description: '[Server Faction Identifier](faction_list.md)'
command_settings:
  command:
    dataType: varchar
    nullable: NO
    description: Unique Command Identifier
  access:
    dataType: int
    nullable: NO
    description: >-
      [Required
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  aliases:
    dataType: varchar
    nullable: NO
    description: Aliases
completed_tasks:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  completedtime:
    dataType: int
    nullable: NO
    description: Completed Time UNIX Timestamp
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
  activityid:
    dataType: int
    nullable: NO
    description: '[Activity Identifier](task_activities.md)'
custom_faction_mappings:
  old_faction:
    dataType: int
    nullable: NO
    description: '[Old Faction Identifier](faction_list.md)'
  new_faction:
    dataType: int
    nullable: YES
    description: '[New Faction Identifier](faction_list.md)'
damageshieldtypes:
  spellid:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Damage Shield
      Type](https://eqemu.gitbook.io/server/categories/spells/damage-shield-types)
data_buckets:
  id:
    dataType: bigint
    nullable: NO
    description: Unique Data Bucket Identifier
  key:
    dataType: varchar
    nullable: YES
    description: Key
  value:
    dataType: text
    nullable: YES
    description: Value
  expires:
    dataType: int
    nullable: YES
    description: Expiration UNIX Timestamp
db_str:
  id:
    dataType: int
    nullable: NO
    description: Unique Database String Identifier
  type:
    dataType: int
    nullable: NO
    description: Type
  value:
    dataType: text
    nullable: NO
    description: Value
db_version:
  version:
    dataType: int
    nullable: YES
    description: Database Version
  bots_version:
    dataType: int
    nullable: YES
    description: Bots Version
discovered_items:
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  char_name:
    dataType: varchar
    nullable: NO
    description: '[Character Name](character_data.md)'
  discovered_date:
    dataType: int
    nullable: NO
    description: Discovered Date UNIX Timestamp
  account_status:
    dataType: int
    nullable: NO
    description: >-
      [Account
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
doors:
  id:
    dataType: int
    nullable: NO
    description: Unique Entry Identifier
  doorid:
    dataType: smallint
    nullable: NO
    description: Unique Door Identifier
  zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: smallint
    nullable: NO
    description: 'Zone Version: -1 For All'
  name:
    dataType: varchar
    nullable: NO
    description: >-
      This is the name of the door, such as 'IT11161' or 'POPCREATE501', for
      names of objects you can see.
  pos_y:
    dataType: float
    nullable: NO
    description: Door Y Coordinate
  pos_x:
    dataType: float
    nullable: NO
    description: Door X Coordinate
  pos_z:
    dataType: float
    nullable: NO
    description: Door Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Door Heading Coordinate
  opentype:
    dataType: smallint
    nullable: NO
    description: >-
      [Door Open
      Type](https://eqemu.gitbook.io/server/categories/zones/door-open-types)
  guild:
    dataType: smallint
    nullable: NO
    description: '[Guild Identifier](guilds.md)'
  lockpick:
    dataType: smallint
    nullable: NO
    description: 'Lockpicking Skill Required: -1 = Unpickable'
  keyitem:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  nokeyring:
    dataType: tinyint
    nullable: NO
    description: 'No Key Ring: 0 = False, 1 = True'
  triggerdoor:
    dataType: smallint
    nullable: NO
    description: 'Trigger Door: 0 For Current Door or use a Unique Door Identifier'
  triggertype:
    dataType: smallint
    nullable: NO
    description: 'Trigger Type: 1 = Open a Type 255 door, 255 = Will Not Open'
  disable_timer:
    dataType: tinyint
    nullable: NO
    description: Disable Timer
  doorisopen:
    dataType: smallint
    nullable: NO
    description: 'Door Is Open: 0 = False, 1 = True'
  door_param:
    dataType: int
    nullable: NO
    description: Door Parameter
  dest_zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  dest_instance:
    dataType: int
    nullable: NO
    description: '[Destination Instance](instance_list.md)'
  dest_x:
    dataType: float
    nullable: YES
    description: Destination X Coordinate
  dest_y:
    dataType: float
    nullable: YES
    description: Destination Y Coordinate
  dest_z:
    dataType: float
    nullable: YES
    description: Destination Z Coordinate
  dest_heading:
    dataType: float
    nullable: YES
    description: Destination Heading Coordinate
  invert_state:
    dataType: int
    nullable: YES
    description: >-
      This column will basically behave like such: if the door has a click type
      and it is to raise up like a door, it will be raised on spawn of the door.
      Meaning it is inverted. Another example: If a [Door Open
      Type](https://eqemu.gitbook.io/server/categories/zones/door-open-types) is
      set to a spinning object on click, you could set this to 1 to have the
      door be spinning on spawn.
  incline:
    dataType: int
    nullable: YES
    description: Incline
  size:
    dataType: smallint
    nullable: NO
    description: Size
  buffer:
    dataType: float
    nullable: YES
    description: Unused
  client_version_mask:
    dataType: int
    nullable: NO
    description: >-
      [Client Version
      Mask](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
  is_ldon_door:
    dataType: smallint
    nullable: NO
    description: 'Is LDoN Door: 0 = False, 1 = True'
eqtime:
  minute:
    dataType: tinyint
    nullable: NO
    description: Minute
  hour:
    dataType: tinyint
    nullable: NO
    description: Hour
  day:
    dataType: tinyint
    nullable: NO
    description: Day
  month:
    dataType: tinyint
    nullable: NO
    description: Month
  year:
    dataType: int
    nullable: NO
    description: Year
  realtime:
    dataType: int
    nullable: NO
    description: Real Time
eventlog:
  id:
    dataType: int
    nullable: NO
    description: Unique Event Identifier
  accountname:
    dataType: varchar
    nullable: NO
    description: '[Account Name](account.md)'
  accountid:
    dataType: int
    nullable: YES
    description: '[Account Identifier](account.md)'
  status:
    dataType: int
    nullable: NO
    description: '[Status](https://eqemu.gitbook.io/server/categories/player/status-levels)'
  charname:
    dataType: varchar
    nullable: NO
    description: '[Character Name](character_data.md)'
  target:
    dataType: varchar
    nullable: YES
    description: Target
  time:
    dataType: timestamp
    nullable: NO
    description: TIme Timestamp
  descriptiontype:
    dataType: varchar
    nullable: NO
    description: Description Type
  description:
    dataType: text
    nullable: NO
    description: Description
  event_nid:
    dataType: int
    nullable: NO
    description: Event Identifier
faction_base_data:
  client_faction_id:
    dataType: smallint
    nullable: NO
    description: '[Client Faction Identifier](faction_list.md)'
  min:
    dataType: smallint
    nullable: YES
    description: Minimum Faction
  max:
    dataType: smallint
    nullable: YES
    description: Maximum Faction
  unk_hero1:
    dataType: smallint
    nullable: YES
    description: Unknown
  unk_hero2:
    dataType: smallint
    nullable: YES
    description: Unknown
  unk_hero3:
    dataType: smallint
    nullable: YES
    description: Unknown
faction_list:
  id:
    dataType: int
    nullable: NO
    description: Unique Faction Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  base:
    dataType: smallint
    nullable: NO
    description: Base
faction_list_mod:
  id:
    dataType: int
    nullable: NO
    description: Unique Faction List Modifier Identifier
  faction_id:
    dataType: int
    nullable: NO
    description: '[Faction Identifier](faction_list.md)'
  mod:
    dataType: smallint
    nullable: NO
    description: Modifier
  mod_name:
    dataType: varchar
    nullable: NO
    description: >-
      Modifier Name: r# = [Race
      Identifier](https://eqemu.gitbook.io/server/categories/npc/race-list), c#
      = [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list),
      d# = [Deity
      Identifier](https://eqemu.gitbook.io/server/categories/player/deity-list)
faction_values:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  faction_id:
    dataType: int
    nullable: NO
    description: '[Faction Identifier](faction_list.md)'
  current_value:
    dataType: smallint
    nullable: NO
    description: Current Value
  temp:
    dataType: tinyint
    nullable: NO
    description: 'Temporary: 0 = False, 1 = True'
fear_hints:
  id:
    dataType: int
    nullable: NO
    description: Unique Fear Hint Identifier
  zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  forced:
    dataType: tinyint
    nullable: NO
    description: 'Forced: 0 = False, 1 = True'
  disjoint:
    dataType: tinyint
    nullable: NO
    description: 'Disjoint: 0 = False, 1 = True'
fishing:
  id:
    dataType: int
    nullable: NO
    description: Unique Fishing Identifier
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  Itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  skill_level:
    dataType: smallint
    nullable: NO
    description: Skill Level
  chance:
    dataType: smallint
    nullable: NO
    description: 'Chance: 0 = Never, 100 = Always'
  npc_id:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  npc_chance:
    dataType: int
    nullable: NO
    description: 'NPC Chance: 0 = Never, 100 = Always'
forage:
  id:
    dataType: int
    nullable: NO
    description: Unique Forage Identifier
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  Itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  level:
    dataType: smallint
    nullable: NO
    description: Level
  chance:
    dataType: smallint
    nullable: NO
    description: 'Chance: 0 = Never, 100 = Always'
friends:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  type:
    dataType: tinyint
    nullable: NO
    description: 'Type: 0 = Ignore, 1 = Friend'
  name:
    dataType: varchar
    nullable: NO
    description: '[Friend Name](character_data.md)'
global_loot:
  id:
    dataType: int
    nullable: NO
    description: Unique Global Loot Identifier
  description:
    dataType: varchar
    nullable: YES
    description: Description
  loottable_id:
    dataType: int
    nullable: NO
    description: '[Loottable Identifier](loottable.md)'
  enabled:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = False, 1 = True'
  min_level:
    dataType: int
    nullable: NO
    description: Minimum Level
  max_level:
    dataType: int
    nullable: NO
    description: Maximum Level
  rare:
    dataType: tinyint
    nullable: YES
    description: 'Rare: 0 = False, 1 = True'
  raid:
    dataType: tinyint
    nullable: YES
    description: 'Raid: 0 = False, 1 = True'
  race:
    dataType: mediumtext
    nullable: YES
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  class:
    dataType: mediumtext
    nullable: YES
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  bodytype:
    dataType: mediumtext
    nullable: YES
    description: '[Body Type](https://eqemu.gitbook.io/server/categories/npc/body-types)'
  zone:
    dataType: mediumtext
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  hot_zone:
    dataType: tinyint
    nullable: YES
    description: ''
gm_ips:
  name:
    dataType: varchar
    nullable: NO
    description: '[Character Name](character_data.md)'
  account_id:
    dataType: int
    nullable: NO
    description: '[Account Identifier](account.md)'
  ip_address:
    dataType: varchar
    nullable: NO
    description: '[IP Address](account_ip.md)'
goallists:
  listid:
    dataType: int
    nullable: NO
    description: Goal List Identifier
  entry:
    dataType: int
    nullable: NO
    description: Entry Identifier
graveyard:
  id:
    dataType: int
    nullable: NO
    description: Unique Graveyard Identifier
  zone_id:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
grid:
  id:
    dataType: int
    nullable: NO
    description: Unique Grid Identifier
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  type:
    dataType: int
    nullable: NO
    description: >-
      [Wander
      Type](https://eqemu.gitbook.io/server/categories/npc/spawns/wander-types)
  type2:
    dataType: int
    nullable: NO
    description: >-
      [Pause
      Type](https://eqemu.gitbook.io/server/categories/npc/spawns/pause-types)
grid_entries:
  gridid:
    dataType: int
    nullable: NO
    description: '[Grid Identifier](grid.md)'
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  number:
    dataType: int
    nullable: NO
    description: Waypoint Identifier
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  pause:
    dataType: int
    nullable: NO
    description: Pause in Seconds
  centerpoint:
    dataType: tinyint
    nullable: NO
    description: ''
ground_spawns:
  id:
    dataType: int
    nullable: NO
    description: Unique Ground Spawn Identifier
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: smallint
    nullable: NO
    description: 'Version: -1 For All'
  max_x:
    dataType: float
    nullable: NO
    description: Maximum X Coordinate
  max_y:
    dataType: float
    nullable: NO
    description: Maximum Y Coordinate
  max_z:
    dataType: float
    nullable: NO
    description: Maximum Z Coordinate
  min_x:
    dataType: float
    nullable: NO
    description: Minimum X Coordinate
  min_y:
    dataType: float
    nullable: NO
    description: Minimum Y Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  name:
    dataType: varchar
    nullable: NO
    description: Name
  item:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  max_allowed:
    dataType: int
    nullable: NO
    description: Max Allowed
  comment:
    dataType: varchar
    nullable: NO
    description: Comment
  respawn_timer:
    dataType: int
    nullable: NO
    description: Respawn Timer in Seconds
group_id:
  groupid:
    dataType: int
    nullable: NO
    description: Unique Group Identifier
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  name:
    dataType: varchar
    nullable: NO
    description: Name
  ismerc:
    dataType: tinyint
    nullable: NO
    description: 'Is Mercenary: 0 = False, 1 = True'
group_leaders:
  gid:
    dataType: int
    nullable: NO
    description: '[Group Identifier](group_id.md)'
  leadername:
    dataType: varchar
    nullable: NO
    description: Leader Name
  marknpc:
    dataType: varchar
    nullable: NO
    description: 'Mark NPC: 0 = False, 1 = True'
  leadershipaa:
    dataType: tinyblob
    nullable: YES
    description: Leadership AA
  maintank:
    dataType: varchar
    nullable: NO
    description: 'Main Tank: 0 = False, 1 = True'
  assist:
    dataType: varchar
    nullable: NO
    description: 'Assist: 0 = False, 1 = True'
  puller:
    dataType: varchar
    nullable: NO
    description: 'Puller: 0 = False, 1 = True'
  mentoree:
    dataType: varchar
    nullable: NO
    description: 'Mentoree: 0 = False, 1 = True'
  mentor_percent:
    dataType: int
    nullable: NO
    description: 'Main Tank: 0 = None, 100 = Max'
guilds:
  id:
    dataType: int
    nullable: NO
    description: Unique Guild Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  leader:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  minstatus:
    dataType: smallint
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  motd:
    dataType: text
    nullable: NO
    description: Message of the Day
  tribute:
    dataType: int
    nullable: NO
    description: Tribute
  motd_setter:
    dataType: varchar
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  channel:
    dataType: varchar
    nullable: NO
    description: Channel
  url:
    dataType: varchar
    nullable: NO
    description: Website URL
guild_bank:
  guildid:
    dataType: int
    nullable: NO
    description: '[Guild Identifier](guilds.md)'
  area:
    dataType: tinyint
    nullable: NO
    description: Area
  slot:
    dataType: int
    nullable: NO
    description: Slot Identifier
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  qty:
    dataType: int
    nullable: NO
    description: Quantity
  donator:
    dataType: varchar
    nullable: YES
    description: '[Character Identifier](character_data.md)'
  permissions:
    dataType: tinyint
    nullable: NO
    description: Permissions
  whofor:
    dataType: varchar
    nullable: YES
    description: Who For
guild_members:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  guild_id:
    dataType: mediumint
    nullable: NO
    description: '[Guild Identifier](guilds.md)'
  rank:
    dataType: tinyint
    nullable: NO
    description: '[Rank](https://eqemu.gitbook.io/server/categories/player/guild-ranks)'
  tribute_enable:
    dataType: tinyint
    nullable: NO
    description: 'Tribute Enable: 0 = False, 1 = True'
  total_tribute:
    dataType: int
    nullable: NO
    description: Total Tribute
  last_tribute:
    dataType: int
    nullable: NO
    description: Last Tribute
  banker:
    dataType: tinyint
    nullable: NO
    description: 'Banked: 0 = False, 1 = True'
  public_note:
    dataType: text
    nullable: NO
    description: Public Note
  alt:
    dataType: tinyint
    nullable: NO
    description: 'Alt: 0 = False, 1 = True'
guild_ranks:
  guild_id:
    dataType: mediumint
    nullable: NO
    description: '[Guild Identifier](guilds.md)'
  rank:
    dataType: tinyint
    nullable: NO
    description: Rank Identifier
  title:
    dataType: varchar
    nullable: NO
    description: Title
  can_hear:
    dataType: tinyint
    nullable: NO
    description: 'Can Hear: 0 = False, 1 = True'
  can_speak:
    dataType: tinyint
    nullable: NO
    description: 'Can Speak: 0 = False, 1 = True'
  can_invite:
    dataType: tinyint
    nullable: NO
    description: 'Can Invite: 0 = False, 1 = True'
  can_remove:
    dataType: tinyint
    nullable: NO
    description: 'Can Remove: 0 = False, 1 = True'
  can_promote:
    dataType: tinyint
    nullable: NO
    description: 'Can Promote: 0 = False, 1 = True'
  can_demote:
    dataType: tinyint
    nullable: NO
    description: 'Can Demote: 0 = False, 1 = True'
  can_motd:
    dataType: tinyint
    nullable: NO
    description: 'Can MOTD: 0 = False, 1 = True'
  can_warpeace:
    dataType: tinyint
    nullable: NO
    description: 'Can War Peace: 0 = False, 1 = True'
guild_relations:
  guild1:
    dataType: mediumint
    nullable: NO
    description: '[Unique Guild Identifier 1](guilds.md)'
  guild2:
    dataType: mediumint
    nullable: NO
    description: '[Unique Guild Identifier 2](guilds.md)'
  relation:
    dataType: tinyint
    nullable: NO
    description: ''
hackers:
  id:
    dataType: int
    nullable: NO
    description: Unique Hacker Identifier
  account:
    dataType: text
    nullable: NO
    description: '[Account Identifier](account.md)'
  name:
    dataType: text
    nullable: NO
    description: '[Character Name](character_data.md)'
  hacked:
    dataType: text
    nullable: NO
    description: Hacked
  zone:
    dataType: text
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  date:
    dataType: timestamp
    nullable: NO
    description: Date Timestamp
horses:
  filename:
    dataType: varchar
    nullable: NO
    description: '[NPC Type Name](npc_types.md)'
  race:
    dataType: smallint
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  texture:
    dataType: tinyint
    nullable: NO
    description: '[Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  mountspeed:
    dataType: float
    nullable: NO
    description: Mount Run Speed
  notes:
    dataType: varchar
    nullable: YES
    description: Notes
instance_list:
  id:
    dataType: int
    nullable: NO
    description: Unique Instance Identifier
  zone:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: tinyint
    nullable: NO
    description: Version
  is_global:
    dataType: tinyint
    nullable: NO
    description: 'Is Global: 0 = False, 1 = True'
  start_time:
    dataType: int
    nullable: NO
    description: Start Time UNIX Timestamp
  duration:
    dataType: int
    nullable: NO
    description: Duration in Seconds
  never_expires:
    dataType: tinyint
    nullable: NO
    description: 'Never Expires: 0 = False, 1 = True'
instance_list_player:
  id:
    dataType: int
    nullable: NO
    description: '[Instance Identifier](instance_list.md)'
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
inventory:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slotid:
    dataType: mediumint
    nullable: NO
    description: >-
      [Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  itemid:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: YES
    description: Charges
  color:
    dataType: int
    nullable: NO
    description: Color
  augslot1:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 1
  augslot2:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 2
  augslot3:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 3
  augslot4:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 4
  augslot5:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 5
  augslot6:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 6
  instnodrop:
    dataType: tinyint
    nullable: NO
    description: 'No Drop: 0 = True, 1 = False'
  custom_data:
    dataType: text
    nullable: YES
    description: Custom Data
  ornamenticon:
    dataType: int
    nullable: NO
    description: Ornamentation Icon
  ornamentidfile:
    dataType: int
    nullable: NO
    description: Ornamentation Texture
  ornament_hero_model:
    dataType: int
    nullable: NO
    description: Ornamentation Hero's Forge Model
inventory_snapshots:
  time_index:
    dataType: int
    nullable: NO
    description: Inventory Snapshot Time Identifier
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  slotid:
    dataType: mediumint
    nullable: NO
    description: >-
      [Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  itemid:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: YES
    description: Charges
  color:
    dataType: int
    nullable: NO
    description: Color
  augslot1:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 1
  augslot2:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 2
  augslot3:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 3
  augslot4:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 4
  augslot5:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 5
  augslot6:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 6
  instnodrop:
    dataType: tinyint
    nullable: NO
    description: 'No Drop: 0 = False, 1 = True'
  custom_data:
    dataType: text
    nullable: YES
    description: Custom Data
  ornamenticon:
    dataType: int
    nullable: NO
    description: Ornamentation Icon
  ornamentidfile:
    dataType: int
    nullable: NO
    description: Ornamentation Texture
  ornament_hero_model:
    dataType: int
    nullable: NO
    description: Ornamentation Hero's Forge Model
inventory_versions:
  version:
    dataType: int
    nullable: NO
    description: Inventory Version Identifier
  step:
    dataType: int
    nullable: NO
    description: Step
  bot_step:
    dataType: int
    nullable: NO
    description: Bot Step
ip_exemptions:
  exemption_id:
    dataType: int
    nullable: NO
    description: Exemption Identifier
  exemption_ip:
    dataType: varchar
    nullable: YES
    description: '[Exemption IP Address](account_ip.md)'
  exemption_amount:
    dataType: int
    nullable: YES
    description: Exemption Amount
items:
  id:
    dataType: int
    nullable: NO
    description: Unique Item Identifier
  minstatus:
    dataType: smallint
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  Name:
    dataType: varchar
    nullable: NO
    description: Name
  aagi:
    dataType: int
    nullable: NO
    description: 'Agility: -128 to 127'
  ac:
    dataType: int
    nullable: NO
    description: Armor Class
  accuracy:
    dataType: int
    nullable: NO
    description: Accuracy
  acha:
    dataType: int
    nullable: NO
    description: 'Charisma: -128 to 127'
  adex:
    dataType: int
    nullable: NO
    description: 'Dexterity: -128 to 127'
  aint:
    dataType: int
    nullable: NO
    description: 'Intelligence: -128 to 127'
  artifactflag:
    dataType: tinyint
    nullable: NO
    description: 'Artifact: 0 = False, 1 = True'
  asta:
    dataType: int
    nullable: NO
    description: 'Stamina: -128 to 127'
  astr:
    dataType: int
    nullable: NO
    description: 'Strenght: -128 to 127'
  attack:
    dataType: int
    nullable: NO
    description: Attack
  augrestrict:
    dataType: int
    nullable: NO
    description: >-
      [Augment
      Restriction](https://eqemu.gitbook.io/server/categories/items/augment-restrictions)
  augslot1type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 1
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot1visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 1 Visible: 0 = False, 1 = True'
  augslot2type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 2
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot2visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 2 Visible: 0 = False, 1 = True'
  augslot3type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 3
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot3visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 3 Visible: 0 = False, 1 = True'
  augslot4type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 4
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot4visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 4 Visible: 0 = False, 1 = True'
  augslot5type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 5
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot5visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 5 Visible: 0 = False, 1 = True'
  augslot6type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Augment Slot 6
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  augslot6visible:
    dataType: tinyint
    nullable: NO
    description: 'Augment Slot 6 Visible: 0 = False, 1 = True'
  augtype:
    dataType: int
    nullable: NO
    description: >-
      [Augment
      Type](https://eqemu.gitbook.io/server/categories/items/augment-types)
  avoidance:
    dataType: int
    nullable: NO
    description: Avoidance
  awis:
    dataType: int
    nullable: NO
    description: 'Wisdom: -128 to 127'
  bagsize:
    dataType: int
    nullable: NO
    description: '[Bag Size](https://eqemu.gitbook.io/server/categories/inventory/bag-sizes)'
  bagslots:
    dataType: int
    nullable: NO
    description: 'Bag Slots: 1 = Minimum, 10 = Maximum'
  bagtype:
    dataType: int
    nullable: NO
    description: '[Bag Type](https://eqemu.gitbook.io/server/categories/inventory/bag-types)'
  bagwr:
    dataType: int
    nullable: NO
    description: 'Bag Weight Reduction: 0 = 0%, 100 = 100%'
  banedmgamt:
    dataType: int
    nullable: NO
    description: Bane Damage Amount
  banedmgraceamt:
    dataType: int
    nullable: NO
    description: Bane Damage Race Amount
  banedmgbody:
    dataType: int
    nullable: NO
    description: >-
      [Bane Damage Body
      Type](https://eqemu.gitbook.io/server/categories/npc/body-types)
  banedmgrace:
    dataType: int
    nullable: NO
    description: >-
      [Bane Damage
      Race](https://eqemu.gitbook.io/server/categories/npc/race-list)
  bardtype:
    dataType: int
    nullable: NO
    description: '[Bard Type](https://eqemu.gitbook.io/server/categories/items/bard-types)'
  bardvalue:
    dataType: int
    nullable: NO
    description: Bard Value
  book:
    dataType: int
    nullable: NO
    description: '[Book](books.md)'
  casttime:
    dataType: int
    nullable: NO
    description: Cast Time in Seconds
  casttime_:
    dataType: int
    nullable: NO
    description: Cast Time in Seconds
  charmfile:
    dataType: varchar
    nullable: NO
    description: Charm File
  charmfileid:
    dataType: varchar
    nullable: NO
    description: Charm File Identifier
  classes:
    dataType: int
    nullable: NO
    description: '[Classes](https://eqemu.gitbook.io/server/categories/player/class-list)'
  color:
    dataType: int
    nullable: NO
    description: Color
  combateffects:
    dataType: varchar
    nullable: NO
    description: Combat Effects
  extradmgskill:
    dataType: int
    nullable: NO
    description: >-
      [Extra Damage
      Skill](https://eqemu.gitbook.io/server/categories/player/skills)
  extradmgamt:
    dataType: int
    nullable: NO
    description: Extra Damage Amount
  price:
    dataType: int
    nullable: NO
    description: Price in Copper
  cr:
    dataType: int
    nullable: NO
    description: 'Cold Resistance: -128 to 127'
  damage:
    dataType: int
    nullable: NO
    description: Damage
  damageshield:
    dataType: int
    nullable: NO
    description: Damage Shield
  deity:
    dataType: int
    nullable: NO
    description: '[Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  delay:
    dataType: int
    nullable: NO
    description: Delay
  augdistiller:
    dataType: int
    nullable: NO
    description: Augment Distiller Item Identifier
  dotshielding:
    dataType: int
    nullable: NO
    description: Damage Over Time Shielding
  dr:
    dataType: int
    nullable: NO
    description: 'Disease Resistance: -128 to 127'
  clicktype:
    dataType: int
    nullable: NO
    description: '[Click Type](https://eqemu.gitbook.io/server/categories/items/click-types)'
  clicklevel2:
    dataType: int
    nullable: NO
    description: Click Level 2
  elemdmgtype:
    dataType: int
    nullable: NO
    description: >-
      [Elemental Damage
      Type](https://eqemu.gitbook.io/server/categories/items/item-element-types)
  elemdmgamt:
    dataType: int
    nullable: NO
    description: Elemental Damage Amount
  endur:
    dataType: int
    nullable: NO
    description: Endurance
  factionamt1:
    dataType: int
    nullable: NO
    description: Faction Amount 1
  factionamt2:
    dataType: int
    nullable: NO
    description: Faction Amount 2
  factionamt3:
    dataType: int
    nullable: NO
    description: Faction Amount 3
  factionamt4:
    dataType: int
    nullable: NO
    description: Faction Amount 4
  factionmod1:
    dataType: int
    nullable: NO
    description: Faction Modifier 1
  factionmod2:
    dataType: int
    nullable: NO
    description: Faction Modifier 2
  factionmod3:
    dataType: int
    nullable: NO
    description: Faction Modifier 3
  factionmod4:
    dataType: int
    nullable: NO
    description: Faction Modifier 4
  filename:
    dataType: varchar
    nullable: NO
    description: File Name
  focuseffect:
    dataType: int
    nullable: NO
    description: '[Focus Effect Identifier](spells_new.md)'
  fr:
    dataType: int
    nullable: NO
    description: 'Fire Resistance: -128 to 127'
  fvnodrop:
    dataType: int
    nullable: NO
    description: 'Firiona Vie No Drop: 0 = False, 1 = True'
  haste:
    dataType: int
    nullable: NO
    description: 'Haste: 0 = 0%, 255 = 255%'
  clicklevel:
    dataType: int
    nullable: NO
    description: Click Level
  hp:
    dataType: int
    nullable: NO
    description: Health
  regen:
    dataType: int
    nullable: NO
    description: Health Regeneration
  icon:
    dataType: int
    nullable: NO
    description: Icon
  idfile:
    dataType: varchar
    nullable: NO
    description: Item Texture
  itemclass:
    dataType: int
    nullable: NO
    description: '[Item Class](https://eqemu.gitbook.io/server/categories/items/item-class)'
  itemtype:
    dataType: int
    nullable: NO
    description: '[Item Type](https://eqemu.gitbook.io/server/categories/items/item-types)'
  ldonprice:
    dataType: int
    nullable: NO
    description: LDoN Price
  ldontheme:
    dataType: int
    nullable: NO
    description: '[LDoN Theme](https://eqemu.gitbook.io/server/categories/zones/ldon-themes)'
  ldonsold:
    dataType: int
    nullable: NO
    description: 'LDoN Sold: 0 = False, 1 = True'
  light:
    dataType: int
    nullable: NO
    description: Light
  lore:
    dataType: varchar
    nullable: NO
    description: Lore Description
  loregroup:
    dataType: int
    nullable: NO
    description: >-
      [Lore
      Group](https://eqemu.gitbook.io/server/categories/items/item-lore-groups)
  magic:
    dataType: int
    nullable: NO
    description: 'Magic: 0 = False, 1 = True'
  mana:
    dataType: int
    nullable: NO
    description: Mana
  manaregen:
    dataType: int
    nullable: NO
    description: Mana Regeneration
  enduranceregen:
    dataType: int
    nullable: NO
    description: Endurance Regeneration
  material:
    dataType: int
    nullable: NO
    description: '[Material](https://eqemu.gitbook.io/server/categories/npc/textures)'
  herosforgemodel:
    dataType: int
    nullable: NO
    description: Hero's Forge Model
  maxcharges:
    dataType: int
    nullable: NO
    description: Maximum Charges
  mr:
    dataType: int
    nullable: NO
    description: 'Magic Resistance: -128 to 127'
  nodrop:
    dataType: int
    nullable: NO
    description: 'No Drop: 0 = True, 1 = False'
  norent:
    dataType: int
    nullable: NO
    description: 'No Rent: 0 = True, 1 = False'
  pendingloreflag:
    dataType: tinyint
    nullable: NO
    description: 'Pending Lore Flag: 0 = False, 1 = True'
  pr:
    dataType: int
    nullable: NO
    description: 'Poison Resistance: -128 to 127'
  procrate:
    dataType: int
    nullable: NO
    description: 'Proc Rate: 0 = 100%, 50 = 150%, 100 = 200%'
  races:
    dataType: int
    nullable: NO
    description: '[Races](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  range:
    dataType: int
    nullable: NO
    description: 'Range: 0 to 255'
  reclevel:
    dataType: int
    nullable: NO
    description: Recommended Level
  recskill:
    dataType: int
    nullable: NO
    description: Recommended Skill Level
  reqlevel:
    dataType: int
    nullable: NO
    description: Required Level
  sellrate:
    dataType: float
    nullable: NO
    description: Sell Rate
  shielding:
    dataType: int
    nullable: NO
    description: 'Shielding: 5 = 5%, 20 = 20%, 50 = 50%'
  size:
    dataType: int
    nullable: NO
    description: Size
  skillmodtype:
    dataType: int
    nullable: NO
    description: >-
      [Skill Modifier
      Type](https://eqemu.gitbook.io/server/categories/player/skills)
  skillmodvalue:
    dataType: int
    nullable: NO
    description: Skill Modifier Value
  slots:
    dataType: int
    nullable: NO
    description: '[Slots](https://eqemu.gitbook.io/server/categories/inventory/item-slots)'
  clickeffect:
    dataType: int
    nullable: NO
    description: '[Click Effect Identifier](spells_new.md)'
  spellshield:
    dataType: int
    nullable: NO
    description: Spell Shielding
  strikethrough:
    dataType: int
    nullable: NO
    description: Strikethrough
  stunresist:
    dataType: int
    nullable: NO
    description: Stun Resist
  summonedflag:
    dataType: tinyint
    nullable: NO
    description: Unknown
  tradeskills:
    dataType: int
    nullable: NO
    description: 'Tradeskill Item: 0 = False, 1= True'
  favor:
    dataType: int
    nullable: NO
    description: Favor
  weight:
    dataType: int
    nullable: NO
    description: 'Weight: 10 = 1.0, 25 = 2.5, 100 = 10.0'
  UNK012:
    dataType: int
    nullable: NO
    description: Unknown
  UNK013:
    dataType: int
    nullable: NO
    description: Unknown
  benefitflag:
    dataType: int
    nullable: NO
    description: Unknown
  UNK054:
    dataType: int
    nullable: NO
    description: Unknown
  UNK059:
    dataType: int
    nullable: NO
    description: Unknown
  booktype:
    dataType: int
    nullable: NO
    description: >-
      [Book
      Language](https://eqemu.gitbook.io/server/categories/player/languages)
  recastdelay:
    dataType: int
    nullable: NO
    description: Recast Delay in Seconds
  recasttype:
    dataType: int
    nullable: NO
    description: 'Recast Type: -1 = None, >0 = Recast Type used across all items'
  guildfavor:
    dataType: int
    nullable: NO
    description: Guild Favor
  UNK123:
    dataType: int
    nullable: NO
    description: Unknown
  UNK124:
    dataType: int
    nullable: NO
    description: Unknown
  attuneable:
    dataType: int
    nullable: NO
    description: 'Attuneable: 0 = False, 1 = True'
  nopet:
    dataType: int
    nullable: NO
    description: 'No Pet: 0 = False, 1 = True'
  updated:
    dataType: datetime
    nullable: NO
    description: Updated Datetime
  comment:
    dataType: varchar
    nullable: NO
    description: Comment
  UNK127:
    dataType: int
    nullable: NO
    description: Unknown
  pointtype:
    dataType: int
    nullable: NO
    description: Unknown
  potionbelt:
    dataType: int
    nullable: NO
    description: 'Potion Belt: 0 = False, 1 = True'
  potionbeltslots:
    dataType: int
    nullable: NO
    description: Potion Belt Slots
  stacksize:
    dataType: int
    nullable: NO
    description: Stack Size
  notransfer:
    dataType: int
    nullable: NO
    description: 'No Transfer: 0 = False, 1 = True'
  stackable:
    dataType: int
    nullable: NO
    description: 'Stackable: 0 = False, 1 = True'
  UNK134:
    dataType: varchar
    nullable: NO
    description: Unknown
  UNK137:
    dataType: int
    nullable: NO
    description: Unknown
  proceffect:
    dataType: int
    nullable: NO
    description: '[Proc Effect Identifier](spells_new.md)'
  proctype:
    dataType: int
    nullable: NO
    description: 'Proc Type: 0'
  proclevel2:
    dataType: int
    nullable: NO
    description: Proc Level 2
  proclevel:
    dataType: int
    nullable: NO
    description: Proc Level
  UNK142:
    dataType: int
    nullable: NO
    description: Unknown
  worneffect:
    dataType: int
    nullable: NO
    description: '[Worn Effect Identifier](spells_new.md)'
  worntype:
    dataType: int
    nullable: NO
    description: 'Worn Type: 2 = Worn'
  wornlevel2:
    dataType: int
    nullable: NO
    description: Worn Level 2
  wornlevel:
    dataType: int
    nullable: NO
    description: Worn Level
  UNK147:
    dataType: int
    nullable: NO
    description: Unknown
  focustype:
    dataType: int
    nullable: NO
    description: 'Focus Type: 6 = Focus'
  focuslevel2:
    dataType: int
    nullable: NO
    description: Focus Level 2
  focuslevel:
    dataType: int
    nullable: NO
    description: Focus Level
  UNK152:
    dataType: int
    nullable: NO
    description: Unknown
  scrolleffect:
    dataType: int
    nullable: NO
    description: '[Scroll Effect Identifier](spells_new.md)'
  scrolltype:
    dataType: int
    nullable: NO
    description: 'Scroll Type: 7 = Scroll'
  scrolllevel2:
    dataType: int
    nullable: NO
    description: Scroll Level 2
  scrolllevel:
    dataType: int
    nullable: NO
    description: Scroll Level
  UNK157:
    dataType: int
    nullable: NO
    description: Unknown
  serialized:
    dataType: datetime
    nullable: YES
    description: Serialized Datetime
  verified:
    dataType: datetime
    nullable: YES
    description: Verified Datetime
  serialization:
    dataType: text
    nullable: YES
    description: Serialization
  source:
    dataType: varchar
    nullable: NO
    description: Source
  UNK033:
    dataType: int
    nullable: NO
    description: Unknown
  lorefile:
    dataType: varchar
    nullable: NO
    description: Lore File
  UNK014:
    dataType: int
    nullable: NO
    description: Unknown
  svcorruption:
    dataType: int
    nullable: NO
    description: 'Corruption Resistance: -128 to 127'
  skillmodmax:
    dataType: int
    nullable: NO
    description: Skill Modifier Max
  UNK060:
    dataType: int
    nullable: NO
    description: Unknown
  augslot1unk2:
    dataType: int
    nullable: NO
    description: Unknown
  augslot2unk2:
    dataType: int
    nullable: NO
    description: Unknown
  augslot3unk2:
    dataType: int
    nullable: NO
    description: Unknown
  augslot4unk2:
    dataType: int
    nullable: NO
    description: Unknown
  augslot5unk2:
    dataType: int
    nullable: NO
    description: Unknown
  augslot6unk2:
    dataType: int
    nullable: NO
    description: Unknown
  UNK120:
    dataType: int
    nullable: NO
    description: Unknown
  UNK121:
    dataType: int
    nullable: NO
    description: Unknown
  questitemflag:
    dataType: int
    nullable: NO
    description: 'Quest Item: 0 = False, 1 = True'
  UNK132:
    dataType: text
    nullable: YES
    description: Unknown
  clickunk5:
    dataType: int
    nullable: NO
    description: Unknown
  clickunk6:
    dataType: varchar
    nullable: NO
    description: Unknown
  clickunk7:
    dataType: int
    nullable: NO
    description: Unknown
  procunk1:
    dataType: int
    nullable: NO
    description: Unknown
  procunk2:
    dataType: int
    nullable: NO
    description: Unknown
  procunk3:
    dataType: int
    nullable: NO
    description: Unknown
  procunk4:
    dataType: int
    nullable: NO
    description: Unknown
  procunk6:
    dataType: varchar
    nullable: NO
    description: Unknown
  procunk7:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk1:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk2:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk3:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk4:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk5:
    dataType: int
    nullable: NO
    description: Unknown
  wornunk6:
    dataType: varchar
    nullable: NO
    description: Unknown
  wornunk7:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk1:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk2:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk3:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk4:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk5:
    dataType: int
    nullable: NO
    description: Unknown
  focusunk6:
    dataType: varchar
    nullable: NO
    description: Unknown
  focusunk7:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk1:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk2:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk3:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk4:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk5:
    dataType: int
    nullable: NO
    description: Unknown
  scrollunk6:
    dataType: varchar
    nullable: NO
    description: Unknown
  scrollunk7:
    dataType: int
    nullable: NO
    description: Unknown
  UNK193:
    dataType: int
    nullable: NO
    description: Unknown
  purity:
    dataType: int
    nullable: NO
    description: Purity
  evoitem:
    dataType: int
    nullable: NO
    description: 'Evolving Item: 0 = False, 1 = True'
  evoid:
    dataType: int
    nullable: NO
    description: '[Evolving Identifier](items.md)'
  evolvinglevel:
    dataType: int
    nullable: NO
    description: Evolving Level
  evomax:
    dataType: int
    nullable: NO
    description: Evolving Max
  clickname:
    dataType: varchar
    nullable: NO
    description: Click Name
  procname:
    dataType: varchar
    nullable: NO
    description: Proc Name
  wornname:
    dataType: varchar
    nullable: NO
    description: Worn Name
  focusname:
    dataType: varchar
    nullable: NO
    description: Focus Name
  scrollname:
    dataType: varchar
    nullable: NO
    description: Scroll Name
  dsmitigation:
    dataType: smallint
    nullable: NO
    description: Damage Shield Mitigation
  heroic_str:
    dataType: smallint
    nullable: NO
    description: Heroic Strength
  heroic_int:
    dataType: smallint
    nullable: NO
    description: Heroic Intelligence
  heroic_wis:
    dataType: smallint
    nullable: NO
    description: Heroic Wisdom
  heroic_agi:
    dataType: smallint
    nullable: NO
    description: Heroic Agility
  heroic_dex:
    dataType: smallint
    nullable: NO
    description: Heroic Dexterity
  heroic_sta:
    dataType: smallint
    nullable: NO
    description: Heroic Stamina
  heroic_cha:
    dataType: smallint
    nullable: NO
    description: Heroic Charisma
  heroic_pr:
    dataType: smallint
    nullable: NO
    description: Heroic Poison Resistance
  heroic_dr:
    dataType: smallint
    nullable: NO
    description: Heroic Disease Resistance
  heroic_fr:
    dataType: smallint
    nullable: NO
    description: Heroic Fire Resistance
  heroic_cr:
    dataType: smallint
    nullable: NO
    description: Heroic Cold Resistance
  heroic_mr:
    dataType: smallint
    nullable: NO
    description: Heroic Magic Resistance
  heroic_svcorrup:
    dataType: smallint
    nullable: NO
    description: Heroic Corruption Resistance
  healamt:
    dataType: smallint
    nullable: NO
    description: 'Heal Amount: 0 to 32767'
  spelldmg:
    dataType: smallint
    nullable: NO
    description: 'Spell Damage: 0 to 32767'
  clairvoyance:
    dataType: smallint
    nullable: NO
    description: Clairvoyance
  backstabdmg:
    dataType: smallint
    nullable: NO
    description: Backstab Damage
  created:
    dataType: varchar
    nullable: NO
    description: Created
  elitematerial:
    dataType: smallint
    nullable: NO
    description: Elite Material
  ldonsellbackrate:
    dataType: smallint
    nullable: NO
    description: LDoN Sellback Rate
  scriptfileid:
    dataType: smallint
    nullable: NO
    description: Script File Name
  expendablearrow:
    dataType: smallint
    nullable: NO
    description: 'Expendable Arrow: 0 = False, 1 = True'
  powersourcecapacity:
    dataType: smallint
    nullable: NO
    description: Powersource Capacity
  bardeffect:
    dataType: smallint
    nullable: NO
    description: '[Bard Effect Identifier](spells_new.md)'
  bardeffecttype:
    dataType: smallint
    nullable: NO
    description: >-
      [Bard Effect
      Type](https://eqemu.gitbook.io/server/categories/items/bard-types)
  bardlevel2:
    dataType: smallint
    nullable: NO
    description: Bard Level 2
  bardlevel:
    dataType: smallint
    nullable: NO
    description: Bard Level
  bardunk1:
    dataType: smallint
    nullable: NO
    description: Unknown
  bardunk2:
    dataType: smallint
    nullable: NO
    description: Unknown
  bardunk3:
    dataType: smallint
    nullable: NO
    description: Unknown
  bardunk4:
    dataType: smallint
    nullable: NO
    description: Unknown
  bardunk5:
    dataType: smallint
    nullable: NO
    description: Unknown
  bardname:
    dataType: varchar
    nullable: NO
    description: Bard Name
  bardunk7:
    dataType: smallint
    nullable: NO
    description: Unknown
  UNK214:
    dataType: smallint
    nullable: NO
    description: Unknown
  UNK219:
    dataType: int
    nullable: NO
    description: Unknown
  UNK220:
    dataType: int
    nullable: NO
    description: Unknown
  UNK221:
    dataType: int
    nullable: NO
    description: Unknown
  heirloom:
    dataType: int
    nullable: NO
    description: 'Heirloom: 0 = False, 1 = True'
  UNK223:
    dataType: int
    nullable: NO
    description: Unknown
  UNK224:
    dataType: int
    nullable: NO
    description: Unknown
  UNK225:
    dataType: int
    nullable: NO
    description: Unknown
  UNK226:
    dataType: int
    nullable: NO
    description: Unknown
  UNK227:
    dataType: int
    nullable: NO
    description: Unknown
  UNK228:
    dataType: int
    nullable: NO
    description: Unknown
  UNK229:
    dataType: int
    nullable: NO
    description: Unknown
  UNK230:
    dataType: int
    nullable: NO
    description: Unknown
  UNK231:
    dataType: int
    nullable: NO
    description: Unknown
  UNK232:
    dataType: int
    nullable: NO
    description: Unknown
  UNK233:
    dataType: int
    nullable: NO
    description: Unknown
  UNK234:
    dataType: int
    nullable: NO
    description: Unknown
  placeable:
    dataType: int
    nullable: NO
    description: 'Placeable: 0 = False, 1 = True'
  UNK236:
    dataType: int
    nullable: NO
    description: Unknown
  UNK237:
    dataType: int
    nullable: NO
    description: Unknown
  UNK238:
    dataType: int
    nullable: NO
    description: Unknown
  UNK239:
    dataType: int
    nullable: NO
    description: Unknown
  UNK240:
    dataType: int
    nullable: NO
    description: Unknown
  UNK241:
    dataType: int
    nullable: NO
    description: Unknown
  epicitem:
    dataType: int
    nullable: NO
    description: 'Epic Item: 0 = False, 1 = True'
  subtype:
    dataType: int
    nullable: NO
    description: ''
item_tick:
  it_itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  it_chance:
    dataType: int
    nullable: NO
    description: 'Chance: 0 = Never, 100 = Always'
  it_level:
    dataType: int
    nullable: NO
    description: Level
  it_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  it_qglobal:
    dataType: varchar
    nullable: NO
    description: '[Quest Global Identifier](quest_globals.md) (Deprecated)'
  it_bagslot:
    dataType: tinyint
    nullable: NO
    description: >-
      [Bag
      Slot](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
keyring:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
launcher:
  name:
    dataType: varchar
    nullable: NO
    description: Name
  dynamics:
    dataType: tinyint
    nullable: NO
    description: Dynamics
launcher_zones:
  launcher:
    dataType: varchar
    nullable: NO
    description: Launcher
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  port:
    dataType: mediumint
    nullable: NO
    description: Port
ldon_trap_entries:
  id:
    dataType: int
    nullable: NO
    description: Unique LDoN Trap Entry Identifier
  trap_id:
    dataType: int
    nullable: NO
    description: '[Trap Identifier](ldon_trap_templates.md)'
ldon_trap_templates:
  id:
    dataType: int
    nullable: NO
    description: Unique LDoN Trap Template Identifier
  type:
    dataType: tinyint
    nullable: NO
    description: '[Trap Type](https://eqemu.gitbook.io/server/categories/zones/trap-types)'
  spell_id:
    dataType: smallint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  skill:
    dataType: smallint
    nullable: NO
    description: '[Skill](https://eqemu.gitbook.io/server/categories/player/skills)'
  locked:
    dataType: tinyint
    nullable: NO
    description: 'Locked: 0 = False, 1 = True'
level_exp_mods:
  level:
    dataType: int
    nullable: NO
    description: Level
  exp_mod:
    dataType: float
    nullable: YES
    description: 'Experience Modifier: 0.5 = 50%, 1 = 100%, 1.5 = 150%'
  aa_exp_mod:
    dataType: float
    nullable: YES
    description: 'AA Experience Modifier: 0.5 = 50%, 1 = 100%, 1.5 = 150%'
lfguild:
  type:
    dataType: tinyint
    nullable: NO
    description: Type
  name:
    dataType: varchar
    nullable: NO
    description: Name
  comment:
    dataType: varchar
    nullable: NO
    description: Comment
  fromlevel:
    dataType: tinyint
    nullable: NO
    description: From Level
  tolevel:
    dataType: tinyint
    nullable: NO
    description: To Level
  classes:
    dataType: int
    nullable: NO
    description: '[Classes](https://eqemu.gitbook.io/server/categories/player/class-list)'
  aacount:
    dataType: int
    nullable: NO
    description: AA Count
  timezone:
    dataType: int
    nullable: NO
    description: Time Zone
  timeposted:
    dataType: int
    nullable: NO
    description: Time Posted UNIX Timestamp
logsys_categories:
  log_category_id:
    dataType: int
    nullable: NO
    description: Unique Log Category Identifier
  log_category_description:
    dataType: varchar
    nullable: YES
    description: Log Category Description
  log_to_console:
    dataType: smallint
    nullable: YES
    description: 'Log to Console: 0 = False, 1 = True'
  log_to_file:
    dataType: smallint
    nullable: YES
    description: 'Log to File: 0 = False, 1 = True'
  log_to_gmsay:
    dataType: smallint
    nullable: YES
    description: 'Log to GMSay: 0 = False, 1 = True'
lootdrop:
  id:
    dataType: int
    nullable: NO
    description: Unique Lootdrop Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
lootdrop_entries:
  lootdrop_id:
    dataType: int
    nullable: NO
    description: '[Lootdrop Identifier](lootdrop.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  item_charges:
    dataType: smallint
    nullable: NO
    description: Item Charges
  equip_item:
    dataType: tinyint
    nullable: NO
    description: 'Equip Item: 0 = False, 1 = True'
  chance:
    dataType: float
    nullable: NO
    description: 'Chance: 0 = Never, 100 = Always'
  disabled_chance:
    dataType: float
    nullable: NO
    description: 'Disabled Chance: 0 = Never, 100 = Always'
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  multiplier:
    dataType: tinyint
    nullable: NO
    description: Multiplier
loottable:
  id:
    dataType: int
    nullable: NO
    description: Unique Loottable Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  mincash:
    dataType: int
    nullable: NO
    description: Minimum Cash in Copper
  maxcash:
    dataType: int
    nullable: NO
    description: Maximum Cash in Copper
  avgcoin:
    dataType: int
    nullable: NO
    description: Average Coin in Copper
  done:
    dataType: tinyint
    nullable: NO
    description: 'Done: 0 = False, 1 = True'
loottable_entries:
  loottable_id:
    dataType: int
    nullable: NO
    description: '[Loottable Identifier](loottable.md)'
  lootdrop_id:
    dataType: int
    nullable: NO
    description: '[Lootdrop Identifier](lootdrop.md)'
  multiplier:
    dataType: tinyint
    nullable: NO
    description: Multiplier
  droplimit:
    dataType: tinyint
    nullable: NO
    description: Maximum Drops
  mindrop:
    dataType: tinyint
    nullable: NO
    description: Minimum Drops
  probability:
    dataType: float
    nullable: NO
    description: 'Probability: 0 = Never, 100 = Always'
mail:
  msgid:
    dataType: int
    nullable: NO
    description: Unique Message Identifier
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  timestamp:
    dataType: int
    nullable: NO
    description: UNIX Timestamp
  from:
    dataType: varchar
    nullable: NO
    description: '[From Character Name](character_data.md)'
  subject:
    dataType: varchar
    nullable: NO
    description: Subject
  body:
    dataType: text
    nullable: NO
    description: Body
  to:
    dataType: text
    nullable: NO
    description: '[To Character Name](character_data.md)'
  status:
    dataType: tinyint
    nullable: NO
    description: '[Status](https://eqemu.gitbook.io/server/categories/player/status-levels)'
merchantlist:
  merchantid:
    dataType: int
    nullable: NO
    description: Merchant Identifier
  slot:
    dataType: int
    nullable: NO
    description: Slot
  item:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  faction_required:
    dataType: smallint
    nullable: NO
    description: Faction Required
  level_required:
    dataType: tinyint
    nullable: NO
    description: Level Required
  alt_currency_cost:
    dataType: smallint
    nullable: NO
    description: '[Alternate Currency Cost](alternate_currency.md)'
  classes_required:
    dataType: int
    nullable: NO
    description: >-
      [Classes
      Required](https://eqemu.gitbook.io/server/categories/player/class-list)
  probability:
    dataType: int
    nullable: NO
    description: 'Probability: 0 = Never, 100 = Always'
merchantlist_temp:
  npcid:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  charges:
    dataType: int
    nullable: NO
    description: Charges
mercs:
  MercID:
    dataType: int
    nullable: NO
    description: Unique Mercenary Identifier
  OwnerCharacterID:
    dataType: int
    nullable: NO
    description: '[Owner Character Identifier](character_data.md)'
  Slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  Name:
    dataType: varchar
    nullable: NO
    description: Name
  TemplateID:
    dataType: int
    nullable: NO
    description: '[Template Identifier](merc_templates.md)'
  SuspendedTime:
    dataType: int
    nullable: NO
    description: Suspended Time UNIX Timestamp
  IsSuspended:
    dataType: tinyint
    nullable: NO
    description: 'Is Suspended: 0 = False, 1 = True'
  TimerRemaining:
    dataType: int
    nullable: NO
    description: Timer Remaining in Seconds
  Gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  MercSize:
    dataType: float
    nullable: NO
    description: Mercenary Size
  StanceID:
    dataType: tinyint
    nullable: NO
    description: >-
      [Stance Type
      Identifier](https://eqemu.gitbook.io/server/categories/bots/stance-types)
  HP:
    dataType: int
    nullable: NO
    description: Health
  Mana:
    dataType: int
    nullable: NO
    description: Mana
  Endurance:
    dataType: int
    nullable: NO
    description: Endurance
  Face:
    dataType: int
    nullable: NO
    description: Face
  LuclinHairStyle:
    dataType: int
    nullable: NO
    description: Hair Style
  LuclinHairColor:
    dataType: int
    nullable: NO
    description: Hair Color
  LuclinEyeColor:
    dataType: int
    nullable: NO
    description: Eye Color 1
  LuclinEyeColor2:
    dataType: int
    nullable: NO
    description: Eye Color 2
  LuclinBeardColor:
    dataType: int
    nullable: NO
    description: Beard Color
  LuclinBeard:
    dataType: int
    nullable: NO
    description: Beard
  DrakkinHeritage:
    dataType: int
    nullable: NO
    description: Drakkin Heritage
  DrakkinTattoo:
    dataType: int
    nullable: NO
    description: Drakkin Tattoo
  DrakkinDetails:
    dataType: int
    nullable: NO
    description: Drakkin Details
merc_armorinfo:
  id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Armor Info Identifier
  merc_npc_type_id:
    dataType: int
    nullable: NO
    description: '[Mercenary NPC Type Identifier](merc_npc_types.md)'
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  texture:
    dataType: tinyint
    nullable: NO
    description: '[Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  helmtexture:
    dataType: tinyint
    nullable: NO
    description: '[Helmet Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  armortint_id:
    dataType: int
    nullable: NO
    description: '[Armor Tint Identifier](npc_types_tint.md)'
  armortint_red:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Red: 0 = None, 255 = Max'
  armortint_green:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Green: 0 = None, 255 = Max'
  armortint_blue:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Blue: 0 = None, 255 = Max'
merc_buffs:
  MercBuffId:
    dataType: int
    nullable: NO
    description: Unique Mercenary Buff Identifier
  MercId:
    dataType: int
    nullable: NO
    description: '[Mercenary Identifier](mercs.md)'
  SpellId:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  CasterLevel:
    dataType: int
    nullable: NO
    description: Caster Level
  DurationFormula:
    dataType: int
    nullable: NO
    description: >-
      [Duration
      Formula](https://eqemu.gitbook.io/server/categories/spells/buff-duration-formulas)
  TicsRemaining:
    dataType: int
    nullable: NO
    description: Tics Remaining
  PoisonCounters:
    dataType: int
    nullable: NO
    description: Poison Counters
  DiseaseCounters:
    dataType: int
    nullable: NO
    description: Disease Counters
  CurseCounters:
    dataType: int
    nullable: NO
    description: Curse Counters
  CorruptionCounters:
    dataType: int
    nullable: NO
    description: Corruption Counters
  HitCount:
    dataType: int
    nullable: NO
    description: Hit Count
  MeleeRune:
    dataType: int
    nullable: NO
    description: Melee Rune
  MagicRune:
    dataType: int
    nullable: NO
    description: Magic Rune
  dot_rune:
    dataType: int
    nullable: NO
    description: Damage Over Time Rune
  caston_x:
    dataType: int
    nullable: NO
    description: Cast On X Coordinate
  Persistent:
    dataType: tinyint
    nullable: NO
    description: 'Persistent: 0 = False, 1 = True'
  caston_y:
    dataType: int
    nullable: NO
    description: Cast On Y Coordinate
  caston_z:
    dataType: int
    nullable: NO
    description: Cast On Z Coordinate
  ExtraDIChance:
    dataType: int
    nullable: NO
    description: Extra DI Chance
merc_inventory:
  merc_inventory_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Inventory Identifier
  merc_subtype_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Subtype Identifier](merc_subtypes.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  min_level:
    dataType: int
    nullable: NO
    description: Minimum Level
  max_level:
    dataType: int
    nullable: NO
    description: Maximum Level
merc_merchant_entries:
  merc_merchant_entry_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Merchant Entry Identifier
  merc_merchant_template_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Merchant Template Identifier](merc_merchant_templates.md)'
  merchant_id:
    dataType: int
    nullable: NO
    description: '[Merchant Identifier](merchantlist.md)'
merc_merchant_templates:
  merc_merchant_template_id:
    dataType: int
    nullable: NO
    description: '[Unique Mercenary Merchant Template Identifier'
  name:
    dataType: varchar
    nullable: NO
    description: Name
  qglobal:
    dataType: varchar
    nullable: YES
    description: '[Quest Global](quest_globals.md) (Deprecated)'
merc_merchant_template_entries:
  merc_merchant_template_entry_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Merchant Template Entry Identifier
  merc_merchant_template_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Merchant Template Identifier](merc_merchant_templates.md)'
  merc_template_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Template Identifier](merc_templates.md)'
merc_name_types:
  name_type_id:
    dataType: int
    nullable: NO
    description: Mercenary Name Type Identifier
  class_id:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  prefix:
    dataType: varchar
    nullable: NO
    description: Prefix
  suffix:
    dataType: varchar
    nullable: NO
    description: Suffix
merc_npc_types:
  merc_npc_type_id:
    dataType: int
    nullable: NO
    description: Mercenary NPC Type Identifier
  proficiency_id:
    dataType: tinyint
    nullable: NO
    description: Proficiency Identifier
  tier_id:
    dataType: tinyint
    nullable: NO
    description: Tier Identifier
  class_id:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  name:
    dataType: varchar
    nullable: YES
    description: Name
merc_spell_lists:
  merc_spell_list_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Spell List Identifier
  class_id:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  proficiency_id:
    dataType: tinyint
    nullable: NO
    description: Proficiency Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
merc_spell_list_entries:
  merc_spell_list_entry_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Spell List Entry Identifier
  merc_spell_list_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Spell List Identifier](merc_spell_lists.md)'
  spell_id:
    dataType: int
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  spell_type:
    dataType: int
    nullable: NO
    description: >-
      [Spell
      Type](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  stance_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Stance Type
      Identifier](https://eqemu.gitbook.io/server/categories/bots/stance-types)
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  slot:
    dataType: tinyint
    nullable: NO
    description: Slot
  procChance:
    dataType: tinyint
    nullable: NO
    description: 'Proc Chance: 0 = Never, 100 = Always'
merc_stance_entries:
  merc_stance_entry_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Stance Entry Identifier
  class_id:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  proficiency_id:
    dataType: tinyint
    nullable: NO
    description: Proficiency Identifier
  stance_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Stance Type
      Identifier](https://eqemu.gitbook.io/server/categories/bots/stance-types)
  isdefault:
    dataType: tinyint
    nullable: NO
    description: 'Is Default: 0 = False, 1 = True'
merc_stats:
  merc_npc_type_id:
    dataType: int
    nullable: NO
    description: '[Mercenary NPC Type Identifier](merc_npc_types.md)'
  clientlevel:
    dataType: tinyint
    nullable: NO
    description: Client Level
  level:
    dataType: tinyint
    nullable: NO
    description: Level
  hp:
    dataType: int
    nullable: NO
    description: Health
  mana:
    dataType: int
    nullable: NO
    description: Mana
  AC:
    dataType: smallint
    nullable: NO
    description: Armor Class
  ATK:
    dataType: mediumint
    nullable: NO
    description: Attack
  STR:
    dataType: mediumint
    nullable: NO
    description: Strength
  STA:
    dataType: mediumint
    nullable: NO
    description: Stamina
  DEX:
    dataType: mediumint
    nullable: NO
    description: Dexterity
  AGI:
    dataType: mediumint
    nullable: NO
    description: Agility
  _INT:
    dataType: mediumint
    nullable: NO
    description: Intelligence
  WIS:
    dataType: mediumint
    nullable: NO
    description: Wisdom
  CHA:
    dataType: mediumint
    nullable: NO
    description: Charisma
  MR:
    dataType: smallint
    nullable: NO
    description: Magic Resistance
  CR:
    dataType: smallint
    nullable: NO
    description: Cold Resistance
  DR:
    dataType: smallint
    nullable: NO
    description: Disease Resistance
  FR:
    dataType: smallint
    nullable: NO
    description: Fire Resistance
  PR:
    dataType: smallint
    nullable: NO
    description: Poison Resistance
  Corrup:
    dataType: smallint
    nullable: NO
    description: Corruption Resistance
  mindmg:
    dataType: int
    nullable: NO
    description: Minimum Damage
  maxdmg:
    dataType: int
    nullable: NO
    description: Maximum Damage
  attack_count:
    dataType: smallint
    nullable: NO
    description: Attack Count
  attack_speed:
    dataType: tinyint
    nullable: NO
    description: 'Attack Speed: The lower the number, the faster the NPC hits. (Deprecated)'
  attack_delay:
    dataType: tinyint
    nullable: NO
    description: 'Attack Delay: Delay between the attack arounds in 10ths of a second.'
  special_abilities:
    dataType: text
    nullable: YES
    description: Special Abilities
  Accuracy:
    dataType: mediumint
    nullable: NO
    description: Accuracy
  hp_regen_rate:
    dataType: int
    nullable: NO
    description: Health Regeneration Rate
  mana_regen_rate:
    dataType: int
    nullable: NO
    description: Mana Regeneration Rate
  runspeed:
    dataType: float
    nullable: NO
    description: Run Speed
  statscale:
    dataType: int
    nullable: NO
    description: 'Stat Scale: 50 = 50%, 100 = 100%, 150 = 150%'
  spellscale:
    dataType: float
    nullable: NO
    description: 'Spell Scale: 50 = 50%, 100 = 100%, 150 = 150%'
  healscale:
    dataType: float
    nullable: NO
    description: 'Heal Scale: 50 = 50%, 100 = 100%, 150 = 150%'
merc_subtypes:
  merc_subtype_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Subtype Identifier
  class_id:
    dataType: int
    nullable: NO
    description: >-
      [Class
      Identifier](https://eqemu.gitbook.io/server/categories/player/class-list)
  tier_id:
    dataType: tinyint
    nullable: NO
    description: Tier Identifier
  confidence_id:
    dataType: tinyint
    nullable: NO
    description: Confidence Identifier
merc_templates:
  merc_template_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Template Identifier
  merc_type_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Type Identifier](merc_types.md)'
  merc_subtype_id:
    dataType: int
    nullable: NO
    description: '[Mercenary Subtype Identifier](merc_subtypes.md)'
  merc_npc_type_id:
    dataType: int
    nullable: NO
    description: '[Mercenary NPC Type Identifier](merc_npc_types.md)'
  dbstring:
    dataType: varchar
    nullable: NO
    description: '[DBString Identifier](db_str.md)'
  name_type_id:
    dataType: tinyint
    nullable: NO
    description: '[Name Type Identifier](merc_name_types.md)'
  clientversion:
    dataType: int
    nullable: NO
    description: >-
      [Client
      Version](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
merc_types:
  merc_type_id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Type Identifier
  race_id:
    dataType: int
    nullable: NO
    description: >-
      [Race
      Identifier](https://eqemu.gitbook.io/server/categories/npc/race-list)
  proficiency_id:
    dataType: tinyint
    nullable: NO
    description: Proficiency Identifier
  dbstring:
    dataType: varchar
    nullable: NO
    description: '[DBString Identifier](db_str.md)'
  clientversion:
    dataType: int
    nullable: NO
    description: >-
      [Client
      Version](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
merc_weaponinfo:
  id:
    dataType: int
    nullable: NO
    description: Unique Mercenary Weapon Info Identifier
  merc_npc_type_id:
    dataType: int
    nullable: NO
    description: '[Mercenary NPC Type Identifier](merc_npc_types.md)'
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  d_melee_texture1:
    dataType: int
    nullable: NO
    description: Primary Weapon Texture
  d_melee_texture2:
    dataType: int
    nullable: NO
    description: Secondary Weapon Texture
  prim_melee_type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Primary Melee
      Type](https://eqemu.gitbook.io/server/categories/player/skills)
  sec_melee_type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Secondary Melee
      Type](https://eqemu.gitbook.io/server/categories/player/skills)
name_filter:
  id:
    dataType: int
    nullable: NO
    description: Unique Name Filter Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
npc_emotes:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Emote Identifier
  emoteid:
    dataType: int
    nullable: NO
    description: Emote Identifier
  event_:
    dataType: tinyint
    nullable: NO
    description: >-
      [Emote Event Type
      Identifier](https://eqemu.gitbook.io/server/categories/npc/emote-event-types)
  type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Emote Type
      Identifier](https://eqemu.gitbook.io/server/categories/npc/emote-types)
  text:
    dataType: varchar
    nullable: NO
    description: Text
npc_faction:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Faction Identifier
  name:
    dataType: tinytext
    nullable: YES
    description: Name
  primaryfaction:
    dataType: int
    nullable: NO
    description: '[Primary Faction Identifier](faction_list.md)'
  ignore_primary_assist:
    dataType: tinyint
    nullable: NO
    description: 'Ignore Primary Assist: 0 = False, >0 = True'
npc_faction_entries:
  npc_faction_id:
    dataType: int
    nullable: NO
    description: '[NPC Faction Identifier](npc_faction.md)'
  faction_id:
    dataType: int
    nullable: NO
    description: '[Faction Identifier](faction_list.md)'
  value:
    dataType: int
    nullable: NO
    description: Value
  npc_value:
    dataType: tinyint
    nullable: NO
    description: 'NPC Value: -1 = Attack, 0 = Neutral, 1 = Assist'
  temp:
    dataType: tinyint
    nullable: NO
    description: >-
      Temeporary: 0 = Faction is permanent, player recieves a message, 1 =
      Faction is temporary, player does not recieve a message, 2 = Faction is
      temporary, player recieves a message, 3 = Faction is permanent, but player
      does not recieve a message.
npc_scale_global_base:
  type:
    dataType: int
    nullable: NO
    description: 'Type: 0 = Trash, 1 = Named, 2 = Raid'
  level:
    dataType: int
    nullable: NO
    description: Level
  ac:
    dataType: int
    nullable: YES
    description: Armor Class
  hp:
    dataType: int
    nullable: YES
    description: Health
  accuracy:
    dataType: int
    nullable: YES
    description: Accuracy
  slow_mitigation:
    dataType: int
    nullable: YES
    description: Slow Mitigation
  attack:
    dataType: int
    nullable: YES
    description: Attack
  strength:
    dataType: int
    nullable: YES
    description: Strength
  stamina:
    dataType: int
    nullable: YES
    description: Stamina
  dexterity:
    dataType: int
    nullable: YES
    description: Dexterity
  agility:
    dataType: int
    nullable: YES
    description: Agility
  intelligence:
    dataType: int
    nullable: YES
    description: Intelligence
  wisdom:
    dataType: int
    nullable: YES
    description: Wisdom
  charisma:
    dataType: int
    nullable: YES
    description: Charisma
  magic_resist:
    dataType: int
    nullable: YES
    description: Magic Resistance
  cold_resist:
    dataType: int
    nullable: YES
    description: Cold Resistance
  fire_resist:
    dataType: int
    nullable: YES
    description: Fire Resistance
  poison_resist:
    dataType: int
    nullable: YES
    description: Poison Resistance
  disease_resist:
    dataType: int
    nullable: YES
    description: Disease Resistance
  corruption_resist:
    dataType: int
    nullable: YES
    description: Corruption Resistance
  physical_resist:
    dataType: int
    nullable: YES
    description: Physical Resistance
  min_dmg:
    dataType: int
    nullable: YES
    description: Minimum Damage
  max_dmg:
    dataType: int
    nullable: YES
    description: Maximum Damage
  hp_regen_rate:
    dataType: int
    nullable: YES
    description: Health Regeneration Rate
  attack_delay:
    dataType: int
    nullable: YES
    description: 'Attack Delay: Delay between the attack arounds in 10ths of a second.'
  spell_scale:
    dataType: int
    nullable: YES
    description: 'Spell Scale: 50 = 50%, 100 = 100%, 150 = 150%'
  heal_scale:
    dataType: int
    nullable: YES
    description: 'Heal Scale: 50 = 50%, 100 = 100%, 150 = 150%'
  special_abilities:
    dataType: text
    nullable: YES
    description: Special Abilities
npc_spells:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Spell Set Identifier
  name:
    dataType: tinytext
    nullable: YES
    description: NPC Spell Set Name
  parent_list:
    dataType: int
    nullable: NO
    description: >-
      Inherit all the spells from this list, and merge them with our spells.
      Only one level of inheritance is allowed, so your parent's parent will not
      be included.
  attack_proc:
    dataType: smallint
    nullable: NO
    description: >-
      The combat proc that an NPC with this spell set will add to their list of
      procs. [Spell Identifier](spells_new.md)
  proc_chance:
    dataType: tinyint
    nullable: NO
    description: 'Proc Chance: 0 = Never, 100 = Always'
  range_proc:
    dataType: smallint
    nullable: NO
    description: >-
      The ranged proc that an NPC with this spell set will add to their list of
      procs.
  rproc_chance:
    dataType: smallint
    nullable: NO
    description: 'Ranged Proc Chance: 0 = Never, 100 = Always'
  defensive_proc:
    dataType: smallint
    nullable: NO
    description: >-
      The defensive proc that an NPC with this spell set will add to their list
      of procs.
  dproc_chance:
    dataType: smallint
    nullable: NO
    description: 'Defensive Proc Chance: 0 = Never, 100 = Always'
  fail_recast:
    dataType: int
    nullable: NO
    description: Fail Recast
  engaged_no_sp_recast_min:
    dataType: int
    nullable: NO
    description: ''
  engaged_no_sp_recast_max:
    dataType: int
    nullable: NO
    description: ''
  engaged_b_self_chance:
    dataType: tinyint
    nullable: NO
    description: ''
  engaged_b_other_chance:
    dataType: tinyint
    nullable: NO
    description: ''
  engaged_d_chance:
    dataType: tinyint
    nullable: NO
    description: ''
  pursue_no_sp_recast_min:
    dataType: int
    nullable: NO
    description: ''
  pursue_no_sp_recast_max:
    dataType: int
    nullable: NO
    description: ''
  pursue_d_chance:
    dataType: tinyint
    nullable: NO
    description: ''
  idle_no_sp_recast_min:
    dataType: int
    nullable: NO
    description: ''
  idle_no_sp_recast_max:
    dataType: int
    nullable: NO
    description: ''
  idle_b_chance:
    dataType: tinyint
    nullable: NO
    description: ''
npc_spells_effects:
  id:
    dataType: int
    nullable: NO
    description: Unique Spell Effects Identifier
  name:
    dataType: tinytext
    nullable: YES
    description: Name
  parent_list:
    dataType: int
    nullable: NO
    description: Parent List
npc_spells_effects_entries:
  id:
    dataType: int
    nullable: NO
    description: Unique Spell Effect Entry Identifier
  npc_spells_effects_id:
    dataType: int
    nullable: NO
    description: '[NPC Spells Effects Identifier](npc_spells_effects.md)'
  spell_effect_id:
    dataType: smallint
    nullable: NO
    description: >-
      [Spell Effect
      Identifier](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  se_base:
    dataType: int
    nullable: NO
    description: Spell Effect Base
  se_limit:
    dataType: int
    nullable: NO
    description: Spell Effect Limit
  se_max:
    dataType: int
    nullable: NO
    description: Spell Effect Maximum
npc_spells_entries:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Spell Entry Identifier
  npc_spells_id:
    dataType: int
    nullable: NO
    description: '[Unique NPC Spell Set Identifier](npc_spells.md)'
  spellid:
    dataType: smallint
    nullable: NO
    description: '[Spell Identifier](spells_new.md)'
  type:
    dataType: int
    nullable: NO
    description: >-
      [Spell Type
      Bitmask](https://eqemu.gitbook.io/server/categories/spells/spell-types)
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  manacost:
    dataType: smallint
    nullable: NO
    description: Mana Cost
  recast_delay:
    dataType: int
    nullable: NO
    description: Recast Delay
  priority:
    dataType: smallint
    nullable: NO
    description: >-
      Priority: 0 = Innate, 1 = Highest Priority, 5 = Lower Priority, 10 = Even
      Lower Priority
  resist_adjust:
    dataType: int
    nullable: YES
    description: Resist Adjustment
  min_hp:
    dataType: smallint
    nullable: YES
    description: Minimum Health Percentage
  max_hp:
    dataType: smallint
    nullable: YES
    description: Maximum Health Percentage
npc_types:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Type Identifier
  name:
    dataType: text
    nullable: NO
    description: Name
  lastname:
    dataType: varchar
    nullable: YES
    description: Last Name
  level:
    dataType: tinyint
    nullable: NO
    description: Level
  race:
    dataType: smallint
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  bodytype:
    dataType: int
    nullable: NO
    description: '[Body Type](https://eqemu.gitbook.io/server/categories/npc/body-types)'
  hp:
    dataType: int
    nullable: NO
    description: Health
  mana:
    dataType: int
    nullable: NO
    description: Mana
  gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  texture:
    dataType: tinyint
    nullable: NO
    description: '[Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  helmtexture:
    dataType: tinyint
    nullable: NO
    description: '[Helmet Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  herosforgemodel:
    dataType: int
    nullable: NO
    description: Hero's Forge Model
  size:
    dataType: float
    nullable: NO
    description: Size
  hp_regen_rate:
    dataType: int
    nullable: NO
    description: Health Regeneration
  mana_regen_rate:
    dataType: int
    nullable: NO
    description: Mana Regeneration
  loottable_id:
    dataType: int
    nullable: NO
    description: '[Loottable Identifier](loottable.md)'
  merchant_id:
    dataType: int
    nullable: NO
    description: '[Merchant Identifier](merchantlist.md)'
  alt_currency_id:
    dataType: int
    nullable: NO
    description: '[Alternate Currency Identifier](alternate_currency.md)'
  npc_spells_id:
    dataType: int
    nullable: NO
    description: '[NPC Spell Set Identifier](npc_spells.md)'
  npc_spells_effects_id:
    dataType: int
    nullable: NO
    description: '[NPC Spell Effects Identifier](npc_spells_effects.md)'
  npc_faction_id:
    dataType: int
    nullable: NO
    description: '[NPC Faction Identifier](faction_list.md)'
  adventure_template_id:
    dataType: int
    nullable: NO
    description: '[Adventure Template Identifier](adventure_template.md)'
  trap_template:
    dataType: int
    nullable: YES
    description: '[Trap Template Identifier](traps.md)'
  mindmg:
    dataType: int
    nullable: NO
    description: Minimum Damage
  maxdmg:
    dataType: int
    nullable: NO
    description: Maximum Damage
  attack_count:
    dataType: smallint
    nullable: NO
    description: Attack Count
  npcspecialattks:
    dataType: varchar
    nullable: NO
    description: NPC Special Attacks (Deprecated)
  special_abilities:
    dataType: text
    nullable: YES
    description: NPC Special Abilities
  aggroradius:
    dataType: int
    nullable: NO
    description: Aggro Radius
  assistradius:
    dataType: int
    nullable: NO
    description: Assist Radius
  face:
    dataType: int
    nullable: NO
    description: Face
  luclin_hairstyle:
    dataType: int
    nullable: NO
    description: Hair Style
  luclin_haircolor:
    dataType: int
    nullable: NO
    description: Hair Color
  luclin_eyecolor:
    dataType: int
    nullable: NO
    description: Eye Color 1
  luclin_eyecolor2:
    dataType: int
    nullable: NO
    description: Eye Color 2
  luclin_beardcolor:
    dataType: int
    nullable: NO
    description: Beard Color
  luclin_beard:
    dataType: int
    nullable: NO
    description: Beard
  drakkin_heritage:
    dataType: int
    nullable: NO
    description: Drakkin Heritage
  drakkin_tattoo:
    dataType: int
    nullable: NO
    description: Drakkin Tattoo
  drakkin_details:
    dataType: int
    nullable: NO
    description: Drakkin Details
  armortint_id:
    dataType: int
    nullable: NO
    description: '[Armor Tint Identifier](npc_types_tint.md)'
  armortint_red:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Red: 0 = None, 255 = Max'
  armortint_green:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Green: 0 = None, 255 = Max'
  armortint_blue:
    dataType: tinyint
    nullable: NO
    description: 'Armor Tint Blue: 0 = None, 255 = Max'
  d_melee_texture1:
    dataType: int
    nullable: NO
    description: Primary Weapon Texture
  d_melee_texture2:
    dataType: int
    nullable: NO
    description: Secondary Weapon Texture
  ammo_idfile:
    dataType: varchar
    nullable: NO
    description: Ammo Texture
  prim_melee_type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Primary Melee
      Type](https://eqemu.gitbook.io/server/categories/player/skills)
  sec_melee_type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Secondary Melee
      Type](https://eqemu.gitbook.io/server/categories/player/skills)
  ranged_type:
    dataType: tinyint
    nullable: NO
    description: '[Ranged Type](https://eqemu.gitbook.io/server/categories/player/skills)'
  runspeed:
    dataType: float
    nullable: NO
    description: Run Speed
  MR:
    dataType: smallint
    nullable: NO
    description: Magic Resistance
  CR:
    dataType: smallint
    nullable: NO
    description: Cold Resistance
  DR:
    dataType: smallint
    nullable: NO
    description: Disease Resistance
  FR:
    dataType: smallint
    nullable: NO
    description: Fire Resistance
  PR:
    dataType: smallint
    nullable: NO
    description: Poison Resistance
  Corrup:
    dataType: smallint
    nullable: NO
    description: Corruption Resistance
  PhR:
    dataType: smallint
    nullable: NO
    description: Physical Resistance
  see_invis:
    dataType: smallint
    nullable: NO
    description: 'See Invisible: 0 = False, 1 = True'
  see_invis_undead:
    dataType: smallint
    nullable: NO
    description: 'See Invisible vs. Undread: 0 = False, 1 = True'
  qglobal:
    dataType: int
    nullable: NO
    description: 'Quest Globals: 0 = Disabled, 1 = Enabled (Deprecated)'
  AC:
    dataType: smallint
    nullable: NO
    description: Armor Class
  npc_aggro:
    dataType: tinyint
    nullable: NO
    description: 'NPC Aggro: 0 = False, 1 = True'
  spawn_limit:
    dataType: tinyint
    nullable: NO
    description: Spawn Limit
  attack_speed:
    dataType: float
    nullable: NO
    description: 'Attack Speed: The lower the number, the faster the NPC hits. (Deprecated)'
  attack_delay:
    dataType: tinyint
    nullable: NO
    description: 'Attack Delay: Delay between the attack arounds in 10ths of a second.'
  findable:
    dataType: tinyint
    nullable: NO
    description: 'Findable: 0 = False, 1 = True'
  STR:
    dataType: mediumint
    nullable: NO
    description: Strength
  STA:
    dataType: mediumint
    nullable: NO
    description: Stamina
  DEX:
    dataType: mediumint
    nullable: NO
    description: Dexterity
  AGI:
    dataType: mediumint
    nullable: NO
    description: Agility
  _INT:
    dataType: mediumint
    nullable: NO
    description: Intelligence
  WIS:
    dataType: mediumint
    nullable: NO
    description: Wisdom
  CHA:
    dataType: mediumint
    nullable: NO
    description: Charisma
  see_hide:
    dataType: tinyint
    nullable: NO
    description: 'See Hide: 0 = False, 1 = True'
  see_improved_hide:
    dataType: tinyint
    nullable: NO
    description: 'See Improved Hide: 0 = False, 1 = True'
  trackable:
    dataType: tinyint
    nullable: NO
    description: 'Trackable: 0 = False, 1 = True'
  isbot:
    dataType: tinyint
    nullable: NO
    description: 'Is Bot: 0 = False, 1 = True'
  exclude:
    dataType: tinyint
    nullable: NO
    description: 'Exclude: 0 = False, 1 = True'
  ATK:
    dataType: mediumint
    nullable: NO
    description: Attack
  Accuracy:
    dataType: mediumint
    nullable: NO
    description: Accuracy
  Avoidance:
    dataType: mediumint
    nullable: NO
    description: Avoidance
  slow_mitigation:
    dataType: smallint
    nullable: NO
    description: Slow Mitigation
  version:
    dataType: smallint
    nullable: NO
    description: Version
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  scalerate:
    dataType: int
    nullable: NO
    description: Scale Rate
  private_corpse:
    dataType: tinyint
    nullable: NO
    description: 'Private Corpse: 0 = False, 1 = True'
  unique_spawn_by_name:
    dataType: tinyint
    nullable: NO
    description: 'Unique Spawn By Name: 0 = False, 1 = True'
  underwater:
    dataType: tinyint
    nullable: NO
    description: 'Underwater: 0 = False, 1 = True'
  isquest:
    dataType: tinyint
    nullable: NO
    description: 'Is Quest: 0 = False, 1 = True'
  emoteid:
    dataType: int
    nullable: NO
    description: '[Emote Identifier](npc_emotes.md)'
  spellscale:
    dataType: float
    nullable: NO
    description: 'Spell Scale: 25 = 25%, 50 = 50%, 100 = 100%'
  healscale:
    dataType: float
    nullable: NO
    description: 'Heal Scale: 25 = 25%, 50 = 50%, 100 = 100%'
  no_target_hotkey:
    dataType: tinyint
    nullable: NO
    description: 'No Target Hotkey: 0 = False, 1 = True'
  raid_target:
    dataType: tinyint
    nullable: NO
    description: 'Raid Target: 0 = False, 1 = True'
  armtexture:
    dataType: tinyint
    nullable: NO
    description: '[Arm Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  bracertexture:
    dataType: tinyint
    nullable: NO
    description: '[Bracer Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  handtexture:
    dataType: tinyint
    nullable: NO
    description: '[Hand Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  legtexture:
    dataType: tinyint
    nullable: NO
    description: '[Leg Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  feettexture:
    dataType: tinyint
    nullable: NO
    description: '[Feet Texture](https://eqemu.gitbook.io/server/categories/npc/textures)'
  light:
    dataType: tinyint
    nullable: NO
    description: Light
  walkspeed:
    dataType: tinyint
    nullable: NO
    description: Walk Speed
  peqid:
    dataType: int
    nullable: NO
    description: PEQ Identifier
  unique_:
    dataType: tinyint
    nullable: NO
    description: Unique
  fixed:
    dataType: tinyint
    nullable: NO
    description: Fixed
  ignore_despawn:
    dataType: tinyint
    nullable: NO
    description: 'Ignore Despawn: 0 = False, 1 = True'
  show_name:
    dataType: tinyint
    nullable: NO
    description: 'Show Name: 0 = False, 1 = True'
  untargetable:
    dataType: tinyint
    nullable: NO
    description: 'Untargetable: 0 = False, 1 = True'
  charm_ac:
    dataType: smallint
    nullable: YES
    description: Charmed Armor Class
  charm_min_dmg:
    dataType: int
    nullable: YES
    description: Charmed Minimum Damage
  charm_max_dmg:
    dataType: int
    nullable: YES
    description: Charmed Maximum Damage
  charm_attack_delay:
    dataType: tinyint
    nullable: YES
    description: Charmed Attack Delay
  charm_accuracy_rating:
    dataType: mediumint
    nullable: YES
    description: Charmed Accuracy
  charm_avoidance_rating:
    dataType: mediumint
    nullable: YES
    description: Charmed Avoidance
  charm_atk:
    dataType: mediumint
    nullable: YES
    description: Charmed Attack
  skip_global_loot:
    dataType: tinyint
    nullable: YES
    description: 'Skip Global Loot: 0 = False, 1 = True'
  rare_spawn:
    dataType: tinyint
    nullable: YES
    description: 'Rare Spawn: 0 = False, 1 = True'
  stuck_behavior:
    dataType: tinyint
    nullable: NO
    description: Stuck Behavior
  model:
    dataType: smallint
    nullable: NO
    description: Model
  flymode:
    dataType: tinyint
    nullable: NO
    description: '[Fly Mode](https://eqemu.gitbook.io/server/categories/npc/fly-modes)'
  always_aggro:
    dataType: tinyint
    nullable: NO
    description: 'Aggro regardless of _int or level : 0 = False, 1 = True'
npc_types_metadata:
  npc_types_id:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  isPKMob:
    dataType: tinyint
    nullable: NO
    description: 'Is PK Mob: 0 = False, 1 = True'
  isNamedMob:
    dataType: tinyint
    nullable: NO
    description: 'Is Named Mob: 0 = False, 1 = True'
  isRaidTarget:
    dataType: tinyint
    nullable: NO
    description: 'Is Raid Target: 0 = False, 1 = True'
  isCreatedMob:
    dataType: tinyint
    nullable: NO
    description: 'Is Created Mob: 0 = False, 1 = True'
  isCustomFeatureNPC:
    dataType: tinyint
    nullable: NO
    description: 'Is Custom Feature NPC: 0 = False, 1 = True'
npc_types_tint:
  id:
    dataType: int
    nullable: NO
    description: Unique NPC Type Tint Identifier
  tint_set_name:
    dataType: text
    nullable: NO
    description: Tint Set Name
  red1h:
    dataType: tinyint
    nullable: NO
    description: 'Red for Helmet: 0 = None, 255 = Max'
  grn1h:
    dataType: tinyint
    nullable: NO
    description: 'Green for Helmet: 0 = None, 255 = Max'
  blu1h:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Helmet: 0 = None, 255 = Max'
  red2c:
    dataType: tinyint
    nullable: NO
    description: 'Red for Chest: 0 = None, 255 = Max'
  grn2c:
    dataType: tinyint
    nullable: NO
    description: 'Green for Chest: 0 = None, 255 = Max'
  blu2c:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Chest: 0 = None, 255 = Max'
  red3a:
    dataType: tinyint
    nullable: NO
    description: 'Red for Arms: 0 = None, 255 = Max'
  grn3a:
    dataType: tinyint
    nullable: NO
    description: 'Green for Arms: 0 = None, 255 = Max'
  blu3a:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Arms: 0 = None, 255 = Max'
  red4b:
    dataType: tinyint
    nullable: NO
    description: 'Red for Bracers: 0 = None, 255 = Max'
  grn4b:
    dataType: tinyint
    nullable: NO
    description: 'Green for Bracers: 0 = None, 255 = Max'
  blu4b:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Bracers: 0 = None, 255 = Max'
  red5g:
    dataType: tinyint
    nullable: NO
    description: 'Red for Hands: 0 = None, 255 = Max'
  grn5g:
    dataType: tinyint
    nullable: NO
    description: 'Green for Hands: 0 = None, 255 = Max'
  blu5g:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Hands: 0 = None, 255 = Max'
  red6l:
    dataType: tinyint
    nullable: NO
    description: 'Red for Legs: 0 = None, 255 = Max'
  grn6l:
    dataType: tinyint
    nullable: NO
    description: 'Green for Legs: 0 = None, 255 = Max'
  blu6l:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Legs: 0 = None, 255 = Max'
  red7f:
    dataType: tinyint
    nullable: NO
    description: 'Red for Feet: 0 = None, 255 = Max'
  grn7f:
    dataType: tinyint
    nullable: NO
    description: 'Green for Feet: 0 = None, 255 = Max'
  blu7f:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Feet: 0 = None, 255 = Max'
  red8x:
    dataType: tinyint
    nullable: NO
    description: 'Red for Unknown: 0 = None, 255 = Max'
  grn8x:
    dataType: tinyint
    nullable: NO
    description: 'Green for Unknown: 0 = None, 255 = Max'
  blu8x:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Unknown: 0 = None, 255 = Max'
  red9x:
    dataType: tinyint
    nullable: NO
    description: 'Red for Unknown: 0 = None, 255 = Max'
  grn9x:
    dataType: tinyint
    nullable: NO
    description: 'Green for Unknown: 0 = None, 255 = Max'
  blu9x:
    dataType: tinyint
    nullable: NO
    description: 'Blue for Unknown: 0 = None, 255 = Max'
object:
  id:
    dataType: int
    nullable: NO
    description: Unique Object Identifier
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: smallint
    nullable: NO
    description: 'Version: -1 For All'
  xpos:
    dataType: float
    nullable: NO
    description: X Coordinate
  ypos:
    dataType: float
    nullable: NO
    description: Y Coordinate
  zpos:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: NO
    description: Charges
  objectname:
    dataType: varchar
    nullable: YES
    description: Object Name
  type:
    dataType: int
    nullable: NO
    description: '[Type](https://eqemu.gitbook.io/server/categories/zones/object-types)'
  icon:
    dataType: int
    nullable: NO
    description: Icon
  unknown08:
    dataType: mediumint
    nullable: NO
    description: Unknown
  unknown10:
    dataType: mediumint
    nullable: NO
    description: Unknown
  unknown20:
    dataType: int
    nullable: NO
    description: Unknown
  unknown24:
    dataType: int
    nullable: NO
    description: Unknown
  unknown60:
    dataType: int
    nullable: NO
    description: Unknown
  unknown64:
    dataType: int
    nullable: NO
    description: Unknown
  unknown68:
    dataType: int
    nullable: NO
    description: Unknown
  unknown72:
    dataType: int
    nullable: NO
    description: Unknown
  unknown76:
    dataType: int
    nullable: NO
    description: Unknown
  unknown84:
    dataType: int
    nullable: NO
    description: Unknown
  size:
    dataType: float
    nullable: NO
    description: Size
  tilt_x:
    dataType: float
    nullable: NO
    description: Tilt X
  tilt_y:
    dataType: float
    nullable: NO
    description: Tilt Y
  display_name:
    dataType: varchar
    nullable: YES
    description: Display Name
object_contents:
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  parentid:
    dataType: int
    nullable: NO
    description: '[Object Identifier](object.md)'
  bagidx:
    dataType: int
    nullable: NO
    description: Bag Index
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: NO
    description: Charges
  droptime:
    dataType: datetime
    nullable: NO
    description: Drop Time
  augslot1:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 1
  augslot2:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 2
  augslot3:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 3
  augslot4:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 4
  augslot5:
    dataType: mediumint
    nullable: YES
    description: Augment Slot 5
  augslot6:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 6
perl_event_export_settings:
  event_id:
    dataType: int
    nullable: NO
    description: '[Unique Perl Event Identifier](https://eqemu.gitbook.io/quest-api/events)'
  event_description:
    dataType: varchar
    nullable: YES
    description: Event Description
  export_qglobals:
    dataType: smallint
    nullable: YES
    description: 'Export QGlobals: 0 = False, 1 = True'
  export_mob:
    dataType: smallint
    nullable: YES
    description: 'Export Mob: 0 = False, 1 = True'
  export_zone:
    dataType: smallint
    nullable: YES
    description: 'Export Zone: 0 = False, 1 = True'
  export_item:
    dataType: smallint
    nullable: YES
    description: 'Export Item: 0 = False, 1 = True'
  export_event:
    dataType: smallint
    nullable: YES
    description: 'Export Event: 0 = False, 1 = True'
petitions:
  dib:
    dataType: int
    nullable: NO
    description: Unknown
  petid:
    dataType: int
    nullable: NO
    description: Unique Petition Entry Identifier
  charname:
    dataType: varchar
    nullable: NO
    description: '[Character Name](character_data.md)'
  accountname:
    dataType: varchar
    nullable: NO
    description: '[Account Name](account.md)'
  lastgm:
    dataType: varchar
    nullable: NO
    description: Last GM
  petitiontext:
    dataType: text
    nullable: NO
    description: Petition Text
  gmtext:
    dataType: text
    nullable: YES
    description: GM Text
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  urgency:
    dataType: int
    nullable: NO
    description: Urgency
  charclass:
    dataType: int
    nullable: NO
    description: >-
      [Character
      Class](https://eqemu.gitbook.io/server/categories/player/class-list)
  charrace:
    dataType: int
    nullable: NO
    description: '[Character Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  charlevel:
    dataType: int
    nullable: NO
    description: Character Level
  checkouts:
    dataType: int
    nullable: NO
    description: Checkouts
  unavailables:
    dataType: int
    nullable: NO
    description: Unavailables
  ischeckedout:
    dataType: tinyint
    nullable: NO
    description: 'Is Checked Out: 0 = False, 1 = True'
  senttime:
    dataType: bigint
    nullable: NO
    description: Sent Time UNIX Timestamp
pets:
  type:
    dataType: varchar
    nullable: NO
    description: '[NPC Type Name](npc_types.md)'
  petpower:
    dataType: int
    nullable: NO
    description: Pet Power
  npcID:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  temp:
    dataType: tinyint
    nullable: NO
    description: 'Temporary: 0 = False, 1 = True'
  petcontrol:
    dataType: tinyint
    nullable: NO
    description: 'Pet Control: 0 = No Control, 1 = No Attack Control, 2 = Full Control'
  petnaming:
    dataType: tinyint
    nullable: NO
    description: >-
      Pet Naming: 0 = Soandsos Pet, 1 = Soandsos Familiar, 2 = Soandsos Warder,
      3 = Random Naming (i.e. Gobaner), 4 = Keeps name from npc_types table
  monsterflag:
    dataType: tinyint
    nullable: NO
    description: 'Monster Flag: 0 = False, 1 = True'
  equipmentset:
    dataType: int
    nullable: NO
    description: '[Pet Equipment Set Identifier](pet_equipmentset.md)'
pets_equipmentset:
  set_id:
    dataType: int
    nullable: NO
    description: Unique Pet Equipment Set Identifier
  setname:
    dataType: varchar
    nullable: NO
    description: Pet Equipment Set Name
  nested_set:
    dataType: int
    nullable: NO
    description: Nested Set Identifier
pets_equipmentset_entries:
  set_id:
    dataType: int
    nullable: NO
    description: '[Pet Equipment Set Identifier](pets_equipmentset.md)'
  slot:
    dataType: int
    nullable: NO
    description: Slot
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
player_titlesets:
  id:
    dataType: int
    nullable: NO
    description: Unique Title Set Identifier
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  title_set:
    dataType: int
    nullable: NO
    description: Title Set
profanity_list:
  word:
    dataType: varchar
    nullable: NO
    description: Word
proximities:
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  exploreid:
    dataType: int
    nullable: NO
    description: '[Explore Identifier](goallists.md)'
  minx:
    dataType: float
    nullable: NO
    description: Minimum X Coordinate
  maxx:
    dataType: float
    nullable: NO
    description: Maximum X Coordinate
  miny:
    dataType: float
    nullable: NO
    description: Minimum Y Coordinate
  maxy:
    dataType: float
    nullable: NO
    description: Maximum Y Coordinate
  minz:
    dataType: float
    nullable: NO
    description: Minimum Z Coordinate
  maxz:
    dataType: float
    nullable: NO
    description: Maximum Z Coordinate
qs_merchant_transaction_record:
  transaction_id:
    dataType: int
    nullable: NO
    description: Unique Transaction Identifier
  time:
    dataType: timestamp
    nullable: YES
    description: Timestamp
  zone_id:
    dataType: int
    nullable: YES
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  merchant_id:
    dataType: int
    nullable: YES
    description: '[Merchant Identifier](merchantlist.md)'
  merchant_pp:
    dataType: int
    nullable: YES
    description: Merchant Platinum
  merchant_gp:
    dataType: int
    nullable: YES
    description: Merchant Gold
  merchant_sp:
    dataType: int
    nullable: YES
    description: Merchant Silver
  merchant_cp:
    dataType: int
    nullable: YES
    description: Merchant Copper
  merchant_items:
    dataType: mediumint
    nullable: YES
    description: Merchant Items
  char_id:
    dataType: int
    nullable: YES
    description: '[Unique Character Identifier](character_data.md)'
  char_pp:
    dataType: int
    nullable: YES
    description: Character Platinum
  char_gp:
    dataType: int
    nullable: YES
    description: Character Gold
  char_sp:
    dataType: int
    nullable: YES
    description: Character Silver
  char_cp:
    dataType: int
    nullable: YES
    description: Character Copper
  char_items:
    dataType: mediumint
    nullable: YES
    description: Character Items
qs_merchant_transaction_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  char_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [Character Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: mediumint
    nullable: YES
    description: Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Augment Slot 5
qs_player_aa_rate_hourly:
  char_id:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  hour_time:
    dataType: int
    nullable: NO
    description: Hour Time UNIX Timestamp
  aa_count:
    dataType: varchar
    nullable: YES
    description: AA Count
qs_player_delete_record:
  delete_id:
    dataType: int
    nullable: NO
    description: Unique Delete Identifier
  time:
    dataType: timestamp
    nullable: YES
    description: Time Timestamp
  char_id:
    dataType: int
    nullable: YES
    description: '[Character Identifier](character_data.md)'
  stack_size:
    dataType: mediumint
    nullable: YES
    description: Stack Size
  char_items:
    dataType: mediumint
    nullable: YES
    description: '[Character Items Identifier](items.md)'
qs_player_delete_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  char_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [Character Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: mediumint
    nullable: YES
    description: Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Augment Slot 5
qs_player_events:
  id:
    dataType: int
    nullable: NO
    description: Unique Event Identifier
  char_id:
    dataType: int
    nullable: YES
    description: '[Character Identifier](character_data.md)'
  event:
    dataType: int
    nullable: YES
    description: Event
  event_desc:
    dataType: varchar
    nullable: YES
    description: Event Description
  time:
    dataType: int
    nullable: YES
    description: Time UNIX Timestamp
qs_player_handin_record:
  handin_id:
    dataType: int
    nullable: NO
    description: Unique Handin Identifier
  time:
    dataType: timestamp
    nullable: YES
    description: Time Timestamp
  quest_id:
    dataType: int
    nullable: YES
    description: '[Quest Identifier](tasks.md)'
  char_id:
    dataType: int
    nullable: YES
    description: '[Character Identifier](character_data.md)'
  char_pp:
    dataType: int
    nullable: YES
    description: Character Platinum
  char_gp:
    dataType: int
    nullable: YES
    description: Character Gold
  char_sp:
    dataType: int
    nullable: YES
    description: Character Silver
  char_cp:
    dataType: int
    nullable: YES
    description: Character Copper
  char_items:
    dataType: mediumint
    nullable: YES
    description: '[Character Items Identifier](items.md)'
  npc_id:
    dataType: int
    nullable: YES
    description: '[NPC Type Identifier](npc_types.md)'
  npc_pp:
    dataType: int
    nullable: YES
    description: NPC Platinum
  npc_gp:
    dataType: int
    nullable: YES
    description: NPC Gold
  npc_sp:
    dataType: int
    nullable: YES
    description: NPC Silver
  npc_cp:
    dataType: int
    nullable: YES
    description: NPC Copper
  npc_items:
    dataType: mediumint
    nullable: YES
    description: '[NPC Item Identifier](items.md)'
qs_player_handin_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  action_type:
    dataType: char
    nullable: YES
    description: Action Type
  char_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [Character Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: mediumint
    nullable: YES
    description: Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Augment Slot 5
qs_player_move_record:
  move_id:
    dataType: int
    nullable: NO
    description: Unique Move Identifier
  time:
    dataType: timestamp
    nullable: YES
    description: Time Timestamp
  char_id:
    dataType: int
    nullable: YES
    description: '[Character Identifier](character_data.md)'
  from_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [From Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  to_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [To Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  stack_size:
    dataType: mediumint
    nullable: YES
    description: Stack Size
  char_items:
    dataType: mediumint
    nullable: YES
    description: '[Character Item Identifier](items.md)'
  postaction:
    dataType: tinyint
    nullable: YES
    description: Post Action
qs_player_move_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  from_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [From Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  to_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [To Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: mediumint
    nullable: YES
    description: Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Augment Slot 5
qs_player_npc_kill_record:
  fight_id:
    dataType: int
    nullable: NO
    description: Unique Fight Identifier
  npc_id:
    dataType: int
    nullable: YES
    description: '[NPC Type Identifier](npc_types.md)'
  type:
    dataType: int
    nullable: YES
    description: Type
  zone_id:
    dataType: int
    nullable: YES
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  time:
    dataType: timestamp
    nullable: YES
    description: Time Timestamp
qs_player_npc_kill_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  char_id:
    dataType: int
    nullable: YES
    description: '[Character Identifier](character_data.md)'
qs_player_speech:
  id:
    dataType: int
    nullable: NO
    description: Unique Speech Identifier
  from:
    dataType: varchar
    nullable: NO
    description: '[From Character Identifier](character_data.md)'
  to:
    dataType: varchar
    nullable: NO
    description: '[To Character Identifier](character_data.md)'
  message:
    dataType: varchar
    nullable: NO
    description: Message
  minstatus:
    dataType: smallint
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  guilddbid:
    dataType: int
    nullable: NO
    description: '[Guild Database Identifier](guilds.md)'
  type:
    dataType: tinyint
    nullable: NO
    description: Type
  timerecorded:
    dataType: timestamp
    nullable: NO
    description: Time Recorded Timestamp
qs_player_trade_record:
  trade_id:
    dataType: int
    nullable: NO
    description: Unique Trade Identifier
  time:
    dataType: timestamp
    nullable: YES
    description: Time Timestamp
  char1_id:
    dataType: int
    nullable: YES
    description: '[Character 1 Identifier](character_data.md)'
  char1_pp:
    dataType: int
    nullable: YES
    description: Character 1 Platinum
  char1_gp:
    dataType: int
    nullable: YES
    description: Character 1 Gold
  char1_sp:
    dataType: int
    nullable: YES
    description: Character 1 Silver
  char1_cp:
    dataType: int
    nullable: YES
    description: Character 1 Copper
  char1_items:
    dataType: mediumint
    nullable: YES
    description: '[Character 1 Item Identifier](items.md)'
  char2_id:
    dataType: int
    nullable: YES
    description: '[Character 2 Identifier](character_data.md)'
  char2_pp:
    dataType: int
    nullable: YES
    description: Character 2 Platinum
  char2_gp:
    dataType: int
    nullable: YES
    description: Character 2 Gold
  char2_sp:
    dataType: int
    nullable: YES
    description: Character 2 Silver
  char2_cp:
    dataType: int
    nullable: YES
    description: Character 2 Copper
  char2_items:
    dataType: mediumint
    nullable: YES
    description: '[Character 2 Item Identifier](items.md)'
qs_player_trade_record_entries:
  event_id:
    dataType: int
    nullable: YES
    description: Unique Event Identifier
  from_id:
    dataType: int
    nullable: YES
    description: '[From Character Identifier](character_data.md)'
  from_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [From Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  to_id:
    dataType: int
    nullable: YES
    description: '[To Character Identifier](character_data.md)'
  to_slot:
    dataType: mediumint
    nullable: YES
    description: >-
      [To Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  item_id:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: mediumint
    nullable: YES
    description: Charges
  aug_1:
    dataType: int
    nullable: YES
    description: Augment Slot 1
  aug_2:
    dataType: int
    nullable: YES
    description: Augment Slot 2
  aug_3:
    dataType: int
    nullable: YES
    description: Augment Slot 3
  aug_4:
    dataType: int
    nullable: YES
    description: Augment Slot 4
  aug_5:
    dataType: int
    nullable: YES
    description: Augment Slot 5
quest_globals:
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  npcid:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  name:
    dataType: varchar
    nullable: NO
    description: Name
  value:
    dataType: varchar
    nullable: NO
    description: Value
  expdate:
    dataType: int
    nullable: YES
    description: Expiration Date UNIX Timestamp
races:
  name:
    dataType: varchar
    nullable: NO
    description: '[Race Name](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  id:
    dataType: int
    nullable: NO
    description: >-
      [Race
      Identifier](https://eqemu.gitbook.io/server/categories/npc/race-list)
  no_coin:
    dataType: tinyint
    nullable: NO
    description: 'No Coin: 0 = False, 1 = True'
raid_details:
  raidid:
    dataType: int
    nullable: NO
    description: Unique Raid Identifier
  loottype:
    dataType: int
    nullable: NO
    description: Loot Type
  locked:
    dataType: tinyint
    nullable: NO
    description: 'Locked: 0 = False, 1 = True'
  motd:
    dataType: varchar
    nullable: YES
    description: Message of the Day
raid_leaders:
  gid:
    dataType: int
    nullable: NO
    description: '[Group Identifier](group_id.md)'
  rid:
    dataType: int
    nullable: NO
    description: '[Raid Identifier](raid_details.md)'
  marknpc:
    dataType: varchar
    nullable: NO
    description: 'Mark NPC: 0 = False, 1 = True'
  maintank:
    dataType: varchar
    nullable: NO
    description: 'Main Tank: 0 = False, 1 = True'
  assist:
    dataType: varchar
    nullable: NO
    description: 'Assist: 0 = False, 1 = True'
  puller:
    dataType: varchar
    nullable: NO
    description: 'Puller: 0 = False, 1 = True'
  leadershipaa:
    dataType: tinyblob
    nullable: NO
    description: Leadership AA
  mentoree:
    dataType: varchar
    nullable: NO
    description: 'Mentoree: 0 = False, 1 = True'
  mentor_percent:
    dataType: int
    nullable: NO
    description: 'Mentore Percent: 0 = None, 100 = Max'
raid_members:
  raidid:
    dataType: int
    nullable: NO
    description: '[Raid Identifier](raid_details.md)'
  charid:
    dataType: int
    nullable: NO
    description: '[Character Identifier](character_data.md)'
  groupid:
    dataType: int
    nullable: NO
    description: '[Group Identifier](group_id.md)'
  _class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  level:
    dataType: tinyint
    nullable: NO
    description: Level
  name:
    dataType: varchar
    nullable: NO
    description: Name
  isgroupleader:
    dataType: tinyint
    nullable: NO
    description: 'Is Group Leader: 0 = False, 1 = True'
  israidleader:
    dataType: tinyint
    nullable: NO
    description: 'Is Raid Leader: 0 = False, 1 = True'
  islooter:
    dataType: tinyint
    nullable: NO
    description: 'Is Looter: 0 = False, 1 = True'
reports:
  id:
    dataType: int
    nullable: NO
    description: Unique Report Identifier
  name:
    dataType: varchar
    nullable: YES
    description: Name
  reported:
    dataType: varchar
    nullable: YES
    description: Reported
  reported_text:
    dataType: text
    nullable: YES
    description: Reported Text
respawn_times:
  id:
    dataType: int
    nullable: NO
    description: Unique Respawn Time Identifier
  start:
    dataType: int
    nullable: NO
    description: Start UNIX Timestamp
  duration:
    dataType: int
    nullable: NO
    description: Duration in Seconds
  instance_id:
    dataType: smallint
    nullable: NO
    description: '[Instance Identifier](instance_list.md)'
rule_sets:
  ruleset_id:
    dataType: tinyint
    nullable: NO
    description: Unique Rule Set Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
rule_values:
  ruleset_id:
    dataType: tinyint
    nullable: NO
    description: '[Rule Set Identifier](rule_sets.md)'
  rule_name:
    dataType: varchar
    nullable: NO
    description: Rule Name
  rule_value:
    dataType: varchar
    nullable: NO
    description: Rule Value
  notes:
    dataType: text
    nullable: YES
    description: Notes
saylink:
  id:
    dataType: int
    nullable: NO
    description: Unique Saylink Identifier
  phrase:
    dataType: varchar
    nullable: NO
    description: Phrase
sharedbank:
  acctid:
    dataType: int
    nullable: YES
    description: '[Unique Account Identifier](account.md)'
  slotid:
    dataType: mediumint
    nullable: YES
    description: >-
      [Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
  itemid:
    dataType: int
    nullable: YES
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: YES
    description: Charges
  augslot1:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 1
  augslot2:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 2
  augslot3:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 3
  augslot4:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 4
  augslot5:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 5
  augslot6:
    dataType: mediumint
    nullable: NO
    description: Augment Slot 6
  custom_data:
    dataType: text
    nullable: YES
    description: Custom Data
skill_caps:
  skillID:
    dataType: tinyint
    nullable: NO
    description: >-
      [Skill
      Identifier](https://eqemu.gitbook.io/server/categories/player/skills)
  class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  level:
    dataType: tinyint
    nullable: NO
    description: Level
  cap:
    dataType: mediumint
    nullable: NO
    description: Cap
  class_:
    dataType: tinyint
    nullable: NO
    description: Unknown
spawn2:
  id:
    dataType: int
    nullable: NO
    description: Unique Spawn2 Entry Identifier
  spawngroupID:
    dataType: int
    nullable: NO
    description: '[Unique Spawngroup Identifier](spawngroup.md)'
  zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: smallint
    nullable: NO
    description: Version
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  respawntime:
    dataType: int
    nullable: NO
    description: Respawn Time in Seconds
  variance:
    dataType: int
    nullable: NO
    description: Variance in Seconds
  pathgrid:
    dataType: int
    nullable: NO
    description: '[Path Grid Identifier](grid.md)'
  _condition:
    dataType: mediumint
    nullable: NO
    description: Condition
  cond_value:
    dataType: mediumint
    nullable: NO
    description: Condition Value
  enabled:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = False, 1 = True'
  animation:
    dataType: tinyint
    nullable: NO
    description: '[Animation](https://eqemu.gitbook.io/server/categories/npc/animations)'
spawnentry:
  spawngroupID:
    dataType: int
    nullable: NO
    description: '[Unique Spawn Group Identifier](spawngroup.md)'
  npcID:
    dataType: int
    nullable: NO
    description: '[NPC Type Identifier](npc_types.md)'
  chance:
    dataType: smallint
    nullable: NO
    description: 'Chance: 0 = Never, 100 = Always'
  condition_value_filter:
    dataType: mediumint
    nullable: NO
    description: ''
spawngroup:
  id:
    dataType: int
    nullable: NO
    description: Unique Spawn Group Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  spawn_limit:
    dataType: tinyint
    nullable: NO
    description: Spawn Limit
  dist:
    dataType: float
    nullable: NO
    description: Distance
  max_x:
    dataType: float
    nullable: NO
    description: Max X Coordinate
  min_x:
    dataType: float
    nullable: NO
    description: Min X Coordinate
  max_y:
    dataType: float
    nullable: NO
    description: Max Y Coordinate
  min_y:
    dataType: float
    nullable: NO
    description: Min Y Coordinate
  delay:
    dataType: int
    nullable: NO
    description: Roaming Delay
  mindelay:
    dataType: int
    nullable: NO
    description: Minimum Delay
  despawn:
    dataType: tinyint
    nullable: NO
    description: >-
      [Despawn
      Type](https://eqemu.gitbook.io/server/categories/npc/spawns/npc-despawn-types)
  despawn_timer:
    dataType: int
    nullable: NO
    description: Despawn Timer in Seconds
  wp_spawns:
    dataType: tinyint
    nullable: NO
    description: ''
spawn_conditions:
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  id:
    dataType: mediumint
    nullable: NO
    description: Spawn Condition Identifier
  value:
    dataType: mediumint
    nullable: NO
    description: Value
  onchange:
    dataType: tinyint
    nullable: NO
    description: >-
      [On Change
      Type](https://eqemu.gitbook.io/server/categories/npc/spawns/on-change-types)
  name:
    dataType: varchar
    nullable: NO
    description: Name
spawn_condition_values:
  id:
    dataType: int
    nullable: NO
    description: '[Spawn Condition Identifier](spawn_conditions.md)'
  value:
    dataType: tinyint
    nullable: YES
    description: Value
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  instance_id:
    dataType: int
    nullable: NO
    description: '[Instance Identifier](instance_list.md)'
spawn_events:
  id:
    dataType: int
    nullable: NO
    description: Unique Spawn Event Entry Identifier
  zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  cond_id:
    dataType: mediumint
    nullable: NO
    description: '[Spawn Condition Identifier](spawn_conditions.md)'
  name:
    dataType: varchar
    nullable: NO
    description: Name
  period:
    dataType: int
    nullable: NO
    description: Period
  next_minute:
    dataType: tinyint
    nullable: NO
    description: Next Minute
  next_hour:
    dataType: tinyint
    nullable: NO
    description: Next Hour
  next_day:
    dataType: tinyint
    nullable: NO
    description: Next Day
  next_month:
    dataType: tinyint
    nullable: NO
    description: Next Month
  next_year:
    dataType: int
    nullable: NO
    description: Next Year
  enabled:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = False, 1 = True'
  action:
    dataType: tinyint
    nullable: NO
    description: >-
      [Action
      Type](https://eqemu.gitbook.io/server/categories/npc/spawns/action-types)
  argument:
    dataType: mediumint
    nullable: NO
    description: 'Argument: (Based on Action) 0 = Argument Value'
  strict:
    dataType: tinyint
    nullable: NO
    description: 'Strict Date Criteria: 0 = False, 1 = True'
spells_new:
  id:
    dataType: int
    nullable: NO
    description: Unique Spell Identifier
  name:
    dataType: varchar
    nullable: YES
    description: Name
  player_1:
    dataType: varchar
    nullable: YES
    description: Player_1
  teleport_zone:
    dataType: varchar
    nullable: YES
    description: >-
      The zone you are teleporting to or the [NPC Name](npc_types.md) you want
      to spawn.
  you_cast:
    dataType: varchar
    nullable: YES
    description: The message sent to others when you cast the spell.
  other_casts:
    dataType: varchar
    nullable: YES
    description: The message seen when someone around you casts the spell.
  cast_on_you:
    dataType: varchar
    nullable: YES
    description: The message received when the spell is cast on you.
  cast_on_other:
    dataType: varchar
    nullable: YES
    description: The message recieved when the spell is cast on another.
  spell_fades:
    dataType: varchar
    nullable: YES
    description: The message recieved when the spell fades.
  range:
    dataType: int
    nullable: NO
    description: Range
  aoerange:
    dataType: int
    nullable: NO
    description: Area of Effect Range
  pushback:
    dataType: int
    nullable: NO
    description: Push Back
  pushup:
    dataType: int
    nullable: NO
    description: Push Up
  cast_time:
    dataType: int
    nullable: NO
    description: Cast Time in Milliseconds
  recovery_time:
    dataType: int
    nullable: NO
    description: Recovery Time in Seconds
  recast_time:
    dataType: int
    nullable: NO
    description: Recast Time in Seconds
  buffdurationformula:
    dataType: int
    nullable: NO
    description: >-
      [Buff Duration
      Formula](https://eqemu.gitbook.io/server/categories/spells/buff-duration-formulas)
  buffduration:
    dataType: int
    nullable: NO
    description: Buff Duration
  AEDuration:
    dataType: int
    nullable: NO
    description: Area of Effect Duration
  mana:
    dataType: int
    nullable: NO
    description: Mana Cost
  effect_base_value1:
    dataType: int
    nullable: NO
    description: Effect Base Value 1
  effect_base_value2:
    dataType: int
    nullable: NO
    description: Effect Base Value 2
  effect_base_value3:
    dataType: int
    nullable: NO
    description: Effect Base Value 3
  effect_base_value4:
    dataType: int
    nullable: NO
    description: Effect Base Value 4
  effect_base_value5:
    dataType: int
    nullable: NO
    description: Effect Base Value 5
  effect_base_value6:
    dataType: int
    nullable: NO
    description: Effect Base Value 6
  effect_base_value7:
    dataType: int
    nullable: NO
    description: Effect Base Value 7
  effect_base_value8:
    dataType: int
    nullable: NO
    description: Effect Base Value 8
  effect_base_value9:
    dataType: int
    nullable: NO
    description: Effect Base Value 9
  effect_base_value10:
    dataType: int
    nullable: NO
    description: Effect Base Value 10
  effect_base_value11:
    dataType: int
    nullable: NO
    description: Effect Base Value 11
  effect_base_value12:
    dataType: int
    nullable: NO
    description: Effect Base Value 12
  effect_limit_value1:
    dataType: int
    nullable: NO
    description: Effect Limit Value 1
  effect_limit_value2:
    dataType: int
    nullable: NO
    description: Effect Limit Value 2
  effect_limit_value3:
    dataType: int
    nullable: NO
    description: Effect Limit Value 3
  effect_limit_value4:
    dataType: int
    nullable: NO
    description: Effect Limit Value 4
  effect_limit_value5:
    dataType: int
    nullable: NO
    description: Effect Limit Value 5
  effect_limit_value6:
    dataType: int
    nullable: NO
    description: Effect Limit Value 6
  effect_limit_value7:
    dataType: int
    nullable: NO
    description: Effect Limit Value 7
  effect_limit_value8:
    dataType: int
    nullable: NO
    description: Effect Limit Value 8
  effect_limit_value9:
    dataType: int
    nullable: NO
    description: Effect Limit Value 9
  effect_limit_value10:
    dataType: int
    nullable: NO
    description: Effect Limit Value 10
  effect_limit_value11:
    dataType: int
    nullable: NO
    description: Effect Limit Value 11
  effect_limit_value12:
    dataType: int
    nullable: NO
    description: Effect Limit Value 12
  max1:
    dataType: int
    nullable: NO
    description: Max 1
  max2:
    dataType: int
    nullable: NO
    description: Max 2
  max3:
    dataType: int
    nullable: NO
    description: Max 3
  max4:
    dataType: int
    nullable: NO
    description: Max 4
  max5:
    dataType: int
    nullable: NO
    description: Max 5
  max6:
    dataType: int
    nullable: NO
    description: Max 6
  max7:
    dataType: int
    nullable: NO
    description: Max 7
  max8:
    dataType: int
    nullable: NO
    description: Max 8
  max9:
    dataType: int
    nullable: NO
    description: Max 9
  max10:
    dataType: int
    nullable: NO
    description: Max 10
  max11:
    dataType: int
    nullable: NO
    description: Max 11
  max12:
    dataType: int
    nullable: NO
    description: Max 12
  icon:
    dataType: int
    nullable: NO
    description: Icon
  memicon:
    dataType: int
    nullable: NO
    description: Memmed Icon
  components1:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  components2:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  components3:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  components4:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  component_counts1:
    dataType: int
    nullable: NO
    description: Component Count 1
  component_counts2:
    dataType: int
    nullable: NO
    description: Component Count 2
  component_counts3:
    dataType: int
    nullable: NO
    description: Component Count 3
  component_counts4:
    dataType: int
    nullable: NO
    description: Component Count 4
  NoexpendReagent1:
    dataType: int
    nullable: NO
    description: >-
      If it is a number between 1-4 it means component number 1-4 is a focus and
      not to expend it. If it is a valid item ID it means this item is a focus
      as well.
  NoexpendReagent2:
    dataType: int
    nullable: NO
    description: >-
      If it is a number between 1-4 it means component number 1-4 is a focus and
      not to expend it. If it is a valid item ID it means this item is a focus
      as well.
  NoexpendReagent3:
    dataType: int
    nullable: NO
    description: >-
      If it is a number between 1-4 it means component number 1-4 is a focus and
      not to expend it. If it is a valid item ID it means this item is a focus
      as well.
  NoexpendReagent4:
    dataType: int
    nullable: NO
    description: >-
      If it is a number between 1-4 it means component number 1-4 is a focus and
      not to expend it. If it is a valid item ID it means this item is a focus
      as well.
  formula1:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      1](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula2:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      2](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula3:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      3](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula4:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      4](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula5:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      5](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula6:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      6](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula7:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      7](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula8:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      8](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula9:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      9](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula10:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      10](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula11:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      11](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  formula12:
    dataType: int
    nullable: NO
    description: >-
      [Formula
      12](https://eqemu.gitbook.io/server/categories/spells/base-value-formulas)
  LightType:
    dataType: int
    nullable: NO
    description: Light Type
  goodEffect:
    dataType: int
    nullable: NO
    description: 'Good Effect: 0 = Detrimental, 1 = Beneficial, 2 = Beneficial Group Only'
  Activated:
    dataType: int
    nullable: NO
    description: Activated
  resisttype:
    dataType: int
    nullable: NO
    description: >-
      [Resist
      Type](https://eqemu.gitbook.io/server/categories/spells/resist-types)
  effectid1:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      1](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid2:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      2](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid3:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      3](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid4:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      4](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid5:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      5](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid6:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      6](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid7:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      7](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid8:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      8](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid9:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      9](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid10:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      10](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid11:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      11](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  effectid12:
    dataType: int
    nullable: NO
    description: >-
      [Effect Identifier
      12](https://eqemu.gitbook.io/server/categories/spells/spell-effect-ids)
  targettype:
    dataType: int
    nullable: NO
    description: >-
      [Target
      Type](https://eqemu.gitbook.io/server/categories/spells/target-types)
  basediff:
    dataType: int
    nullable: NO
    description: Base Difficult Fizzle Adjustment
  skill:
    dataType: int
    nullable: NO
    description: >-
      [Skill
      Identifier](https://eqemu.gitbook.io/server/categories/player/skills)
  zonetype:
    dataType: int
    nullable: NO
    description: '[Zone Type](https://eqemu.gitbook.io/server/categories/zones/zone-types)'
  EnvironmentType:
    dataType: int
    nullable: NO
    description: >-
      [Environment
      Type](https://eqemu.gitbook.io/server/categories/spells/environment-types)
  TimeOfDay:
    dataType: int
    nullable: NO
    description: >-
      [Time of Day
      Type](https://eqemu.gitbook.io/server/categories/spells/time-of-day-types)
  classes1:
    dataType: int
    nullable: NO
    description: Required Level for Warrior
  classes2:
    dataType: int
    nullable: NO
    description: Required Level for Cleric
  classes3:
    dataType: int
    nullable: NO
    description: Required Level for Paladin
  classes4:
    dataType: int
    nullable: NO
    description: Required Level for Shadow Knight
  classes5:
    dataType: int
    nullable: NO
    description: Required Level for Ranger
  classes6:
    dataType: int
    nullable: NO
    description: Required Level for Druid
  classes7:
    dataType: int
    nullable: NO
    description: Required Level for Monk
  classes8:
    dataType: int
    nullable: NO
    description: Required Level for Bard
  classes9:
    dataType: int
    nullable: NO
    description: Required Level for Rogue
  classes10:
    dataType: int
    nullable: NO
    description: Required Level for Shaman
  classes11:
    dataType: int
    nullable: NO
    description: Required Level for Necromancer
  classes12:
    dataType: int
    nullable: NO
    description: Required Level for Wizard
  classes13:
    dataType: int
    nullable: NO
    description: Required Level for Magician
  classes14:
    dataType: int
    nullable: NO
    description: Required Level for Enchanter
  classes15:
    dataType: int
    nullable: NO
    description: Required Level for Beastlord
  classes16:
    dataType: int
    nullable: NO
    description: Required Level for Berserker
  CastingAnim:
    dataType: int
    nullable: NO
    description: Casting Animation
  TargetAnim:
    dataType: int
    nullable: NO
    description: Target Animation
  TravelType:
    dataType: int
    nullable: NO
    description: Travel Type (Unused)
  SpellAffectIndex:
    dataType: int
    nullable: NO
    description: Spell Affect Index
  disallow_sit:
    dataType: int
    nullable: NO
    description: 'Disallow Sit: 0 = False, 1 = True'
  deities0:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities1:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities2:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities3:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities4:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities5:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities6:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities7:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities8:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities9:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities10:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities11:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities12:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities13:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities14:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities15:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  deities16:
    dataType: int
    nullable: NO
    description: '[Deity List](https://eqemu.gitbook.io/server/categories/player/deity-list)'
  field142:
    dataType: int
    nullable: NO
    description: Unknown
  field143:
    dataType: int
    nullable: NO
    description: Unknown
  new_icon:
    dataType: int
    nullable: NO
    description: New Icon
  spellanim:
    dataType: int
    nullable: NO
    description: Spell Animation
  uninterruptable:
    dataType: int
    nullable: NO
    description: 'Uninterruptable: 0 = False, 1 = True'
  ResistDiff:
    dataType: int
    nullable: NO
    description: Resist Difference
  dot_stacking_exempt:
    dataType: int
    nullable: NO
    description: 'Damage Over Time Stacking Exempt: 0 = False, 1 = True'
  deleteable:
    dataType: int
    nullable: NO
    description: 'Deleteable: 0 = False, 1 = True'
  RecourseLink:
    dataType: int
    nullable: NO
    description: '[Recourse Spell Identifier](spells_new.md)'
  no_partial_resist:
    dataType: int
    nullable: NO
    description: 'No Partial Resist: 0 = False, 1 = True'
  field152:
    dataType: int
    nullable: NO
    description: Unknown
  field153:
    dataType: int
    nullable: NO
    description: Unknown
  short_buff_box:
    dataType: int
    nullable: NO
    description: 'Short Buff Box: 0 = False, 1 = True'
  descnum:
    dataType: int
    nullable: NO
    description: '[Description Number](db_str.md)'
  typedescnum:
    dataType: int
    nullable: YES
    description: '[Type Description Number](db_str.md)'
  effectdescnum:
    dataType: int
    nullable: YES
    description: '[Effect Description Number](db_str.md)'
  effectdescnum2:
    dataType: int
    nullable: NO
    description: '[Effect Description Number 2](db_str.md)'
  npc_no_los:
    dataType: int
    nullable: NO
    description: 'NPC No Line of Sight: 0 = False, 1 = True'
  field160:
    dataType: int
    nullable: NO
    description: Unknown
  reflectable:
    dataType: int
    nullable: NO
    description: 'Reflectable: 0 = False, 1 = True'
  bonushate:
    dataType: int
    nullable: NO
    description: Bonus Hate
  field163:
    dataType: int
    nullable: NO
    description: Unknown
  field164:
    dataType: int
    nullable: NO
    description: Unknown
  ldon_trap:
    dataType: int
    nullable: NO
    description: '[LDoN Trap Identifier](traps.md)'
  EndurCost:
    dataType: int
    nullable: NO
    description: Endurance Cost
  EndurTimerIndex:
    dataType: int
    nullable: NO
    description: Endurance Timer
  IsDiscipline:
    dataType: int
    nullable: NO
    description: 'Is Discipline: 0 = False, 1 = True'
  field169:
    dataType: int
    nullable: NO
    description: Unknown
  field170:
    dataType: int
    nullable: NO
    description: Unknown
  field171:
    dataType: int
    nullable: NO
    description: Unknown
  field172:
    dataType: int
    nullable: NO
    description: Unknown
  HateAdded:
    dataType: int
    nullable: NO
    description: Hate Added
  EndurUpkeep:
    dataType: int
    nullable: NO
    description: Endurance Upkeep
  numhitstype:
    dataType: int
    nullable: NO
    description: >-
      [Number of Hits
      Type](https://eqemu.gitbook.io/server/categories/spells/numhit-types)
  numhits:
    dataType: int
    nullable: NO
    description: Number of Hits
  pvpresistbase:
    dataType: int
    nullable: NO
    description: PVP Resist Base
  pvpresistcalc:
    dataType: int
    nullable: NO
    description: PVP Resist Calc
  pvpresistcap:
    dataType: int
    nullable: NO
    description: PVP Resist Cap
  spell_category:
    dataType: int
    nullable: NO
    description: >-
      [Spell
      Category](https://eqemu.gitbook.io/server/categories/spells/spell-groups)
  field181:
    dataType: int
    nullable: NO
    description: Unknown
  field182:
    dataType: int
    nullable: NO
    description: Unknown
  pcnpc_only_flag:
    dataType: int
    nullable: YES
    description: 'PC/NPC Only Flag: 0 = Not Applicable, 1 = PCs and Mercs, 2 = NPCs'
  cast_not_standing:
    dataType: int
    nullable: YES
    description: 'Cast Not Standing: 0 = False, 1 = True'
  can_mgb:
    dataType: int
    nullable: NO
    description: 'Can Mass Group Buff: 0 = False, 1 = True'
  nodispell:
    dataType: int
    nullable: NO
    description: 'No Dispell: 0 = False, 1 = True'
  npc_category:
    dataType: int
    nullable: NO
    description: >-
      [NPC Spell Category
      Identifier](https://eqemu.gitbook.io/server/categories/spells/npc-spell-categories)
  npc_usefulness:
    dataType: int
    nullable: NO
    description: NPC Usefulness
  MinResist:
    dataType: int
    nullable: NO
    description: Minimum Resistance
  MaxResist:
    dataType: int
    nullable: NO
    description: Maximum Resistance
  viral_targets:
    dataType: int
    nullable: NO
    description: Viral Targets
  viral_timer:
    dataType: int
    nullable: NO
    description: Viral Timer
  nimbuseffect:
    dataType: int
    nullable: YES
    description: Nimbus Effect
  ConeStartAngle:
    dataType: int
    nullable: NO
    description: Cone Start Angle
  ConeStopAngle:
    dataType: int
    nullable: NO
    description: Cone Stop Angle
  sneaking:
    dataType: int
    nullable: NO
    description: 'Sneaking: 0 = False, 1 = True'
  not_extendable:
    dataType: int
    nullable: NO
    description: 'Not Extendable: 0 = False, 1 = True'
  field198:
    dataType: int
    nullable: NO
    description: Unknown
  field199:
    dataType: int
    nullable: NO
    description: Unknown
  suspendable:
    dataType: int
    nullable: YES
    description: 'Suspendable: 0 = False, 1 = True'
  viral_range:
    dataType: int
    nullable: NO
    description: Viral Range
  songcap:
    dataType: int
    nullable: YES
    description: Song Cap
  field203:
    dataType: int
    nullable: YES
    description: Unknown
  field204:
    dataType: int
    nullable: YES
    description: Unknown
  no_block:
    dataType: int
    nullable: NO
    description: 'No Block: 0 = False, 1 = True'
  field206:
    dataType: int
    nullable: YES
    description: Unknown
  spellgroup:
    dataType: int
    nullable: YES
    description: >-
      [Spell
      Group](https://eqemu.gitbook.io/server/categories/spells/spell-groups)
  rank:
    dataType: int
    nullable: NO
    description: Rank
  field209:
    dataType: int
    nullable: YES
    description: Unknown
  field210:
    dataType: int
    nullable: YES
    description: Unknown
  CastRestriction:
    dataType: int
    nullable: NO
    description: >-
      [Cast
      Restrictions](https://eqemu.gitbook.io/server/categories/spells/spell-target-restrictions)
  allowrest:
    dataType: int
    nullable: YES
    description: 'Allow Rest: 0 = False, 1 = True'
  InCombat:
    dataType: int
    nullable: NO
    description: 'In Combat: 0 = False, 1 = True'
  OutofCombat:
    dataType: int
    nullable: NO
    description: 'Out Of Combat: 0 = False, 1 = True'
  field215:
    dataType: int
    nullable: YES
    description: Unknown
  field216:
    dataType: int
    nullable: YES
    description: Unknown
  field217:
    dataType: int
    nullable: YES
    description: Unknown
  aemaxtargets:
    dataType: int
    nullable: NO
    description: Area of Effect Max Targets
  maxtargets:
    dataType: int
    nullable: YES
    description: Max Targets
  field220:
    dataType: int
    nullable: YES
    description: Unknown
  field221:
    dataType: int
    nullable: YES
    description: Unknown
  field222:
    dataType: int
    nullable: YES
    description: Unknown
  field223:
    dataType: int
    nullable: YES
    description: Unknown
  persistdeath:
    dataType: int
    nullable: YES
    description: 'Persist Death: 0 = False, 1 = True'
  field225:
    dataType: int
    nullable: NO
    description: Unknown
  field226:
    dataType: int
    nullable: NO
    description: Unknown
  min_dist:
    dataType: float
    nullable: NO
    description: Minimum Distance
  min_dist_mod:
    dataType: float
    nullable: NO
    description: Minimum Distance Modifier
  max_dist:
    dataType: float
    nullable: NO
    description: Maximum Distance
  max_dist_mod:
    dataType: float
    nullable: NO
    description: Maximum Distance Modifier
  min_range:
    dataType: int
    nullable: NO
    description: Minimum Range
  field232:
    dataType: int
    nullable: NO
    description: Unknown
  field233:
    dataType: int
    nullable: NO
    description: Unknown
  field234:
    dataType: int
    nullable: NO
    description: Unknown
  field235:
    dataType: int
    nullable: NO
    description: Unknown
  field236:
    dataType: int
    nullable: NO
    description: Unknown
spell_buckets:
  spellid:
    dataType: bigint
    nullable: NO
    description: '[Unique Spell Identifier](spells_new.md)'
  key:
    dataType: varchar
    nullable: YES
    description: '[Data Bucket Name](data_buckets.md)'
  value:
    dataType: text
    nullable: YES
    description: Data Bucket Value
spell_globals:
  spellid:
    dataType: int
    nullable: NO
    description: '[Unique Spell Identifier](spells_new.md)'
  spell_name:
    dataType: varchar
    nullable: NO
    description: '[Spell Name](spells_new.md)'
  qglobal:
    dataType: varchar
    nullable: NO
    description: '[Quest Global Name](quest_globals.md)'
  value:
    dataType: varchar
    nullable: NO
    description: Quest Global Value
starting_items:
  id:
    dataType: int
    nullable: NO
    description: Unique Starting Items Entry Identifier
  race:
    dataType: int
    nullable: NO
    description: '[Race](https://eqemu.gitbook.io/server/categories/npc/race-list): 0 = All'
  class:
    dataType: int
    nullable: NO
    description: >-
      [Class](https://eqemu.gitbook.io/server/categories/player/class-list): 0 =
      All
  deityid:
    dataType: int
    nullable: NO
    description: >-
      [Deity](https://eqemu.gitbook.io/server/categories/player/deity-list): 0 =
      Alll
  zoneid:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  itemid:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  item_charges:
    dataType: tinyint
    nullable: NO
    description: Item Charges
  gm:
    dataType: tinyint
    nullable: NO
    description: 'GM: 0 = False, 1 = True'
  slot:
    dataType: mediumint
    nullable: NO
    description: >-
      [Slot](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
start_zones:
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  zone_id:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  bind_id:
    dataType: int
    nullable: NO
    description: Bind Identifier
  player_choice:
    dataType: int
    nullable: NO
    description: Player Choice
  player_class:
    dataType: int
    nullable: NO
    description: >-
      [Player
      Class](https://eqemu.gitbook.io/server/categories/player/class-list)
  player_deity:
    dataType: int
    nullable: NO
    description: >-
      [Player
      Deity](https://eqemu.gitbook.io/server/categories/player/deity-list)
  player_race:
    dataType: int
    nullable: NO
    description: '[Player Race](https://eqemu.gitbook.io/server/categories/npc/race-list)'
  start_zone:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  bind_x:
    dataType: float
    nullable: NO
    description: Bind X Coordinate
  bind_y:
    dataType: float
    nullable: NO
    description: Bind Y Coordinate
  bind_z:
    dataType: float
    nullable: NO
    description: Bind Z Coordinate
  select_rank:
    dataType: tinyint
    nullable: NO
    description: 'Select Rank: Always 50'
tasks:
  id:
    dataType: int
    nullable: NO
    description: Unique Task Identifier
  type:
    dataType: tinyint
    nullable: NO
    description: >-
      [Task
      Type](https://eqemu.gitbook.io/server/categories/task-system-guide/task-types)
  duration:
    dataType: int
    nullable: NO
    description: Duration
  duration_code:
    dataType: tinyint
    nullable: NO
    description: >-
      [Duration
      Code](https://eqemu.gitbook.io/server/categories/task-system-guide/task-duration-codes)
  title:
    dataType: varchar
    nullable: NO
    description: Title
  description:
    dataType: text
    nullable: NO
    description: Description
  reward:
    dataType: varchar
    nullable: NO
    description: Reward Description
  rewardid:
    dataType: int
    nullable: NO
    description: '[Reward Item Identifier](items.md)'
  cashreward:
    dataType: int
    nullable: NO
    description: Cash Reward in Copper
  xpreward:
    dataType: int
    nullable: NO
    description: Experience Reward
  rewardmethod:
    dataType: tinyint
    nullable: NO
    description: 'Reward Method: 0 = Single Item ID, 1 = List of Items, 2 = Quest Controlled'
  minlevel:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  maxlevel:
    dataType: tinyint
    nullable: NO
    description: Maximum Level
  repeatable:
    dataType: tinyint
    nullable: NO
    description: 'Repeatable: 0 = False, 1 = True'
  faction_reward:
    dataType: int
    nullable: NO
    description: Faction Reward
  completion_emote:
    dataType: varchar
    nullable: NO
    description: Completion Emote
tasksets:
  id:
    dataType: int
    nullable: NO
    description: Unique Task Set Entry Identifier
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
task_activities:
  taskid:
    dataType: int
    nullable: NO
    description: '[Task Identifier](tasks.md)'
  activityid:
    dataType: int
    nullable: NO
    description: 'Activity Identifier: Starts at 0'
  step:
    dataType: int
    nullable: NO
    description: 'Step: 0 = Always Available, >0 = Must Complete Previous'
  activitytype:
    dataType: tinyint
    nullable: NO
    description: >-
      [Activity
      Type](https://eqemu.gitbook.io/server/categories/task-system-guide/task-activity-types)
  target_name:
    dataType: varchar
    nullable: NO
    description: Target Name
  item_list:
    dataType: varchar
    nullable: NO
    description: '[Item Identifier List](items.md)'
  skill_list:
    dataType: varchar
    nullable: NO
    description: >-
      [Skill Identifier
      List](https://eqemu.gitbook.io/server/categories/player/skills)
  spell_list:
    dataType: varchar
    nullable: NO
    description: '[Spell Identifier List](spells_new.md)'
  description_override:
    dataType: varchar
    nullable: NO
    description: Description Override
  goalid:
    dataType: int
    nullable: NO
    description: 'Goal Identifier or [Goal List Identifier](goallists.md)'
  goalmethod:
    dataType: int
    nullable: NO
    description: 'Goal Method: 0 = Single Value, 1 = List'
  goalcount:
    dataType: int
    nullable: YES
    description: Goal Count
  delivertonpc:
    dataType: int
    nullable: NO
    description: >-
      Deliver To NPC: 0 = No Delivery NPC, >0 = [NPC Type
      Identifier](npc_types.md)
  zones:
    dataType: varchar
    nullable: NO
    description: '[Zones List](https://eqemu.gitbook.io/server/categories/zones/zone-list)'
  optional:
    dataType: tinyint
    nullable: NO
    description: 'Optional: 0 = False, 1 = True'
timers:
  char_id:
    dataType: int
    nullable: NO
    description: '[Unique Character Identifier](character_data.md)'
  type:
    dataType: mediumint
    nullable: NO
    description: Type
  start:
    dataType: int
    nullable: NO
    description: Start UNIX Timestamp
  duration:
    dataType: int
    nullable: NO
    description: Duration
  enable:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = False, 1 = True'
titles:
  id:
    dataType: int
    nullable: NO
    description: Unique Title Identifier
  skill_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Skill
      Identifier](https://eqemu.gitbook.io/server/categories/player/skills)
  min_skill_value:
    dataType: mediumint
    nullable: NO
    description: Minimum Skill Value
  max_skill_value:
    dataType: mediumint
    nullable: NO
    description: Maximum Skill Value
  min_aa_points:
    dataType: mediumint
    nullable: NO
    description: Minimum AA Points
  max_aa_points:
    dataType: mediumint
    nullable: NO
    description: Maximum AA Points
  class:
    dataType: tinyint
    nullable: NO
    description: '[Class](https://eqemu.gitbook.io/server/categories/player/class-list)'
  gender:
    dataType: tinyint
    nullable: NO
    description: '[Gender](https://eqemu.gitbook.io/server/categories/npc/genders)'
  char_id:
    dataType: int
    nullable: NO
    description: '[Unique Character Identifier](character_data.md)'
  status:
    dataType: int
    nullable: NO
    description: >-
      [Required
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  prefix:
    dataType: varchar
    nullable: NO
    description: Prefix
  suffix:
    dataType: varchar
    nullable: NO
    description: Suffix
  title_set:
    dataType: int
    nullable: NO
    description: Title Set Identifier
trader:
  char_id:
    dataType: int
    nullable: NO
    description: '[Unique Character Identifier](character_data.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  serialnumber:
    dataType: int
    nullable: NO
    description: Serial Number
  charges:
    dataType: int
    nullable: NO
    description: Charges
  item_cost:
    dataType: int
    nullable: NO
    description: Item Cost
  slot_id:
    dataType: tinyint
    nullable: NO
    description: >-
      [Slot
      Identifier](https://eqemu.gitbook.io/server/categories/inventory/inventory-slots)
trader_audit:
  time:
    dataType: datetime
    nullable: NO
    description: Time
  seller:
    dataType: varchar
    nullable: NO
    description: Seller
  buyer:
    dataType: varchar
    nullable: NO
    description: Buyer
  itemname:
    dataType: varchar
    nullable: NO
    description: '[Item Name](items.md)'
  quantity:
    dataType: int
    nullable: NO
    description: Quantity
  totalcost:
    dataType: int
    nullable: NO
    description: Total Cost
  trantype:
    dataType: tinyint
    nullable: NO
    description: Transaction Type
tradeskill_recipe:
  id:
    dataType: int
    nullable: NO
    description: Unique Tradeskill Recipe Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Recipe Name
  tradeskill:
    dataType: smallint
    nullable: NO
    description: '[Tradeskill](https://eqemu.gitbook.io/server/categories/player/skills)'
  skillneeded:
    dataType: smallint
    nullable: NO
    description: Skill Level Needed
  trivial:
    dataType: smallint
    nullable: NO
    description: Trivial Skill Level
  nofail:
    dataType: tinyint
    nullable: NO
    description: 'No Fail: 0 = False, 1 = True'
  replace_container:
    dataType: tinyint
    nullable: NO
    description: 'Replace Container: 0 = False, 1 = True'
  notes:
    dataType: tinytext
    nullable: YES
    description: Notes
  must_learn:
    dataType: tinyint
    nullable: NO
    description: 'Must Learn: 0 = False, 1 = True'
  quest:
    dataType: tinyint
    nullable: NO
    description: 'Quest: 0 = False, 1 = True'
  enabled:
    dataType: tinyint
    nullable: NO
    description: 'Enabled: 0 = False, 1 = True'
tradeskill_recipe_entries:
  id:
    dataType: int
    nullable: NO
    description: Unique Tradeskill Recipe Entry Identifier
  recipe_id:
    dataType: int
    nullable: NO
    description: '[Unique Tradeskill Recipe Identifier](tradeskill_recipe.md)'
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  successcount:
    dataType: tinyint
    nullable: NO
    description: Success Count
  failcount:
    dataType: tinyint
    nullable: NO
    description: Fail Count
  componentcount:
    dataType: tinyint
    nullable: NO
    description: Component Count
  salvagecount:
    dataType: tinyint
    nullable: NO
    description: Salvage Count
  iscontainer:
    dataType: tinyint
    nullable: NO
    description: 'Is Container: 0 = False, 1 = True'
traps:
  id:
    dataType: int
    nullable: NO
    description: Unique Trap Identifier
  zone:
    dataType: varchar
    nullable: NO
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: smallint
    nullable: NO
    description: 'Version: -1 For All'
  x:
    dataType: int
    nullable: NO
    description: X Coordinate
  y:
    dataType: int
    nullable: NO
    description: Y Coordinate
  z:
    dataType: int
    nullable: NO
    description: Z Coordinate
  chance:
    dataType: tinyint
    nullable: NO
    description: 'Chance: 0 = None, 100 = Always'
  maxzdiff:
    dataType: float
    nullable: NO
    description: Max Z Difference
  radius:
    dataType: float
    nullable: NO
    description: Trap Radius
  effect:
    dataType: int
    nullable: NO
    description: '[Trap Type](https://eqemu.gitbook.io/server/categories/zones/trap-types)'
  effectvalue:
    dataType: int
    nullable: NO
    description: >-
      Effect Value: (Based on Trap Type) 0 = [Spell Identifier](spells_new.md),
      1 = Radius, 2 = [NPC Type Identifier](npc_types.md), 3 = [NPC Type
      Identifier](npc_types.md), 4 = Minimum Damage
  effectvalue2:
    dataType: int
    nullable: NO
    description: >-
      Effect Value 2: (Based on Trap Type) 0 = Unused, 1 = (0 = Everything Will
      Aggro, 1 = Only KoS Will Agro), 2 = Number of NPCs, 3 = Number of NPCs, 4
      = Maximum Damage
  message:
    dataType: varchar
    nullable: NO
    description: Message
  skill:
    dataType: int
    nullable: NO
    description: '[Skill Required](https://eqemu.gitbook.io/server/categories/player/skills)'
  level:
    dataType: mediumint
    nullable: NO
    description: Level
  respawn_time:
    dataType: int
    nullable: NO
    description: Respawn Timer in Seconds
  respawn_var:
    dataType: int
    nullable: NO
    description: Random Respawn Timer Variance in Seconds
  triggered_number:
    dataType: tinyint
    nullable: NO
    description: Triggered Member
  group:
    dataType: tinyint
    nullable: NO
    description: Group
  despawn_when_triggered:
    dataType: tinyint
    nullable: NO
    description: 'Despawn When Triggered: 0 = False, 1 = True'
  undetectable:
    dataType: tinyint
    nullable: NO
    description: 'Undetectable: 0 = False, 1= True'
tributes:
  id:
    dataType: int
    nullable: NO
    description: Unique Tribute Identifier
  unknown:
    dataType: int
    nullable: NO
    description: Unknown
  name:
    dataType: varchar
    nullable: NO
    description: Name
  descr:
    dataType: mediumtext
    nullable: NO
    description: Description
  isguild:
    dataType: tinyint
    nullable: NO
    description: 'Is Guild: 0 = false, 1 = True'
tribute_levels:
  tribute_id:
    dataType: int
    nullable: NO
    description: '[Unique Tribute Identifier](tributes.md)'
  level:
    dataType: int
    nullable: NO
    description: Level
  cost:
    dataType: int
    nullable: NO
    description: Cost
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
variables:
  varname:
    dataType: varchar
    nullable: NO
    description: Variable Name
  value:
    dataType: text
    nullable: NO
    description: Value
  information:
    dataType: text
    nullable: NO
    description: Information
  ts:
    dataType: timestamp
    nullable: NO
    description: Timestamp
veteran_reward_templates:
  claim_id:
    dataType: int
    nullable: NO
    description: Unique Claim Identifier
  name:
    dataType: varchar
    nullable: NO
    description: Name
  item_id:
    dataType: int
    nullable: NO
    description: '[Item Identifier](items.md)'
  charges:
    dataType: smallint
    nullable: NO
    description: Charges
  reward_slot:
    dataType: tinyint
    nullable: NO
    description: Reward Slot
zone:
  short_name:
    dataType: varchar
    nullable: YES
    description: Short Name
  id:
    dataType: int
    nullable: NO
    description: Unique Entry Identifier
  file_name:
    dataType: varchar
    nullable: YES
    description: File Name
  long_name:
    dataType: text
    nullable: NO
    description: Long Name
  map_file_name:
    dataType: varchar
    nullable: YES
    description: Map File Name
  safe_x:
    dataType: float
    nullable: NO
    description: Safe X Coordinate
  safe_y:
    dataType: float
    nullable: NO
    description: Safe Y Coordinate
  safe_z:
    dataType: float
    nullable: NO
    description: Safe Z Coordinate
  graveyard_id:
    dataType: float
    nullable: NO
    description: '[Graveyard Identifier](graveyard.md)'
  min_level:
    dataType: tinyint
    nullable: NO
    description: Minimum Level
  min_status:
    dataType: tinyint
    nullable: NO
    description: >-
      [Minimum
      Status](https://eqemu.gitbook.io/server/categories/player/status-levels)
  zoneidnumber:
    dataType: int
    nullable: NO
    description: >-
      [Unique Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: tinyint
    nullable: NO
    description: Version
  timezone:
    dataType: int
    nullable: NO
    description: Timezone
  maxclients:
    dataType: int
    nullable: NO
    description: Maximum Clients
  ruleset:
    dataType: int
    nullable: NO
    description: '[Ruleset Identifier](rule_sets.md)'
  note:
    dataType: varchar
    nullable: YES
    description: Note
  underworld:
    dataType: float
    nullable: NO
    description: Bottom Z to represent when the player is under the world
  minclip:
    dataType: float
    nullable: NO
    description: Minimum Clipping Distance
  maxclip:
    dataType: float
    nullable: NO
    description: Maximum Clipping Distance
  fog_minclip:
    dataType: float
    nullable: NO
    description: Fog Minimum Clipping Distance
  fog_maxclip:
    dataType: float
    nullable: NO
    description: Fog Maximum Clipping Distance
  fog_blue:
    dataType: tinyint
    nullable: NO
    description: 'Fog Blue Level: 0 = None, 255 = Max'
  fog_red:
    dataType: tinyint
    nullable: NO
    description: 'Fog Red Level: 0 = None, 255 = Max'
  fog_green:
    dataType: tinyint
    nullable: NO
    description: 'Fog Green Level: 0 = None, 255 = Max'
  sky:
    dataType: tinyint
    nullable: NO
    description: Sky type the client will present as the backdrop
  ztype:
    dataType: tinyint
    nullable: NO
    description: >-
      This field is sent directly to the client on zone-in, most zones are set
      to 0, 1 or 255.
  zone_exp_multiplier:
    dataType: decimal
    nullable: NO
    description: >-
      This will multiply the XP to this percentage value (decimal based, 100% =
      1.0)
  walkspeed:
    dataType: float
    nullable: NO
    description: Walkspeed in this zone
  time_type:
    dataType: tinyint
    nullable: NO
    description: >-
      This value varies depending on the zone but it is sent to the client on
      zone in.  Most starting zones/newbie areas have this value set to 2,
      dungeons tyically have this set to 0, some zones break from the norm and
      have values greater than 2, (akanon = 3, blackburrow = 5, cazicthule = 5,
      crushbone = 5, erudnint = 4, kaladima = 3, etc.)
  fog_red1:
    dataType: tinyint
    nullable: NO
    description: 'Fog Red Level 1: 0 = None, 255 = Max'
  fog_green1:
    dataType: tinyint
    nullable: NO
    description: 'Fog Green Level 1: 0 = None, 255 = Max'
  fog_blue1:
    dataType: tinyint
    nullable: NO
    description: 'Fog Blue Level 1: 0 = None, 255 = Max'
  fog_minclip1:
    dataType: float
    nullable: NO
    description: Fog Minimum Clipping Distance 1
  fog_maxclip1:
    dataType: float
    nullable: NO
    description: Fog Maximum Clipping Distance 1
  fog_red2:
    dataType: tinyint
    nullable: NO
    description: 'Fog Red Level 2: 0 = None, 255 = Max'
  fog_green2:
    dataType: tinyint
    nullable: NO
    description: 'Fog Green Level 2: 0 = None, 255 = Max'
  fog_blue2:
    dataType: tinyint
    nullable: NO
    description: 'Fog Blue Level 2: 0 = None, 255 = Max'
  fog_minclip2:
    dataType: float
    nullable: NO
    description: Fog Minimum Clipping Distance 2
  fog_maxclip2:
    dataType: float
    nullable: NO
    description: Fog Maximum Clipping Distance 2
  fog_red3:
    dataType: tinyint
    nullable: NO
    description: 'Fog Red Level 3: 0 = None, 255 = Max'
  fog_green3:
    dataType: tinyint
    nullable: NO
    description: 'Fog Green Level 3: 0 = None, 255 = Max'
  fog_blue3:
    dataType: tinyint
    nullable: NO
    description: 'Fog Blue Level 3: 0 = None, 255 = Max'
  fog_minclip3:
    dataType: float
    nullable: NO
    description: Fog Minimum Clipping Distance 3
  fog_maxclip3:
    dataType: float
    nullable: NO
    description: Fog Maximum Clipping Distance 4
  fog_red4:
    dataType: tinyint
    nullable: NO
    description: 'Fog Red Level 4: 0 = None, 255 = Max'
  fog_green4:
    dataType: tinyint
    nullable: NO
    description: 'Fog Green Level 4: 0 = None, 255 = Max'
  fog_blue4:
    dataType: tinyint
    nullable: NO
    description: 'Fog Blue Level 4: 0 = None, 255 = Max'
  fog_minclip4:
    dataType: float
    nullable: NO
    description: Fog Minimum Clipping Distance 4
  fog_maxclip4:
    dataType: float
    nullable: NO
    description: Fog Maximum Clipping Distance 4
  fog_density:
    dataType: float
    nullable: NO
    description: >-
      This is the intensity of the fog, this should be a number between 0-1,
      most commonly used is .1 or .33
  flag_needed:
    dataType: varchar
    nullable: NO
    description: '[Flag Required](zone_flags.md)'
  canbind:
    dataType: tinyint
    nullable: NO
    description: 'Can Bind: 0 = False, 1 = True (for Caster), 2 = True (for All)'
  cancombat:
    dataType: tinyint
    nullable: NO
    description: 'Can Combat: 0 = False, 1 = True'
  canlevitate:
    dataType: tinyint
    nullable: NO
    description: 'Can Levitate: 0 = False, 1 = True (Does not affect those with #gm on)'
  castoutdoor:
    dataType: tinyint
    nullable: NO
    description: 'Cast Outdoors: 0 = False, 1 = True'
  hotzone:
    dataType: tinyint
    nullable: NO
    description: 'Hotzone: 0 = False, 1 = True'
  insttype:
    dataType: tinyint
    nullable: NO
    description: Instance Type
  shutdowndelay:
    dataType: bigint
    nullable: NO
    description: Shutdown Delay
  peqzone:
    dataType: tinyint
    nullable: NO
    description: '#peqzone: 0 = False, 1 = True'
  expansion:
    dataType: tinyint
    nullable: NO
    description: >-
      [Expansion](https://eqemu.gitbook.io/server/categories/operation/expansion-list)
  suspendbuffs:
    dataType: tinyint
    nullable: NO
    description: 'Suspend Buffs: 0 = False, 1 = True'
  rain_chance1:
    dataType: int
    nullable: NO
    description: Rain Chance 1
  rain_chance2:
    dataType: int
    nullable: NO
    description: Rain Chance 2
  rain_chance3:
    dataType: int
    nullable: NO
    description: Rain Chance 3
  rain_chance4:
    dataType: int
    nullable: NO
    description: Rain Chance 4
  rain_duration1:
    dataType: int
    nullable: NO
    description: Rain Duration 1
  rain_duration2:
    dataType: int
    nullable: NO
    description: Rain Duration 2
  rain_duration3:
    dataType: int
    nullable: NO
    description: Rain Duration 3
  rain_duration4:
    dataType: int
    nullable: NO
    description: Rain Duration 4
  snow_chance1:
    dataType: int
    nullable: NO
    description: Snow Chance 1
  snow_chance2:
    dataType: int
    nullable: NO
    description: Snow Chance 2
  snow_chance3:
    dataType: int
    nullable: NO
    description: Snow Chance 3
  snow_chance4:
    dataType: int
    nullable: NO
    description: Snow Chance 4
  snow_duration1:
    dataType: int
    nullable: NO
    description: Snow Duration 1
  snow_duration2:
    dataType: int
    nullable: NO
    description: Snow Duration 2
  snow_duration3:
    dataType: int
    nullable: NO
    description: Snow Duration 3
  snow_duration4:
    dataType: int
    nullable: NO
    description: Snow Duration 4
  gravity:
    dataType: float
    nullable: NO
    description: Gravity
  type:
    dataType: int
    nullable: NO
    description: >-
      Type (0 = Unknown, 1 = Regular, 2 = Instanced, 3 = Hybrid, 4 = Raid, 5 =
      City)
  skylock:
    dataType: tinyint
    nullable: NO
    description: Sky Lock
  fast_regen_hp:
    dataType: int
    nullable: NO
    description: Fast Regen Health
  fast_regen_mana:
    dataType: int
    nullable: NO
    description: Fast Regen Mana
  fast_regen_endurance:
    dataType: int
    nullable: NO
    description: Fast Regen Endurance
  npc_max_aggro_dist:
    dataType: int
    nullable: NO
    description: NPC Max Aggro Distance
  max_movement_update_range:
    dataType: int
    nullable: NO
    description: Max Movement Update Range
zoneserver_auth:
  host:
    dataType: varchar
    nullable: NO
    description: Host
  note:
    dataType: text
    nullable: YES
    description: Note
zone_flags:
  charID:
    dataType: int
    nullable: NO
    description: '[Unique Character Identifier](character_data.md)'
  zoneID:
    dataType: int
    nullable: NO
    description: >-
      [Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
zone_points:
  id:
    dataType: int
    nullable: NO
    description: Unique Zone Point Identifier
  zone:
    dataType: varchar
    nullable: YES
    description: >-
      [Zone Short
      Name](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  version:
    dataType: int
    nullable: NO
    description: Version
  number:
    dataType: smallint
    nullable: NO
    description: >-
      Represents the iterator field sent in the struct ZonePoint_Entry, zone
      points for the current zone are sent when client zones in (during
      Client::Handle_Connect_OP_ReqClientSpawn in client_packet.cpp).  This
      number field must be unique and also could have a hardcoded equivalent in
      the client, eg. client is expecting a specific number value for a zone
      point or teleport/object pad, such as in Erudin (erudnext).
  y:
    dataType: float
    nullable: NO
    description: Y Coordinate
  x:
    dataType: float
    nullable: NO
    description: X Coordinate
  z:
    dataType: float
    nullable: NO
    description: Z Coordinate
  heading:
    dataType: float
    nullable: NO
    description: Heading Coordinate
  target_y:
    dataType: float
    nullable: NO
    description: Target Y Coordinate
  target_x:
    dataType: float
    nullable: NO
    description: Target X Coordinate
  target_z:
    dataType: float
    nullable: NO
    description: Target Z Coordinate
  target_heading:
    dataType: float
    nullable: NO
    description: Target Heading Coordinate
  zoneinst:
    dataType: smallint
    nullable: YES
    description: '[Instance Identifier](instance_list.d)'
  target_zone_id:
    dataType: int
    nullable: NO
    description: >-
      [Target Zone
      Identifier](https://eqemu.gitbook.io/server/categories/zones/zone-list)
  target_instance:
    dataType: int
    nullable: NO
    description: Target Instance Identifier
  buffer:
    dataType: float
    nullable: YES
    description: Zone Point Buffer
  client_version_mask:
    dataType: int
    nullable: NO
    description: >-
      [Client Version
      Mask](https://eqemu.gitbook.io/server/categories/player/client-version-bitmasks)
zone_server:
  name:
    dataType: varchar
    nullable: NO
    description: Name
  address:
    dataType: text
    nullable: NO
    description: IP Address
  port:
    dataType: int
    nullable: NO
    description: Port
  player_count:
    dataType: int
    nullable: NO
    description: Player Count
  last_alive:
    dataType: timestamp
    nullable: NO
    description: Last Alive Timestamp
  rain:
    dataType: char
    nullable: NO
    description: Rain
login_accounts:
  id:
    dataType: int
    nullable: NO
    description: Unique Account Identifier
  account_name:
    dataType: varchar
    nullable: NO
    description: '[Account Name](account.md)'
  account_password:
    dataType: text
    nullable: NO
    description: Account Password
  account_email:
    dataType: varchar
    nullable: NO
    description: Account Email
  source_loginserver:
    dataType: varchar
    nullable: YES
    description: Source Loginserver
  last_ip_address:
    dataType: varchar
    nullable: NO
    description: '[Last IP Address](account_ip.md)'
  last_login_date:
    dataType: datetime
    nullable: NO
    description: Last Login Date
  created_at:
    dataType: datetime
    nullable: YES
    description: Created At Date
  updated_at:
    dataType: datetime
    nullable: YES
    description: Updated At Date
login_api_tokens:
  id:
    dataType: int
    nullable: NO
    description: Unique Login API Token Identifier
  token:
    dataType: varchar
    nullable: YES
    description: Token Identifier
  can_write:
    dataType: int
    nullable: YES
    description: 'Can Write: 0 = False, 1 = True'
  can_read:
    dataType: int
    nullable: YES
    description: 'Can Read: 0 = False, 1 = True'
  created_at:
    dataType: datetime
    nullable: YES
    description: Created At Date
  updated_at:
    dataType: datetime
    nullable: YES
    description: Updated At Date
login_server_admins:
  id:
    dataType: int
    nullable: NO
    description: Unique Account Identifier
  account_name:
    dataType: varchar
    nullable: NO
    description: Account Name
  account_password:
    dataType: varchar
    nullable: NO
    description: Account Password
  first_name:
    dataType: varchar
    nullable: NO
    description: First Name
  last_name:
    dataType: varchar
    nullable: NO
    description: Last Name
  email:
    dataType: varchar
    nullable: NO
    description: Email
  registration_date:
    dataType: datetime
    nullable: NO
    description: Registration Date
  registration_ip_address:
    dataType: varchar
    nullable: NO
    description: '[Registration IP Address](account_ip.md)'
login_server_list_types:
  id:
    dataType: int
    nullable: NO
    description: Unique List Type Identifier
  description:
    dataType: varchar
    nullable: NO
    description: Description
login_world_servers:
  id:
    dataType: int
    nullable: NO
    description: Unique World Server Identifier
  long_name:
    dataType: varchar
    nullable: NO
    description: Long Name
  short_name:
    dataType: varchar
    nullable: NO
    description: Short Name
  tag_description:
    dataType: varchar
    nullable: NO
    description: Tag Description
  login_server_list_type_id:
    dataType: int
    nullable: NO
    description: '[List Type Identifier](login_server_list_types.md)'
  last_login_date:
    dataType: datetime
    nullable: YES
    description: Last Login Date
  last_ip_address:
    dataType: varchar
    nullable: YES
    description: Last IP Address
  login_server_admin_id:
    dataType: int
    nullable: NO
    description: '[Login Server Admin Identifier](login_server_admins.md)'
  is_server_trusted:
    dataType: int
    nullable: NO
    description: 'Is Server Trusted: 0 = False, 1 = True'
  note:
    dataType: varchar
    nullable: YES
    description: Note