pokedex/db/tables.py

   1 # encoding: utf8
   2
   3 from sqlalchemy import Column, ForeignKey, MetaData, Table
   4 from sqlalchemy.ext.declarative import declarative_base
   5 from sqlalchemy.ext.associationproxy import association_proxy
   6 from sqlalchemy.orm import backref, relation
   7 from sqlalchemy.types import *
   8 from sqlalchemy.databases.mysql import *
   9
  10 from pokedex.db import rst
  11
  12 metadata = MetaData()
  13 TableBase = declarative_base(metadata=metadata)
  14
  15 class Ability(TableBase):
  16     __tablename__ = 'abilities'
  17     __singlename__ = 'ability'
  18     id = Column(Integer, primary_key=True, nullable=False)
  19     name = Column(Unicode(24), nullable=False)
  20     flavor_text = Column(Unicode(64), nullable=False)
  21     effect = Column(Unicode(255), nullable=False)
  22
  23 class ContestEffect(TableBase):
  24     __tablename__ = 'contest_effects'
  25     id = Column(Integer, primary_key=True, nullable=False)
  26     appeal = Column(SmallInteger, nullable=False)
  27     jam = Column(SmallInteger, nullable=False)
  28     flavor_text = Column(Unicode(64), nullable=False)
  29     effect = Column(Unicode(255), nullable=False)
  30
  31 class EggGroup(TableBase):
  32     __tablename__ = 'egg_groups'
  33     id = Column(Integer, primary_key=True, nullable=False)
  34     name = Column(Unicode(16), nullable=False)
  35
  36 class Encounter(TableBase):
  37     """Rows in this table represent encounters with wild Pokémon.
  38
  39     Within a given area in a given game, encounters are differentiated by the
  40     slot they are in and a world condition.
  41
  42     Groups of slots belong to encounter types; these are what the player is
  43     doing to get an encounter, such as surfing or walking through tall grass.
  44
  45     Within an encounter type, slots are defined primarily by rarity.  Each slot
  46     can also be affected by a world condition; for example, the 20% slot for
  47     walking in tall grass is affected by whether a swarm is in effect in the
  48     areas.  "There is a swarm" and "there is not a swarm" are conditions, and
  49     together they make a condition group.  However, since "not a swarm" is a
  50     base state rather than any sort of new state, it is omitted and instead
  51     referred to by a NULL.
  52
  53     A slot (20% walking in grass) and single world condition (NULL, i.e. no
  54     swarm) are thus enough to define a specific encounter.
  55
  56     Well, okay, almost: each slot actually appears twice.
  57     """
  58
  59     __tablename__ = 'encounters'
  60     id = Column(Integer, primary_key=True, nullable=False)
  61     version_id = Column(Integer, ForeignKey('versions.id'), nullable=False, autoincrement=False)
  62     location_area_id = Column(Integer, ForeignKey('location_areas.id'), nullable=False, autoincrement=False)
  63     encounter_type_slot_id = Column(Integer, ForeignKey('encounter_type_slots.id'), nullable=False, autoincrement=False)
  64     encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), nullable=True, autoincrement=False)
  65     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False, autoincrement=False)
  66     min_level = Column(Integer, nullable=False, autoincrement=False)
  67     max_level = Column(Integer, nullable=False, autoincrement=False)
  68
  69 class EncounterCondition(TableBase):
  70     """Rows in this table represent something different about the world that
  71     can affect what Pokémon are encountered.
  72     """
  73
  74     __tablename__ = 'encounter_conditions'
  75     id = Column(Integer, primary_key=True, nullable=False)
  76     encounter_condition_group_id = Column(Integer, ForeignKey('encounter_condition_groups.id'), primary_key=False, nullable=False, autoincrement=False)
  77     name = Column(Unicode(64), nullable=False)
  78
  79 class EncounterConditionGroup(TableBase):
  80     """Rows in this table represent a group of mutually exclusive conditions,
  81     such as morning/day/night.  "Conditions" that are part of the default state
  82     of the world, such as "not during a swarm" or "not using the PokéRadar",
  83     are not included in this table and are referred to by NULLs in other
  84     tables.
  85     """
  86
  87     __tablename__ = 'encounter_condition_groups'
  88     id = Column(Integer, primary_key=True, nullable=False)
  89     name = Column(Unicode(64), nullable=False)
  90
  91 class EncounterType(TableBase):
  92     """Rows in this table represent ways the player can enter a wild encounter;
  93     i.e. surfing, fishing, or walking through tall grass.
  94     """
  95
  96     __tablename__ = 'encounter_types'
  97     id = Column(Integer, primary_key=True, nullable=False)
  98     name = Column(Unicode(64), nullable=False)
  99
 100 class EncounterTypeSlot(TableBase):
 101     """Rows in this table represent an abstract "slot" within an encounter
 102     type, associated with both a condition group and a rarity.
 103
 104     Note that there are two encounters per slot, so the rarities will only add
 105     up to 50.
 106     """
 107
 108     __tablename__ = 'encounter_type_slots'
 109     id = Column(Integer, primary_key=True, nullable=False)
 110     encounter_type_id = Column(Integer, ForeignKey('encounter_types.id'), primary_key=False, nullable=False, autoincrement=False)
 111     encounter_condition_group_id = Column(Integer, ForeignKey('encounter_condition_groups.id'), primary_key=False, nullable=True, autoincrement=False)
 112     rarity = Column(Integer, nullable=False, autoincrement=False)
 113
 114 class EvolutionChain(TableBase):
 115     __tablename__ = 'evolution_chains'
 116     id = Column(Integer, primary_key=True, nullable=False)
 117     growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), nullable=False)
 118     steps_to_hatch = Column(Integer, nullable=False)
 119     baby_trigger_item = Column(Unicode(12))
 120
 121 class EvolutionMethod(TableBase):
 122     __tablename__ = 'evolution_methods'
 123     id = Column(Integer, primary_key=True, nullable=False)
 124     name = Column(Unicode(64), nullable=False)
 125     description = Column(Unicode(255), nullable=False)
 126
 127 class Generation(TableBase):
 128     __tablename__ = 'generations'
 129     id = Column(Integer, primary_key=True, nullable=False)
 130     name = Column(Unicode(16), nullable=False)
 131     main_region = Column(Unicode(16), nullable=False)
 132
 133 class GrowthRate(TableBase):
 134     """`formula` is written in LaTeX math notation."""
 135     __tablename__ = 'growth_rates'
 136     id = Column(Integer, primary_key=True, nullable=False)
 137     name = Column(Unicode(20), nullable=False)
 138     formula = Column(Unicode(500), nullable=False)
 139
 140 class Item(TableBase):
 141     __tablename__ = 'items'
 142     __singlename__ = 'item'
 143     id = Column(Integer, primary_key=True, nullable=False)
 144     name = Column(Unicode(16), nullable=False)
 145
 146 class Language(TableBase):
 147     __tablename__ = 'languages'
 148     id = Column(Integer, primary_key=True, nullable=False)
 149     name = Column(Unicode(16), nullable=False)
 150
 151 class Location(TableBase):
 152     __tablename__ = 'locations'
 153     __singlename__ = 'location'
 154     id = Column(Integer, primary_key=True, nullable=False)
 155     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 156     name = Column(Unicode(64), nullable=False)
 157
 158 class LocationArea(TableBase):
 159     __tablename__ = 'location_areas'
 160     id = Column(Integer, primary_key=True, nullable=False)
 161     location_id = Column(Integer, ForeignKey('locations.id'), nullable=False)
 162     internal_id = Column(Integer, nullable=False)
 163     name = Column(Unicode(64), nullable=True)
 164
 165 class LocationAreaEncounterRate(TableBase):
 166     __tablename__ = 'location_area_encounter_rates'
 167     location_area_id = Column(Integer, ForeignKey('location_areas.id'), primary_key=True, nullable=False, autoincrement=False)
 168     encounter_type_id = Column(Integer, ForeignKey('encounter_types.id'), primary_key=True, nullable=False, autoincrement=False)
 169     rate = Column(Integer, nullable=True)
 170
 171 class Machine(TableBase):
 172     __tablename__ = 'machines'
 173     machine_number = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 174     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 175     move_id = Column(Integer, ForeignKey('moves.id'), nullable=False)
 176
 177 class MoveDamageClass(TableBase):
 178     __tablename__ = 'move_damage_classes'
 179     id = Column(Integer, primary_key=True, nullable=False)
 180     name = Column(Unicode(8), nullable=False)
 181     description = Column(Unicode(64), nullable=False)
 182
 183 class MoveEffect(TableBase):
 184     __tablename__ = 'move_effects'
 185     id = Column(Integer, primary_key=True, nullable=False)
 186     priority = Column(SmallInteger, nullable=False)
 187     short_effect = Column(Unicode(256), nullable=False)
 188     effect = Column(Unicode(5120), nullable=False)
 189
 190 class MoveFlag(TableBase):
 191     __tablename__ = 'move_flags'
 192     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 193     move_flag_type_id = Column(Integer, ForeignKey('move_flag_types.id'), primary_key=True, nullable=False, autoincrement=False)
 194
 195 class MoveFlagType(TableBase):
 196     __tablename__ = 'move_flag_types'
 197     id = Column(Integer, primary_key=True, nullable=False)
 198     name = Column(Unicode(32), nullable=False)
 199     description = Column(rst.RstTextColumn(128), nullable=False)
 200
 201 class MoveFlavorText(TableBase):
 202     __tablename__ = 'move_flavor_text'
 203     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 204     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 205     flavor_text = Column(Unicode(255), nullable=False)
 206
 207 class MoveName(TableBase):
 208     __tablename__ = 'move_names'
 209     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 210     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 211     name = Column(Unicode(16), nullable=False)
 212
 213 class MoveTarget(TableBase):
 214     __tablename__ = 'move_targets'
 215     id = Column(Integer, primary_key=True, nullable=False)
 216     name = Column(Unicode(32), nullable=False)
 217     description = Column(Unicode(128), nullable=False)
 218
 219 class Move(TableBase):
 220     __tablename__ = 'moves'
 221     __singlename__ = 'move'
 222     id = Column(Integer, primary_key=True, nullable=False)
 223     name = Column(Unicode(12), nullable=False)
 224     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 225     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 226     power = Column(SmallInteger)
 227     pp = Column(SmallInteger, nullable=False)
 228     accuracy = Column(SmallInteger)
 229     target_id = Column(Integer, ForeignKey('move_targets.id'), nullable=False)
 230     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False)
 231     effect_id = Column(Integer, ForeignKey('move_effects.id'), nullable=False)
 232     effect_chance = Column(Integer)
 233     contest_type = Column(Unicode(8), nullable=False)
 234     contest_effect_id = Column(Integer, ForeignKey('contest_effects.id'), nullable=True)
 235     super_contest_effect_id = Column(Integer, ForeignKey('super_contest_effects.id'), nullable=False)
 236
 237 class Pokemon(TableBase):
 238     """The core to this whole mess.
 239
 240     Note that I use both 'forme' and 'form' in both code and the database.  I
 241     only use 'forme' when specifically referring to Pokémon that have multiple
 242     distinct species as forms—i.e., different stats or movesets.  'Form' is a
 243     more general term referring to any variation within a species, including
 244     purely cosmetic forms like Unown.
 245     """
 246     __tablename__ = 'pokemon'
 247     __singlename__ = 'pokemon'
 248     id = Column(Integer, primary_key=True, nullable=False)
 249     name = Column(Unicode(20), nullable=False)
 250     forme_name = Column(Unicode(16))
 251     forme_base_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
 252     generation_id = Column(Integer, ForeignKey('generations.id'))
 253     evolution_chain_id = Column(Integer, ForeignKey('evolution_chains.id'))
 254     evolution_parent_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
 255     evolution_method_id = Column(Integer, ForeignKey('evolution_methods.id'))
 256     evolution_parameter = Column(Unicode(32))
 257     height = Column(Integer, nullable=False)
 258     weight = Column(Integer, nullable=False)
 259     species = Column(Unicode(16), nullable=False)
 260     color = Column(Unicode(6), nullable=False)
 261     pokemon_shape_id = Column(Integer, ForeignKey('pokemon_shapes.id'), nullable=False)
 262     habitat = Column(Unicode(16), nullable=False)
 263     gender_rate = Column(Integer, nullable=False)
 264     capture_rate = Column(Integer, nullable=False)
 265     base_experience = Column(Integer, nullable=False)
 266     base_happiness = Column(Integer, nullable=False)
 267     gen1_internal_id = Column(Integer)
 268     is_baby = Column(Boolean, nullable=False)
 269     has_gen4_fem_sprite = Column(Boolean, nullable=False)
 270     has_gen4_fem_back_sprite = Column(Boolean, nullable=False)
 271
 272     ### Stuff to handle alternate Pokémon forms
 273
 274     @property
 275     def national_id(self):
 276         """Returns the National Pokédex number for this Pokémon.  Use this
 277         instead of the id directly; alternate formes may make the id incorrect.
 278         """
 279
 280         if self.forme_base_pokemon_id:
 281             return self.forme_base_pokemon_id
 282         return self.id
 283
 284     @property
 285     def full_name(self):
 286         """Returns the name of this Pokémon, including its Forme, if any."""
 287
 288         if self.forme_name:
 289             return "%s %s" % (self.forme_name.capitalize(), self.name)
 290         return self.name
 291
 292     @property
 293     def normal_form(self):
 294         """Returns the normal form for this Pokémon; i.e., this will return
 295         regular Deoxys when called on any Deoxys form.
 296         """
 297
 298         if self.forme_base_pokemon:
 299             return self.forme_base_pokemon
 300
 301         return self
 302
 303 class PokemonAbility(TableBase):
 304     __tablename__ = 'pokemon_abilities'
 305     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 306     ability_id = Column(Integer, ForeignKey('abilities.id'), nullable=False)
 307     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 308
 309 class PokemonDexNumber(TableBase):
 310     __tablename__ = 'pokemon_dex_numbers'
 311     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 312     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 313     pokedex_number = Column(Integer, nullable=False)
 314
 315 class PokemonEggGroup(TableBase):
 316     __tablename__ = 'pokemon_egg_groups'
 317     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 318     egg_group_id = Column(Integer, ForeignKey('egg_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 319
 320 class PokemonFlavorText(TableBase):
 321     __tablename__ = 'pokemon_flavor_text'
 322     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 323     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 324     flavor_text = Column(Unicode(255), nullable=False)
 325
 326 class PokemonFormGroup(TableBase):
 327     __tablename__ = 'pokemon_form_groups'
 328     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 329     description = Column(Unicode(512), nullable=False)
 330
 331 class PokemonFormSprite(TableBase):
 332     __tablename__ = 'pokemon_form_sprites'
 333     id = Column(Integer, primary_key=True, nullable=False)
 334     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 335     name = Column(Unicode(16), nullable=True)
 336
 337 class PokemonItem(TableBase):
 338     __tablename__ = 'pokemon_items'
 339     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 340     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 341     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
 342     rarity = Column(Integer, nullable=False)
 343
 344 class PokemonMove(TableBase):
 345     __tablename__ = 'pokemon_moves'
 346     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 347     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 348     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
 349     pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
 350     level = Column(Integer, primary_key=True, nullable=True, autoincrement=False)
 351     order = Column(Integer, nullable=True)
 352
 353 class PokemonMoveMethod(TableBase):
 354     __tablename__ = 'pokemon_move_methods'
 355     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 356     name = Column(Unicode(64), nullable=False)
 357     description = Column(Unicode(255), nullable=False)
 358
 359 class PokemonName(TableBase):
 360     __tablename__ = 'pokemon_names'
 361     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 362     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 363     name = Column(Unicode(16), nullable=False)
 364
 365 class PokemonShape(TableBase):
 366     __tablename__ = 'pokemon_shapes'
 367     id = Column(Integer, primary_key=True, nullable=False)
 368     name = Column(Unicode(24), nullable=False)
 369     awesome_name = Column(Unicode(16), nullable=False)
 370
 371 class PokemonStat(TableBase):
 372     __tablename__ = 'pokemon_stats'
 373     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 374     stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
 375     base_stat = Column(Integer, nullable=False)
 376     effort = Column(Integer, nullable=False)
 377
 378 class PokemonType(TableBase):
 379     __tablename__ = 'pokemon_types'
 380     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 381     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 382     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 383
 384 class Stat(TableBase):
 385     __tablename__ = 'stats'
 386     id = Column(Integer, primary_key=True, nullable=False)
 387     name = Column(Unicode(16), nullable=False)
 388
 389 class SuperContestEffect(TableBase):
 390     __tablename__ = 'super_contest_effects'
 391     id = Column(Integer, primary_key=True, nullable=False)
 392     appeal = Column(SmallInteger, nullable=False)
 393     flavor_text = Column(Unicode(64), nullable=False)
 394
 395 class TypeEfficacy(TableBase):
 396     __tablename__ = 'type_efficacy'
 397     damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 398     target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 399     damage_factor = Column(Integer, nullable=False)
 400
 401 class Type(TableBase):
 402     __tablename__ = 'types'
 403     __singlename__ = 'type'
 404     id = Column(Integer, primary_key=True, nullable=False)
 405     name = Column(Unicode(8), nullable=False)
 406     abbreviation = Column(Unicode(3), nullable=False)
 407
 408 class VersionGroup(TableBase):
 409     __tablename__ = 'version_groups'
 410     id = Column(Integer, primary_key=True, nullable=False)
 411     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 412
 413 class Version(TableBase):
 414     __tablename__ = 'versions'
 415     id = Column(Integer, primary_key=True, nullable=False)
 416     version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
 417     name = Column(Unicode(32), nullable=False)
 418
 419
 420 ### Relations down here, to avoid ordering problems
 421 Encounter.pokemon = relation(Pokemon, backref='encounters')
 422 Encounter.version = relation(Version, backref='encounters')
 423 Encounter.location_area = relation(LocationArea, backref='encounters')
 424 Encounter.slot = relation(EncounterTypeSlot, backref='encounters')
 425 Encounter.condition = relation(EncounterCondition, backref='encounters')
 426
 427 EncounterCondition.group = relation(EncounterConditionGroup,
 428                                     backref='conditions')
 429
 430 EncounterTypeSlot.type = relation(EncounterType, backref='slots')
 431
 432 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
 433
 434 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
 435
 436 LocationArea.location = relation(Location, backref='areas')
 437
 438 Machine.generation = relation(Generation)
 439
 440 Move.contest_effect = relation(ContestEffect, backref='moves')
 441 Move.damage_class = relation(MoveDamageClass, backref='moves')
 442 Move.flags = association_proxy('move_flags', 'flag')
 443 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.generation_id, backref='move')
 444 Move.foreign_names = relation(MoveName, backref='pokemon')
 445 Move.generation = relation(Generation, backref='moves')
 446 Move.machines = relation(Machine, backref='move')
 447 Move.move_effect = relation(MoveEffect, backref='moves')
 448 Move.move_flags = relation(MoveFlag, backref='move')
 449 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
 450 Move.target = relation(MoveTarget, backref='moves')
 451 Move.type = relation(Type, backref='moves')
 452
 453 Move.effect = rst.MoveEffectProperty('effect')
 454 Move.priority = association_proxy('move_effect', 'priority')
 455 Move.short_effect = rst.MoveEffectProperty('short_effect')
 456
 457 MoveFlag.flag = relation(MoveFlagType)
 458
 459 MoveFlavorText.generation = relation(Generation)
 460
 461 MoveName.language = relation(Language)
 462
 463 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
 464                                       order_by=PokemonAbility.slot,
 465                                       backref='pokemon')
 466 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
 467                                                backref=backref('forme_base_pokemon',
 468                                                                remote_side=[Pokemon.id]))
 469 Pokemon.dex_numbers = relation(PokemonDexNumber, backref='pokemon')
 470 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
 471                                         order_by=PokemonEggGroup.egg_group_id,
 472                                         backref='pokemon')
 473 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
 474 Pokemon.evolution_method = relation(EvolutionMethod)
 475 Pokemon.evolution_children = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.evolution_parent_pokemon_id,
 476                                                backref=backref('evolution_parent',
 477                                                                remote_side=[Pokemon.id]))
 478 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.pokemon_id, backref='pokemon')
 479 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
 480 Pokemon.items = relation(PokemonItem)
 481 Pokemon.generation = relation(Generation, backref='pokemon')
 482 Pokemon.shape = relation(PokemonShape, backref='pokemon')
 483 Pokemon.stats = relation(PokemonStat, backref='pokemon')
 484 Pokemon.types = relation(Type, secondary=PokemonType.__table__)
 485
 486 PokemonDexNumber.generation = relation(Generation)
 487
 488 PokemonFlavorText.version = relation(Version)
 489
 490 PokemonItem.item = relation(Item, backref='pokemon')
 491 PokemonItem.version = relation(Version)
 492
 493 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
 494                                                              uselist=False))
 495 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
 496
 497 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
 498 PokemonMove.version_group = relation(VersionGroup)
 499 PokemonMove.move = relation(Move, backref='pokemon_moves')
 500 PokemonMove.method = relation(PokemonMoveMethod)
 501
 502 PokemonName.language = relation(Language)
 503
 504 PokemonStat.stat = relation(Stat)
 505
 506 Type.damage_efficacies = relation(TypeEfficacy,
 507                                   primaryjoin=Type.id
 508                                       ==TypeEfficacy.damage_type_id,
 509                                   backref='damage_type')
 510 Type.target_efficacies = relation(TypeEfficacy,
 511                                   primaryjoin=Type.id
 512                                       ==TypeEfficacy.target_type_id,
 513                                   backref='target_type')
 514
 515 Version.version_group = relation(VersionGroup, backref='versions')
 516 Version.generation = association_proxy('version_group', 'generation')
 517
 518 VersionGroup.generation = relation(Generation, backref='version_groups')