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