You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The SQLite database contains a series of tables dedicated to each of the model types. Following SQL best practices where possible.
The database can be accessed through the API provided by this module, or directly any SQLite API using queries.
The generated database has the following tables.
Tables
Table
Description
achievement
Contains information for all achievements.
book
Contains information about books.
charm
Contains information for all charms.
creature
Contains information for all creatures.
creature_ability
Contains all the abilities done by creatures.
creature_drop
Contains all the items dropped by creatures.
creature_location_coordinate
Contains the map positions in the locations of creatures.
creature_max_damage
Contains the breakdown of max damage done by creatures.
creature_sound
Contains all the sounds made by creatures.
database_info
Contains information about the database itself.
game_update
Contains information about game updates.
house
Contains all houses and guildhalls.
imbuement
Contains information for all imbuements.
imbuement_material
Contains the item materials for imbuements.
item
Contains information for all items.
item_attribute
Contains extra attributes and properties of items that only apply to certain types.
item_client_id
Contains every client ID of items, in the order the wiki lists them.
item_key
Contains the different key variations.
item_location_coordinate
Contains the map positions in the locations of items.
item_sound
Contains all the sounds made by items.
item_proficiency_perk
Contains weapon proficiency perks for items.
item_store_offer
Contains all offers for items in the Tibia store.
map
Contains the world map’s images.
mount
Contains information for all mounts.
npc
Contains information for all NPCs.
npc_destination
Contains all the NPCs’ travel destinations.
npc_job
Contains all the NPCs’ jobs.
npc_location
Contains all the NPCs’ positions.
npc_offer_buy
Contains all the NPCs’ buy offers.
npc_offer_sell
Contains all the NPCs’ sell offers.
npc_race
Contains all the NPCs’ races.
outfit
Contains information for all outfits.
outfit_image
Contains images for all outfits.
outfit_quest
Contains outfit and addon rewards for quests.
quest
Contains information for all quests.
quest_danger
Contains creatures that can be found in a quest.
quest_reward
Contains item rewards for quests.
rashid_position
Contains the positions for the NPC Rashid every day of the week.
spell
Contains information for all spells.
world
Contains information for all worlds.
Table schemas
!!! note
SQLite does not have an actual Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
This is not much of an issue in Python, but it might be an issue on more strict typed languages.
!!! note
- All columns are NULLABLE unless specified otherwise.
- `PRIMARY` keys are always `NOT NULL`.
achievement
Column
Type
Description
article_id
INTEGER / PRIMARY
The ID of the article containing this achievement.
title
TEXT
The title of the article containing the achievement.
name
TEXT
The name of the achievement.
grade
INTEGER
The grade of the achievement. Goes from 1 to 3.
points
INTEGER
The number of points this achievement gives.
description
TEXT
The official description shown for this achievement.
spoiler
TEXT
Brief instructions on how to complete the quest.
is_secret
BOOLEAN
Whether this is a secret achievement or not.
is_premium
BOOLEAN
Whether this achievement requires premium.
achievement_id
INTEGER
The internal ID of the achievement.
version
TEXT
Client version this achievement was implemented in.
status
TEXT
The status of the achievement in game.
timestamp
TIMESTAMP
ISO8601 timestamp of the article's last edit.
book
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this book.
title
TEXT
The title of the article containing this book.
name
TEXT
The name of the book.
book_type
TEXT
The type of item this book can be found in.
item_id
INTEGER
The item id of the book.
location
TEXT
Where the book can be found.
blurb
TEXT
A short introduction text of the book.
author
TEXT
The person that wrote the book, if known.
prev_book
TEXT
If the book is part of a series, the book that precedes this one.
next_book
TEXT
If the book is part of a series, the book that follows this one.
text
TEXT
The content of the book.
version
TEXT
The client version this book was introduced to the game.
status
TEXT
The status of the book in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
charm
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this charm.
title
TEXT
The title of the article containing this charm.
name
TEXT
The name of the charm.
type
TEXT
The type of the charm: Offensive, Defensive or Passive.
effect
TEXT
The effect of this charm.
cost_level_1
INTEGER
The charm points needed to unlock level 1.
cost_level_2
INTEGER
The charm points needed to unlock level 2.
cost_level_3
INTEGER
The charm points needed to unlock level 3.
image
BLOB
The charm's image bytes.
version
TEXT
Client version this charm was implemented in.
status
TEXT
The status of the charm in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
creature
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this creature.
title
TEXT
The title of the article containing this creature.
name
TEXT
The name of the creature in-game.
plural
TEXT
The plural of the name.
library_race
TEXT
The race name of the creature in Tibia.com's library.
article
TEXT
The grammatical article before the creature’s name. This is shown when looking at creatures. Bosses have no article.
hitpoints
INTEGER
The number of hitpoints the creature has. May be NULL if unknown.
experience
INTEGER
The number of experience the creature yields . May be NULL if unknown.
armor
INTEGER
The armor value of the creature. May be NULL if unknown.
mitigation
REAL
The creature's mitigation value. May be NULL if unknown.
speed
INTEGER
The speed value of the creature. May be NULL if unknown.
creature_class
TEXT
The class this creature belongs to (e.g. Demons, Humanoids, Mammals).
type_primary
TEXT
The type this creature belongs to (e.g. Archdemons, Dwarves, Apes).
type_secondary
TEXT
A secondary type this creature belongs to, if any.
bestiary_class
TEXT
The bestiary category of this creature. NULL for creatures not in the bestiary.
bestiary_level
TEXT
The bestiary level of this creature. NULL for creatures not in the bestiary.
bestiary_occurrence
TEXT
The bestiary’s rarity value of this creature. NULL for creatures not in the bestiary.
bosstiary_class
TEXT
The bosstiary category of this creature. NULL for creatures not in the bestiary.
runs_at
INTEGER
The amount of hitpoints when the creature starts to run away. 0 means it won't run away. May be NULL if unknown.
summon_cost
INTEGER
The mana cost to summon this creature. 0 means it cannot be summoned. May be NULL if unknown.
convince_cost
INTEGER
The mana cost to convince this creature. 0 means it cannot be convinced. May be NULL if unknown.
illusionable
BOOLEAN
Whether the player can turn into this creature with Creature Illusion. May be NULL if unknown.
pushable
BOOLEAN
Whether this creature can be pushed or not. May be NULL if unknown.
push_objects
BOOLEAN
Whether this creature can push objects or not. May be NULL if unknown.
paralysable
BOOLEAN
Whether this creature can be paralyzed or not. May be NULL if unknown.
sees_invisible
INTEGER
Whether this creature can see invisible players or not. May be NULL if unknown.
spawn_type
TEXT
The way this creature spawns.
attack_type
TEXT
How the creature attacks, in lower case (e.g. melee). May be NULL if unknown.
uses_spells
BOOLEAN
Whether this creature uses spells or not. May be NULL if unknown.
is_boss
INTEGER
Whether this creature is a boss or not.
cooldown
REAL
The cooldown in hours to fight the boss again.
modifier_physical
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_earth
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_fire
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_ice
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_energy
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_death
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_holy
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_drown
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_lifedrain
INTEGER
Percentage of damage the creature receives from this damage type. 0 being completely immune, 100 neutral. May be NULL if unknown.
modifier_healing
INTEGER
Percentage of healing the creature receives. 0 being completely immune, 100 neutral. May be NULL if unknown.
walks_through
TEXT
The type of fields the creature will walk through.
walks_around
TEXT
The type of fields the creature will walk around to avoid when possible.
location
TEXT
The locations where the creature can be found. Each Mapper Coords position shows as its label, or is left out without one.
race_id
INTEGER
The client race ID of the creature, the first integer in the value after wiki comments are removed, NULL when there is none.
loot_statistics_kills
INTEGER
The kills on the creature's Loot Statistics page that its drop chances come from. NULL when it has no page, or its page has no positive number of kills.
version
TEXT
The client version this creature was introduced to the game.
image
BLOB
The creature’s image bytes.
status
TEXT
The status of the creature in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
creature_ability
Column
Type
Description
creature_id
INTEGER
The id of the creature that does this ability.
name
TEXT
The name of the ability.
effect
TEXT
The effect of the ability, or the damage range. For a debuff, the reduction as value=<value>; duration=<duration>; flags=<flags>, without the empty parts, like value=50%; duration=10; flags=distance,melee. The flags are the reduced skills, in the order distance, melee, magic, shielding. For an outfit, yes if it changes the victim's outfit and no if it changes the creature's own. Empty for a haste.
element
TEXT
The element of damage type of the ability. This could also be a status condition instead. Haste, debuff and outfit change abilities are haste, debuff and outfit, and an outfit change has one row per outfit.
condition
TEXT
The condition the ability causes, in lower case, like poisoned or slowed. A melee attack that poisons is poisoned. NULL if unknown or none.
condition_value
INTEGER
The poison damage per turn a melee attack starts at, up to. NULL if unknown or not a poisoning melee attack.
creature_drop
Column
Type
Description
creature_id
INTEGER
The id of the creature that yields this drop.
item_id
INTEGER
The id of the dropped item.
chance
REAL
The chance percentage of this drop. NULL if unknown.
min
INTEGER
The minimum count of the dropped item.
max
INTEGER
The maximum count of the dropped item.
rarity
TEXT
The drop's rarity on the creature's article, in lower case: always, common, uncommon, semi-rare, rare or very rare. NULL if unknown, or if the article gives the item different rarities.
creature_location_coordinate
Column
Type
Description
creature_id
INTEGER
The id of the creature whose location has this map position.
x
INTEGER
The x coordinate of the position.
y
INTEGER
The y coordinate of the position.
z
INTEGER
The floor of the position.
label
TEXT
The text the location shows in place of the position, like here. NULL if it shows none.
position
INTEGER
The row's place in the order the location lists its map positions, from 0.
Each row is a {{Mapper Coords}} template in the creature's location, in the order they are written. x and y are
read from the wiki's major.minor form, so 127.88 is 32600. label is the template's text, cleaned as the
location is, so it is the text creature.location shows in the template's place: text={{Hover|here|explanation}}
gives here. Named parameters do not count as positions, so {{Mapper Coords|text=here|127.234|127.59|14}} gives the
same row as {{Mapper Coords|127.234|127.59|14|text=here}}. A template whose x, y or z is missing, malformed or
off the game's map, x and y from 0 to 65535 and z from 0 to 15, gives no row, like Warlord Ruzad's
{{Mapper Coords|128.202,123.233,5-2|text=here}}. In creature.location, each template is replaced by its label, or
left out when it has none, so no coordinate is left in the text.
creature_max_damage
Column
Type
Description
creature_id
INTEGER
The id of the creature this max damage belongs to.
physical
INTEGER
The maximum physical damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
earth
INTEGER
The maximum earth damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
fire
INTEGER
The maximum fire damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
ice
INTEGER
The maximum ice damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
energy
INTEGER
The maximum energy damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
death
INTEGER
The maximum death damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
holy
INTEGER
The maximum holy damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
drown
INTEGER
The maximum drown damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
lifedrain
INTEGER
The maximum life drain damage dealt by the creature. If it is unknown, but the creature does deal damage, it will be -1.
manadrain
INTEGER
The maximum mana drain damage dealt by the creature. The maximum manadrain damage dealt by the creature. This is not counted as part of the total. If it is unknown, but the creature does deal damage, it will be -1.
summons
INTEGER
The maximum summons damage dealt by the creature. This is not counted as part of the total. If it is unknown, but the creature does deal damage, it will be -1.
total
INTEGER
The maximum damage the creature can deal in a single turn. In most cases, this is simply the sum of the other damages, but in some cases, the amount may be different. If it is unknown, but the creature does deal damage, it will be -1.
creature_sound
Column
Type
Description
creature_id
INTEGER
The id of the creature that does this sound.
content
TEXT
The content of the sound.
database_info
Column
Type
Description
key
TEXT / PRIMARY
The name of the value contained.
value
TEXT
The value of the property.
game_update
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this update.
title
TEXT
The title of the article containing the update.
name
TEXT
The name of the update, if any.
release_date
DATE
The date when this update was released, in ISO 8601 format.
news_id
INTEGER
The ID of the news article that announced the release.
type_primary
TEXT
The primary type of the update.
type_secondary
TEXT
The secondary type of the update.
previous
TEXT
The version before this update
next
TEXT
The version after this update
version
TEXT
The client version this update set.
summary
TEXT
A brief summary of the update.
changes
TEXT
A brief list of the changes introduced.
timestamp
TIMESTAMP
ISO8601 timestamp of the article's last edit.
house
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this house.
house_id
INTEGER
The id of the house according to tibia.com.
title
TEXT
The title of the article containing this house.
name
TEXT
The name of the house.
city
TEXT
The city the house belongs to.
street
TEXT
The street this house is located in.
location
TEXT
A brief description of the house's location.
beds
INTEGER
The maximum amount of beds the house can have.
rent
INTEGER
The monthly rent of this house.
size
INTEGER
The number of tiles this house has.
rooms
INTEGER
The number of rooms or divisions has.
floors
INTEGER
The number of floors this house has.
x
INTEGER
The x position of the house.
y
INTEGER
The y position of the house.
z
INTEGER
The z position of the house.
is_guildhall
INTEGER
Whether this house is a guildhall or not.
version
TEXT
The client version this was implemented in.
status
TEXT
The status of the house in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
imbuement
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this imbuement.
title
TEXT
The title of the article containing this imbuement.
name
TEXT
The name of the imbuement.
tier
TEXT
The imbuement’s tier: Basic, Intricate, Powerful.
type
TEXT
The imbuement’s type, e.g. Void, Frost, etc.
category
TEXT
The imbuement's category.
effect
TEXT
The effect given by this imbuement.
slots
TEXT
The item types this imbuement can be applied to.
version
TEXT
The client version this imbuement was introduced to the game.
image
BLOB
The imbuement’s image bytes.
status
TEXT
The status of the imbuement in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
imbuement_material
Column
Type
Description
imbuement_id
INTEGER
The id of the imbuement this material belongs to
item_id
INTEGER
The id of the item material.
amount
INTEGER
The amount of items needed.
item
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this item.
title
TEXT
The title of the article containing this item.
name
TEXT
The actual name of the item in-game.
actual_name
TEXT
The name of the item as it appears in game when looked at.
plural
TEXT
The plural of the item's name.
article
TEXT
The article that goes before the name when looking at the item.
is_marketable
BOOLEAN
Whether this item can be traded in the market or not.
is_stackable
BOOLEAN
Whether this item is stackable or not.
is_pickupable
BOOLEAN
Whether this item can be picked up or not.
is_immobile
BOOLEAN
Whether the item can be moved around the map or not.
is_usable
BOOLEAN
Whether the item can be used or not. NULL if unknown.
value_sell
INTEGER
The maximum value of this item when sold to NPCs
value_buy
INTEGER
The maximum price of this item when bought from NPCs, in value_buy_currency.
value_buy_currency
TEXT
The currency of value_buy: the article's pricecurrency, otherwise a currency written after the price in npcprice, otherwise Gold Coin. A linked currency gives the page it links to, like Silver Token for [[Silver Token]]s. NULL when value_buy is NULL or 0.
weight
REAL
The weight of this item in ounces.
item_class
TEXT
The class this item belongs to (e.g. Body Equipment , Weapons).
item_type
TEXT
The category this item belongs to (e.g. Helmets, Club Weapons).
type_secondary
TEXT
A secondary type this item belongs to, if any.
slot
TEXT
The slot this item goes in, in lower case (e.g. neck, weapon hand). NULL if unknown.
flavor_text
TEXT
The extra text that is displayed when some items are looked at.
light_color
INTEGER
The color of the light emitted by this item, if any.
light_radius
INTEGER
The radius of the light emitted by this item, if any.
version
TEXT
The client version this item was introduced to the game.
client_id
INTEGER
The client id of the item, the first integer in itemid. item_client_id has every client ID.
location
TEXT
Where the item can be found, cleaned as creature.location is. item_location_coordinate has its map positions.
trade_value_note
TEXT
What players trade this item for, the value as written with links and templates cleaned, like Negotiable or 55,000,000 - 70,000,000. A value that cannot be cleaned so, like 1,000 {{GP}}, drops its templates. NULL when it is ?, -- or empty.
image
BLOB
The item’s image bytes.
status
TEXT
The status of the item in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
item_attribute
Column
Type
Description
item_id
INTEGER
The id of the item this attribute belongs to.
name
TEXT
The name of the attribute.
value
TEXT
The value of the attribute.
The ranges an item restores come from the restores between A and B Hit Points, and between C and D Mana Points
sentence in its notes, as the attributes restores_hp_min, restores_hp_max, restores_mana_min and
restores_mana_max, with thousands separators removed. An item gets none of them when that sentence is missing or
ambiguous: the same unit twice, an amount over nine digits, a minimum greater than its maximum, or another between
that doesn't form a range.
item_client_id
Column
Type
Description
item_id
INTEGER
The id of the item this client ID belongs to.
client_id
INTEGER
A client ID of the item, a whole number in itemid after wiki comments are removed.
position
INTEGER
The ID's place in the itemid list, from 0.
These rows ignore wiki comments, but item.client_id keeps its earlier reading, the first integer in the raw value,
comments included. So when itemid starts with a comment holding a number, the two differ: <!-- 7 -->644,645 gives
client_id 7 and the rows 644 and 645, and <!-- 7 --> gives client_id 7 and no rows.
item_key
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this key.
title
TEXT
The title of the article containing this key.
number
INTEGER
The number of this key, without padding (e.g. Key 0555’s number would be 555).
item_id
INTEGER
The item id of the key.
name
TEXT
Name(s) this key usually receives by players.
material
TEXT
The material this key is made of.
location
TEXT
General location of this key.
origin
TEXT
How this key is obtained.
notes
TEXT
Where this key is used or other notes.
version
TEXT
The client version this key was introduced to the game.
status
TEXT
The status of the key in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
item_location_coordinate
Column
Type
Description
item_id
INTEGER
The id of the item whose location has this map position.
x
INTEGER
The x coordinate of the position.
y
INTEGER
The y coordinate of the position.
z
INTEGER
The floor of the position.
label
TEXT
The text the location shows in place of the position, like here. NULL if it shows none.
position
INTEGER
The row's place in the order the location lists its map positions, from 0.
The rows are read from the item's location as creature_location_coordinate rows are from a creature's.
item_sound
Column
Type
Description
item_id
INTEGER
The id of the item that does this sound.
content
TEXT
The content of the sound.
item_store_offer
Column
Type
Description
item_id
INTEGER
The id of the item the offer is for
price
INTEGER
The price of the item.
amount
INTEGER
The amount of the item offered.
currency
TEXT
The currency used. Most of the time Tibia Coins.
item_proficiency_perk
Column
Type
Description
item_id
INTEGER
The id of the item this perk belongs to.
proficiency_level
INTEGER
The weapon proficiency level where this perk is unlocked.
skill_image
TEXT
The name of the skill image shown for this perk.
icon
TEXT
The optional icon name used in this perk.
effect
TEXT
The effect text shown for this perk.
map
Column
Type
Description
z
INTEGER / PRIMARY
The floor’s level, where 7 is the ground floor.
image
BLOB
The map’s image for that floor, in PNG format.
mount
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this mount.
title
TEXT
The title of the article containing the mount.
name
TEXT
The name of the mount.
speed
INTEGER
The speed given by the mount.
taming_method
TEXT
A brief description on how the mount is obtained.
is_buyable
BOOLEAN
Whether the mount can be bought from the store or not.
price
INTEGER
The price to buy the mount, in price_currency.
price_currency
TEXT
The currency of the price: the article's pricecurrency, otherwise Tournament Coins for a tournament mount, otherwise Tibia Coins. NULL when there is no price.
achievement
TEXT
The achievement obtained for obtaining this mount.
light_color
INTEGER
The color of the light emitted by this mount, if any.
light_radius
INTEGER
The radius of the light emitted by this mount, if any.
client_id
INTEGER
The client ID (look type) of the mount, the first integer in the value after wiki comments are removed, NULL when there is none.
version
TEXT
The client version where this mount was introduced to the game.
image
BLOB
The mount's image bytes.
status
TEXT
The status of the mount in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
npc
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this NPC.
title
TEXT
The title of the article containing the NPC.
name
TEXT
The actual name of the NPC in-game.
gender
TEXT
The gender of the NPC in-game.
city
TEXT
City where the NPC is found.
subarea
TEXT
A finer location of the NPC.
location
TEXT
The location where the NPC is found.
version
TEXT
The client version this NPC was introduced to the game.
x
INTEGER
The x position where the NPC is usually located.
y
INTEGER
The y position where the NPC is usually located.
z
INTEGER
The z position where the NPC is usually located.
image
BLOB
The NPC's image bytes.
status
TEXT
The status of the NPC in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
npc_destination
Column
Type
Description
npc_id
INTEGER
The id of the NPC this destination belongs to.
name
TEXT
The name of the place this NPC can take you to.
price
INTEGER
The price to travel to the destination with this NPC.
notes
TEXT
Extra notes for this destination, like extra requirements or exceptions.
origin
TEXT
Where this leg starts: the place named by a From [[Place]] note. Without one, if the NPC is a shuttle, the other leg's destination, as that leg names it. An NPC is a shuttle when it has exactly two positions and exactly two destinations, and each position matches exactly one destination by city, subarea or geolabel, each destination by a different position. Otherwise the NPC's city, if the NPC has a position in it whose city, subarea and geolabel all differ from the destination. Comparisons ignore case. NULL when none of these applies.
npc_job
Column
Type
Description
npc_id
INTEGER
The id of the NPC this job is for.
name
TEXT
The name of the job.
npc_location
Column
Type
Description
npc_id
INTEGER
The id of the NPC this position belongs to.
position
INTEGER
The position's number in the wiki: 1 for the unsuffixed fields, 2 to 7 for the suffixed ones.
city
TEXT
The nearest city to this position.
subarea
TEXT
A finer location of this position.
geolabel
TEXT
A label for this position.
x
INTEGER
The x coordinate of this position, NULL if missing or malformed.
y
INTEGER
The y coordinate of this position, NULL if missing or malformed.
z
INTEGER
The z coordinate of this position, NULL if missing or malformed.
npc_offer_buy
Column
Type
Description
npc_id
INTEGER
The id of the NPC this offer belongs to
item_id
INTEGER
The id of the item this offer refers to
value
INTEGER
The value of the offer
currency_id
INTEGER
The id of the item used as currency in this offer. In most cases this is the id of gold coins.
npc_offer_sell
Column
Type
Description
npc_id
INTEGER
The id of the NPC this offer belongs to
item_id
INTEGER
The id of the item this offer refers to
value
INTEGER
The value of the offer
currency_id
INTEGER
The id of the item used as currency in this offer. In most cases this is the id of gold coins.
npc_race
Column
Type
Description
npc_id
INTEGER
The id of the NPC this race is for.
name
TEXT
The name of the race.
outfit
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this outfit.
title
TEXT
The title of the article containing the outfit.
name
TEXT
The name of the outfit.
outfit_type
TEXT
The type of outfit. Basic, Quest, Special, Premium.
is_premium
BOOLEAN
Whether this outfit is requires a premium account or not.
is_bought
BOOLEAN
Whether the outfit can be bought from the Store or not.
is_tournament
BOOLEAN
Whether the outfit can be bought with Tournament coins or not.
full_price
INTEGER
The price of the full outfit in Tibia Coins.
achievement
TEXT
The achievement obtained by getting this full outfit.
male_client_id
INTEGER
The client ID (look type) of the male outfit, the first integer in the value after wiki comments are removed, NULL when there is none.
female_client_id
INTEGER
The client ID (look type) of the female outfit, the first integer in the value after wiki comments are removed, NULL when there is none.
version
TEXT
Client version where this outfit was implemented.
status
TEXT
The status of the outfit in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
outfit_image
Column
Type
Description
outfit_id
INTEGER
Id of the outfit this image belongs to
sex
TEXT
The sex this outfit image is for.
addon
INTEGER
The addon used in the image.
image
BLOB
The outfit's image's bytes.
outfit_quest
Column
Type
Description
outfit_id
INTEGER
Id of the outfit this image belongs to
quest_id
INTEGER
Id of the quest this image belongs to
unlock_type
TEXT
Whether the quest is for the outfit or its addons.
quest
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this quest.
title
TEXT
The title of the article containing the quest.
name
TEXT
The name of the quest.
location
TEXT
Location where the quest starts or takes place.
is_rookgaard_quest
BOOLEAN
Whether this quest is in Rookgaard or not.
type
TEXT
The type of quest.
quest_log
BOOLEAN
Whether this quest is registered in the quest log or not.
legend
TEXT
Short description of the quest.
level_required
INTEGER
The level required to finish the quest.
level_recommended
INTEGER
The level recommended to finish the quest.
active_time
TEXT
Times of the year when this quest is active.
estimated_time
TEXT
Estimated time to finish this quest.
is_premium
BOOLEAN
Whether premium account is required to finish the quest.
version
TEXT
Client version where this quest was implemented.
status
TEXT
The status of the quest in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
quest_danger
Column
Type
Description
quest_id
INTEGER
Id of the quest this danger belongs to.
creature_id
INTEGER
Id of the creature found in this quest.
quest_reward
Column
Type
Description
quest_id
INTEGER
Id of the quest this reward belongs to.
item_id
INTEGER
Id of the item obtained in this quest.
rashid_position
Column
Type
Description
day
INTEGER / PRIMARY
Day of the week, where Monday is 0.
city
TEXT
Name of the city Rashid is located.
location
TEXT
Location where Rashid is that day.
x
INTEGER
The x position where Rashid is that day.
y
INTEGER
The y position where Rashid is that day.
z
INTEGER
The z position where Rashid is that day.
spell
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this spell.
title
TEXT
The title of the article containing the spell.
name
TEXT
The name of the spell.
spell_id
INTEGER
The ID of the spell, the first integer in the value after wiki comments are removed, NULL when there is none.
words
TEXT
The words used to cast the spell.
effect
TEXT
The effect of this spell.
spell_type
TEXT
Whether the spell is Instant or a Rune spell.
group_spell
TEXT
The cooldown group of this spell.
group_secondary
TEXT
The secondary cooldown group of this spell.
group_rune
TEXT
The cooldown group of the rune created by this spell.
element
TEXT
The type of damage this spell deals, if applicable.
base_power
INTEGER
The spell's base power, if applicable.
level
INTEGER
Level required to cast this spell
mana
INTEGER
Mana required to cast this spell. 0 means special conditions apply.
soul
INTEGER
Soul points required to cast this spell.
is_premium
BOOLEAN
Whether this spell requires premium account or not. 0 or 1.
is_promotion
BOOLEAN
Whether this spell requires a promotion or not. 0 or 1.
is_wheel_spell
BOOLEAN
Whether this spell is acquired through the Wheel of Destiny.
is_passive
BOOLEAN
Whether this spell is triggered automatically without casting.
cooldown
INTEGER
The individual cooldown in seconds of this spell
cooldown2
INTEGER
The spell's individual cooldown for the level 2 perk of the Wheel of Destiny.
cooldown3
INTEGER
The spell's individual cooldown for the level 3 perk of the Wheel of Destiny.
cooldown_group
INTEGER
The group cooldown of this spell.
cooldown_group_secondary
INTEGER
The secondary group cooldown of this spell.
knight
BOOLEAN
Whether this spell can be used by knights or not.
sorcerer
BOOLEAN
Whether this spell can be used by sorcerers or not.
druid
BOOLEAN
Whether this spell can be used by druids or not.
paladin
BOOLEAN
Whether this spell can be used by paladins or not.
monk
BOOLEAN
Whether the spell can be used by monks or not.
image
BLOB
The spell’s image bytes.
version
TEXT
Client version where this spell was implemented.
status
TEXT
The status of the spell in game.
timestamp
TIMESTAMP
ISO 8601 timestamp of the article's last edit.
world
Column
Type
Description
article_id
INTEGER / PRIMARY
The id of the article containing this world.
title
TEXT
The title of the article containing the world.
name
TEXT
The name of the world.
location
TEXT
The world's server's physical location.
pvp_type
TEXT
The world's PvP type.
is_preview
BOOLEAN
Whether the world is a preview world or not.
is_experimental
BOOLEAN
Whether the world is a experimental world or not.
online_since
DATE
Date when the world became online for the first time, in ISO 8601 format.
offline_since
DATE
Date when the world went offline, in ISO 8601 format.
merged_into
TEXT
The name of the world this world got merged into, if applicable.
battleye
BOOLEAN
Whether the world is BattlEye protected or not.
battleye_type
TEXT
The type of battleye protection the world has (yellow or green).
protected_since
DATE
Date when the world started being protected by BattlEye, in ISO 8601 format.