vmt.tail7e5fd1.ts.net / 127.0.0.1 / rathena_db / item_db2_re

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Internal relationships

Column	Internal relation
id
name_aegis
name_english
type
subtype
price_buy
price_sell
weight
attack
magic_attack
defense
range
slots
job_all
job_acolyte
job_alchemist
job_archer
job_assassin
job_barddancer
job_blacksmith
job_crusader
job_gunslinger
job_hunter
job_kagerouoboro
job_knight
job_mage
job_merchant
job_monk
job_ninja
job_novice
job_priest
job_rebellion
job_rogue
job_sage
job_soullinker
job_spirit_handler
job_stargladiator
job_summoner
job_supernovice
job_swordman
job_taekwon
job_thief
job_wizard
class_all
class_normal
class_upper
class_baby
class_third
class_third_upper
class_third_baby
class_fourth
gender
location_head_top
location_head_mid
location_head_low
location_armor
location_right_hand
location_left_hand
location_garment
location_shoes
location_right_accessory
location_left_accessory
location_costume_head_top
location_costume_head_mid
location_costume_head_low
location_costume_garment
location_ammo
location_shadow_armor
location_shadow_weapon
location_shadow_shield
location_shadow_shoes
location_shadow_right_accessory
location_shadow_left_accessory
weapon_level
armor_level
equip_level_min
equip_level_max
refineable
gradable
view
alias_name
flag_buyingstore
flag_deadbranch
flag_container
flag_uniqueid
flag_bindonequip
flag_dropannounce
flag_noconsume
flag_dropeffect
delay_duration
delay_status
stack_amount
stack_inventory
stack_cart
stack_storage
stack_guildstorage
nouse_override
nouse_sitting
trade_override
trade_nodrop
trade_notrade
trade_tradepartner
trade_nosell
trade_nocart
trade_nostorage
trade_noguildstorage
trade_nomail
trade_noauction
script
equip_script
unequip_script

Choose column to display: