Skip to content

area_template Table

Contains information about all areas and zones of the world, including flags, recommended level, faction ownership, and liquid type.

Schema Summary

Field Type Key Null Default Extra
entry mediumint(8) unsigned PRI NO 0
map_id mediumint(8) unsigned NO 0
zone_id mediumint(8) unsigned NO 0
explore_flag mediumint(8) unsigned NO 0
flags mediumint(8) unsigned NO 0
area_level mediumint(8) NO 0
name varchar(100) NO ''
team tinyint(3) unsigned NO 0
liquid_type tinyint(3) unsigned NO 0

Field Breakdown

  • entry - Primary Key. Unique area ID. (see AreaTable.dbc)
  • map_id - Map ID (from map_template.entry).
  • zone_id - Parent zone ID (references entry in same table). Defines the zone to which this sub-area belongs. (see area_template.entry (self-reference))
  • explore_flag - Exploration-related flags (internal).
  • flags - Bitmask of area properties:
  • 0x01 - Snow (Dun Morogh, Naxxramas, etc.)
  • 0x02 - Override parent breath particles
  • 0x04 - Development map only
  • 0x08 - Slave capital
  • 0x10 - Enemies PvP flagged
  • 0x20 - Slave capital (2)
  • 0x40 - Duel allowed
  • 0x80 - Arena
  • 0x100 - Main capital city
  • 0x200 - City (one specific zone)
  • area_level - Recommended level for the area.
  • name - Area name.
  • team - Faction ownership:
  • 2 - Alliance
  • 4 - Horde
  • liquid_type - Liquid type (from LiquidType.dbc):
  • 1 - Water
  • 2 - Ocean
  • 3 - Magma
  • 4 - Slime
  • 21 - Naxxramas slime