Items - Tables - Docs - PokeDB: The Ultimate Pokémon Database

Items

Item Categories

Item Distributions

Item Evolutions

Item Flavor Texts

Item Fling Effects

Item Names

Item Pockets

Item Pocket Maps

Item Prices

Item Spin Off Datas

Item Sprites

Item Stat Modifiers

Items Schema Diagram

Item

PK

identifier

string

name

string

item_category_identifier

string

introduced_in_generation_id

number

is_consumable

boolean

is_holdable

boolean

is_battle_usable

boolean

is_field_usable

boolean

description

string

notes

string

default_item_sprite

string

default_item_sprite_small

string

Item Category

PK

identifier

string

name

string

Generation

PK

id

number

name

string

Item Distribution

item_identifier

string

event_name

string

distribution_method

string

start_date

string

end_date

string

region

string

version_identifiers

json

notes

string

Version

PK

id

number

identifier

string

badge_info

json

generation_id

number

name

string

Item Evolution

item_identifier

string

evolves_from_pokemon_form_identifier

string

evolves_to_pokemon_form_identifier

string

conditions

string

Pokémon Form

PK

id

number

ndex_id

number

identifier

string

form_name

string

type_1_id

number

type_2_id

number

pokemon_category

string

shape_id

number

footprint_path

string

pokedex_color_id

number

height_m

string

height_ft

string

weight_kg

string

weight_lbs

string

ability_primary_id

number

ability_secondary_id

number

ability_hidden_id

number

ev_yield_hp

number

ev_yield_atk

number

ev_yield_def

number

ev_yield_spatk

number

ev_yield_spdef

number

ev_yield_speed

number

main_image_normal_path

string

main_image_normal_path_small

string

main_image_normal_path_preview

string

main_image_normal_path_medium

string

main_image_shiny_path

string

main_image_shiny_path_small

string

pokemon_cry_path

string

stat_hp

number

stat_attack

number

stat_defense

number

stat_spatk

number

stat_spdef

number

stat_speed

number

stat_total

number

base_experience

number

is_default_form

boolean

include

boolean

type_weakness_chart_id

number

is_first_partner

boolean

is_baby

boolean

is_mega_evolution

boolean

is_gmax_form

boolean

is_legendary

boolean

is_mythical

boolean

is_ultrabeast

boolean

is_paradox

boolean

is_fossil

boolean

origin_region_identifier

string

Item Flavor Text

item_identifier

string

version_identifier

string

flavor_text

string

Item Fling Effect

item_identifier

string

fling_power

number

fling_effect

string

Item Name

item_identifier

string

language_identifier

string

localized_name

string

notes

string

Language

PK

identifier

string

language_code

string

display_name

string

shorthand

string

native_name

string

romanized_language_identifier

string

is_romanization_language

boolean

flag_image_path

string

Item Pocket

PK

identifier

string

name

string

icon_path

string

Item Pocket Map

item_identifier

string

generation_id

number

item_pocket_identifier

string

applies_to_version_identifier

string

Generation

PK

id

number

name

string

Item Price

item_identifier

string

version_identifier

string

price_type

string

amount

string

pokemon_currency_identifier

string

notes

string

Version

PK

id

number

identifier

string

badge_info

json

generation_id

number

name

string

Pokémon Currency

PK

identifier

string

name

string

shorthand

string

icon_path

string

Item Spin Off Data

item_identifier

string

spin_off_game

string

effect_description

string

acquisition_method

string

notes

string

Item Sprite

item_identifier

string

image_path

string

image_path_small

string

version_identifier

string

Item Stat Modifier

item_identifier

string

stat

string

amount

string

generation_id_start

number

generation_id_end

number