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     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 180     move_id = Column(Integer, ForeignKey('moves.id'), nullable=False)
 181
 182 class MoveDamageClass(TableBase):
 183     __tablename__ = 'move_damage_classes'
 184     id = Column(Integer, primary_key=True, nullable=False)
 185     name = Column(Unicode(8), nullable=False)
 186     description = Column(Unicode(64), nullable=False)
 187
 188 class MoveEffect(TableBase):
 189     __tablename__ = 'move_effects'
 190     id = Column(Integer, primary_key=True, nullable=False)
 191     priority = Column(SmallInteger, nullable=False)
 192     short_effect = Column(Unicode(256), nullable=False)
 193     effect = Column(Unicode(5120), nullable=False)
 194
 195 class MoveFlag(TableBase):
 196     __tablename__ = 'move_flags'
 197     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 198     move_flag_type_id = Column(Integer, ForeignKey('move_flag_types.id'), primary_key=True, nullable=False, autoincrement=False)
 199
 200 class MoveFlagType(TableBase):
 201     __tablename__ = 'move_flag_types'
 202     id = Column(Integer, primary_key=True, nullable=False)
 203     name = Column(Unicode(32), nullable=False)
 204     description = Column(rst.RstTextColumn(128), nullable=False)
 205
 206 class MoveFlavorText(TableBase):
 207     __tablename__ = 'move_flavor_text'
 208     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 209     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 210     flavor_text = Column(Unicode(255), nullable=False)
 211
 212 class MoveName(TableBase):
 213     __tablename__ = 'move_names'
 214     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 215     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 216     name = Column(Unicode(16), nullable=False)
 217
 218 class MoveTarget(TableBase):
 219     __tablename__ = 'move_targets'
 220     id = Column(Integer, primary_key=True, nullable=False)
 221     name = Column(Unicode(32), nullable=False)
 222     description = Column(Unicode(128), nullable=False)
 223
 224 class Move(TableBase):
 225     __tablename__ = 'moves'
 226     __singlename__ = 'move'
 227     id = Column(Integer, primary_key=True, nullable=False)
 228     name = Column(Unicode(12), nullable=False)
 229     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 230     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 231     power = Column(SmallInteger)
 232     pp = Column(SmallInteger, nullable=False)
 233     accuracy = Column(SmallInteger)
 234     target_id = Column(Integer, ForeignKey('move_targets.id'), nullable=False)
 235     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False)
 236     effect_id = Column(Integer, ForeignKey('move_effects.id'), nullable=False)
 237     effect_chance = Column(Integer)
 238     contest_type = Column(Unicode(8), nullable=False)
 239     contest_effect_id = Column(Integer, ForeignKey('contest_effects.id'), nullable=True)
 240     super_contest_effect_id = Column(Integer, ForeignKey('super_contest_effects.id'), nullable=False)
 241
 242 class Pokemon(TableBase):
 243     """The core to this whole mess.
 244
 245     Note that I use both 'forme' and 'form' in both code and the database.  I
 246     only use 'forme' when specifically referring to Pokémon that have multiple
 247     distinct species as forms—i.e., different stats or movesets.  'Form' is a
 248     more general term referring to any variation within a species, including
 249     purely cosmetic forms like Unown.
 250     """
 251     __tablename__ = 'pokemon'
 252     __singlename__ = 'pokemon'
 253     id = Column(Integer, primary_key=True, nullable=False)
 254     name = Column(Unicode(20), nullable=False)
 255     forme_name = Column(Unicode(16))
 256     forme_base_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
 257     generation_id = Column(Integer, ForeignKey('generations.id'))
 258     evolution_chain_id = Column(Integer, ForeignKey('evolution_chains.id'))
 259     evolution_parent_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
 260     evolution_method_id = Column(Integer, ForeignKey('evolution_methods.id'))
 261     evolution_parameter = Column(Unicode(32))
 262     height = Column(Integer, nullable=False)
 263     weight = Column(Integer, nullable=False)
 264     species = Column(Unicode(16), nullable=False)
 265     color = Column(Unicode(6), nullable=False)
 266     pokemon_shape_id = Column(Integer, ForeignKey('pokemon_shapes.id'), nullable=False)
 267     habitat = Column(Unicode(16), nullable=False)
 268     gender_rate = Column(Integer, nullable=False)
 269     capture_rate = Column(Integer, nullable=False)
 270     base_experience = Column(Integer, nullable=False)
 271     base_happiness = Column(Integer, nullable=False)
 272     gen1_internal_id = Column(Integer)
 273     is_baby = Column(Boolean, nullable=False)
 274     has_gen4_fem_sprite = Column(Boolean, nullable=False)
 275     has_gen4_fem_back_sprite = Column(Boolean, nullable=False)
 276
 277     ### Stuff to handle alternate Pokémon forms
 278
 279     @property
 280     def national_id(self):
 281         """Returns the National Pokédex number for this Pokémon.  Use this
 282         instead of the id directly; alternate formes may make the id incorrect.
 283         """
 284
 285         if self.forme_base_pokemon_id:
 286             return self.forme_base_pokemon_id
 287         return self.id
 288
 289     @property
 290     def full_name(self):
 291         """Returns the name of this Pokémon, including its Forme, if any."""
 292
 293         if self.forme_name:
 294             return "%s %s" % (self.forme_name.capitalize(), self.name)
 295         return self.name
 296
 297     @property
 298     def normal_form(self):
 299         """Returns the normal form for this Pokémon; i.e., this will return
 300         regular Deoxys when called on any Deoxys form.
 301         """
 302
 303         if self.forme_base_pokemon:
 304             return self.forme_base_pokemon
 305
 306         return self
 307
 308 class PokemonAbility(TableBase):
 309     __tablename__ = 'pokemon_abilities'
 310     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 311     ability_id = Column(Integer, ForeignKey('abilities.id'), nullable=False)
 312     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 313
 314 class PokemonDexNumber(TableBase):
 315     __tablename__ = 'pokemon_dex_numbers'
 316     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 317     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, nullable=False, autoincrement=False)
 318     pokedex_number = Column(Integer, nullable=False)
 319
 320 class PokemonEggGroup(TableBase):
 321     __tablename__ = 'pokemon_egg_groups'
 322     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 323     egg_group_id = Column(Integer, ForeignKey('egg_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 324
 325 class PokemonFlavorText(TableBase):
 326     __tablename__ = 'pokemon_flavor_text'
 327     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 328     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 329     flavor_text = Column(Unicode(255), nullable=False)
 330
 331 class PokemonFormGroup(TableBase):
 332     __tablename__ = 'pokemon_form_groups'
 333     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 334     description = Column(Unicode(512), nullable=False)
 335
 336 class PokemonFormSprite(TableBase):
 337     __tablename__ = 'pokemon_form_sprites'
 338     id = Column(Integer, primary_key=True, nullable=False)
 339     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 340     introduced_in_version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 341     name = Column(Unicode(16), nullable=True)
 342
 343 class PokemonItem(TableBase):
 344     __tablename__ = 'pokemon_items'
 345     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 346     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 347     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
 348     rarity = Column(Integer, nullable=False)
 349
 350 class PokemonMove(TableBase):
 351     __tablename__ = 'pokemon_moves'
 352     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 353     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 354     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
 355     pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
 356     level = Column(Integer, primary_key=True, nullable=True, autoincrement=False)
 357     order = Column(Integer, nullable=True)
 358
 359 class PokemonMoveMethod(TableBase):
 360     __tablename__ = 'pokemon_move_methods'
 361     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 362     name = Column(Unicode(64), nullable=False)
 363     description = Column(Unicode(255), nullable=False)
 364
 365 class PokemonName(TableBase):
 366     __tablename__ = 'pokemon_names'
 367     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 368     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 369     name = Column(Unicode(16), nullable=False)
 370
 371 class PokemonShape(TableBase):
 372     __tablename__ = 'pokemon_shapes'
 373     id = Column(Integer, primary_key=True, nullable=False)
 374     name = Column(Unicode(24), nullable=False)
 375     awesome_name = Column(Unicode(16), nullable=False)
 376
 377 class PokemonStat(TableBase):
 378     __tablename__ = 'pokemon_stats'
 379     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 380     stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
 381     base_stat = Column(Integer, nullable=False)
 382     effort = Column(Integer, nullable=False)
 383
 384 class PokemonType(TableBase):
 385     __tablename__ = 'pokemon_types'
 386     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 387     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 388     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 389
 390 class Stat(TableBase):
 391     __tablename__ = 'stats'
 392     id = Column(Integer, primary_key=True, nullable=False)
 393     name = Column(Unicode(16), nullable=False)
 394
 395 class SuperContestCombo(TableBase):
 396     __tablename__ = 'super_contest_combos'
 397     first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 398     second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 399
 400 class SuperContestEffect(TableBase):
 401     __tablename__ = 'super_contest_effects'
 402     id = Column(Integer, primary_key=True, nullable=False)
 403     appeal = Column(SmallInteger, nullable=False)
 404     flavor_text = Column(Unicode(64), nullable=False)
 405
 406 class TypeEfficacy(TableBase):
 407     __tablename__ = 'type_efficacy'
 408     damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 409     target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 410     damage_factor = Column(Integer, nullable=False)
 411
 412 class Type(TableBase):
 413     __tablename__ = 'types'
 414     __singlename__ = 'type'
 415     id = Column(Integer, primary_key=True, nullable=False)
 416     name = Column(Unicode(8), nullable=False)
 417     abbreviation = Column(Unicode(3), nullable=False)
 418
 419 class VersionGroup(TableBase):
 420     __tablename__ = 'version_groups'
 421     id = Column(Integer, primary_key=True, nullable=False)
 422     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 423
 424 class Version(TableBase):
 425     __tablename__ = 'versions'
 426     id = Column(Integer, primary_key=True, nullable=False)
 427     version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
 428     name = Column(Unicode(32), nullable=False)
 429
 430
 431 ### Relations down here, to avoid ordering problems
 432 ContestCombo.first = relation(Move, primaryjoin=ContestCombo.first_move_id==Move.id,
 433                                     backref='contest_combo_first')
 434 ContestCombo.second = relation(Move, primaryjoin=ContestCombo.second_move_id==Move.id,
 435                                      backref='contest_combo_second')
 436
 437 Encounter.pokemon = relation(Pokemon, backref='encounters')
 438 Encounter.version = relation(Version, backref='encounters')
 439 Encounter.location_area = relation(LocationArea, backref='encounters')
 440 Encounter.slot = relation(EncounterTypeSlot, backref='encounters')
 441 Encounter.condition = relation(EncounterCondition, backref='encounters')
 442
 443 EncounterCondition.group = relation(EncounterConditionGroup,
 444                                     backref='conditions')
 445
 446 EncounterTypeSlot.type = relation(EncounterType, backref='slots')
 447
 448 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
 449
 450 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
 451
 452 LocationArea.location = relation(Location, backref='areas')
 453
 454 Machine.generation = relation(Generation)
 455
 456 Move.contest_effect = relation(ContestEffect, backref='moves')
 457 Move.contest_combo_next = association_proxy('contest_combo_first', 'second')
 458 Move.contest_combo_prev = association_proxy('contest_combo_second', 'first')
 459 Move.damage_class = relation(MoveDamageClass, backref='moves')
 460 Move.flags = association_proxy('move_flags', 'flag')
 461 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.generation_id, backref='move')
 462 Move.foreign_names = relation(MoveName, backref='pokemon')
 463 Move.generation = relation(Generation, backref='moves')
 464 Move.machines = relation(Machine, backref='move')
 465 Move.move_effect = relation(MoveEffect, backref='moves')
 466 Move.move_flags = relation(MoveFlag, backref='move')
 467 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
 468 Move.super_contest_combo_next = association_proxy('super_contest_combo_first', 'second')
 469 Move.super_contest_combo_prev = association_proxy('super_contest_combo_second', 'first')
 470 Move.target = relation(MoveTarget, backref='moves')
 471 Move.type = relation(Type, backref='moves')
 472
 473 Move.effect = rst.MoveEffectProperty('effect')
 474 Move.priority = association_proxy('move_effect', 'priority')
 475 Move.short_effect = rst.MoveEffectProperty('short_effect')
 476
 477 MoveFlag.flag = relation(MoveFlagType)
 478
 479 MoveFlavorText.generation = relation(Generation)
 480
 481 MoveName.language = relation(Language)
 482
 483 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
 484                                       order_by=PokemonAbility.slot,
 485                                       backref='pokemon')
 486 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
 487                                                backref=backref('forme_base_pokemon',
 488                                                                remote_side=[Pokemon.id]))
 489 Pokemon.dex_numbers = relation(PokemonDexNumber, backref='pokemon')
 490 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
 491                                         order_by=PokemonEggGroup.egg_group_id,
 492                                         backref='pokemon')
 493 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
 494 Pokemon.evolution_method = relation(EvolutionMethod)
 495 Pokemon.evolution_children = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.evolution_parent_pokemon_id,
 496                                                backref=backref('evolution_parent',
 497                                                                remote_side=[Pokemon.id]))
 498 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.pokemon_id, backref='pokemon')
 499 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
 500 Pokemon.items = relation(PokemonItem)
 501 Pokemon.generation = relation(Generation, backref='pokemon')
 502 Pokemon.shape = relation(PokemonShape, backref='pokemon')
 503 Pokemon.stats = relation(PokemonStat, backref='pokemon')
 504 Pokemon.types = relation(Type, secondary=PokemonType.__table__)
 505
 506 PokemonDexNumber.generation = relation(Generation)
 507
 508 PokemonFlavorText.version = relation(Version)
 509
 510 PokemonItem.item = relation(Item, backref='pokemon')
 511 PokemonItem.version = relation(Version)
 512
 513 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
 514                                                              uselist=False))
 515 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
 516 PokemonFormSprite.introduced_in = relation(VersionGroup)
 517
 518 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
 519 PokemonMove.version_group = relation(VersionGroup)
 520 PokemonMove.move = relation(Move, backref='pokemon_moves')
 521 PokemonMove.method = relation(PokemonMoveMethod)
 522
 523 PokemonName.language = relation(Language)
 524
 525 PokemonStat.stat = relation(Stat)
 526
 527 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
 528                                         backref='super_contest_combo_first')
 529 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
 530                                          backref='super_contest_combo_second')
 531
 532 Type.damage_efficacies = relation(TypeEfficacy,
 533                                   primaryjoin=Type.id
 534                                       ==TypeEfficacy.damage_type_id,
 535                                   backref='damage_type')
 536 Type.target_efficacies = relation(TypeEfficacy,
 537                                   primaryjoin=Type.id
 538                                       ==TypeEfficacy.target_type_id,
 539                                   backref='target_type')
 540
 541 Version.version_group = relation(VersionGroup, backref='versions')
 542 Version.generation = association_proxy('version_group', 'generation')
 543
 544 VersionGroup.generation = relation(Generation, backref='version_groups')