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, eagerload_all, relation
   7 from sqlalchemy.orm.session import Session
   8 from sqlalchemy.sql import and_
   9 from sqlalchemy.types import *
  10
  11 from pokedex.db import markdown
  12
  13 metadata = MetaData()
  14 TableBase = declarative_base(metadata=metadata)
  15
  16 class Ability(TableBase):
  17     __tablename__ = 'abilities'
  18     __singlename__ = 'ability'
  19     id = Column(Integer, primary_key=True, nullable=False)
  20     name = Column(Unicode(24), nullable=False)
  21     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
  22     effect = Column(markdown.MarkdownColumn(5120), nullable=False)
  23     short_effect = Column(markdown.MarkdownColumn(255), nullable=False)
  24
  25 class AbilityFlavorText(TableBase):
  26     __tablename__ = 'ability_flavor_text'
  27     ability_id = Column(Integer, ForeignKey('abilities.id'), primary_key=True, nullable=False, autoincrement=False)
  28     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
  29     flavor_text = Column(Unicode(64), nullable=False)
  30
  31 class AbilityName(TableBase):
  32     __tablename__ = 'ability_names'
  33     ability_id = Column(Integer, ForeignKey('abilities.id'), primary_key=True, nullable=False, autoincrement=False)
  34     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
  35     name = Column(Unicode(16), nullable=False)
  36
  37 class Berry(TableBase):
  38     __tablename__ = 'berries'
  39     id = Column(Integer, primary_key=True, nullable=False)
  40     item_id = Column(Integer, ForeignKey('items.id'), nullable=False)
  41     firmness_id = Column(Integer, ForeignKey('berry_firmness.id'), nullable=False)
  42     natural_gift_power = Column(Integer, nullable=True)
  43     natural_gift_type_id = Column(Integer, ForeignKey('types.id'), nullable=True)
  44     size = Column(Integer, nullable=False)
  45     max_harvest = Column(Integer, nullable=False)
  46     growth_time = Column(Integer, nullable=False)
  47     soil_dryness = Column(Integer, nullable=False)
  48     smoothness = Column(Integer, nullable=False)
  49
  50 class BerryFirmness(TableBase):
  51     __tablename__ = 'berry_firmness'
  52     id = Column(Integer, primary_key=True, nullable=False)
  53     name = Column(Unicode(10), nullable=False)
  54
  55 class BerryFlavor(TableBase):
  56     __tablename__ = 'berry_flavors'
  57     berry_id = Column(Integer, ForeignKey('berries.id'), primary_key=True, nullable=False, autoincrement=False)
  58     contest_type_id = Column(Integer, ForeignKey('contest_types.id'), primary_key=True, nullable=False, autoincrement=False)
  59     flavor = Column(Integer, nullable=False)
  60
  61 class ContestCombo(TableBase):
  62     __tablename__ = 'contest_combos'
  63     first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
  64     second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
  65
  66 class ContestEffect(TableBase):
  67     __tablename__ = 'contest_effects'
  68     id = Column(Integer, primary_key=True, nullable=False)
  69     appeal = Column(SmallInteger, nullable=False)
  70     jam = Column(SmallInteger, nullable=False)
  71     flavor_text = Column(Unicode(64), nullable=False)
  72     effect = Column(Unicode(255), nullable=False)
  73
  74 class ContestType(TableBase):
  75     __tablename__ = 'contest_types'
  76     id = Column(Integer, primary_key=True, nullable=False)
  77     name = Column(Unicode(6), nullable=False)
  78     flavor = Column(Unicode(6), nullable=False)
  79     color = Column(Unicode(6), nullable=False)
  80
  81 class EggGroup(TableBase):
  82     __tablename__ = 'egg_groups'
  83     id = Column(Integer, primary_key=True, nullable=False)
  84     name = Column(Unicode(16), nullable=False)
  85
  86 class Encounter(TableBase):
  87     """Rows in this table represent encounters with wild Pokémon.  Bear with
  88     me, here.
  89
  90     Within a given area in a given game, encounters are differentiated by the
  91     "slot" they are in and the state of the game world.
  92
  93     What the player is doing to get an encounter, such as surfing or walking
  94     through tall grass, is called terrain.  Each terrain has its own set of
  95     encounter slots.
  96
  97     Within a terrain, slots are defined primarily by rarity.  Each slot can
  98     also be affected by world conditions; for example, the 20% slot for walking
  99     in tall grass is affected by whether a swarm is in effect in that area.
 100     "Is there a swarm?" is a condition; "there is a swarm" and "there is not a
 101     swarm" are the possible values of this condition.
 102
 103     A slot (20% walking in grass) and any appropriate world conditions (no
 104     swarm) are thus enough to define a specific encounter.
 105
 106     Well, okay, almost: each slot actually appears twice.
 107     """
 108
 109     __tablename__ = 'encounters'
 110     id = Column(Integer, primary_key=True, nullable=False)
 111     version_id = Column(Integer, ForeignKey('versions.id'), nullable=False, autoincrement=False)
 112     location_area_id = Column(Integer, ForeignKey('location_areas.id'), nullable=False, autoincrement=False)
 113     encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), nullable=False, autoincrement=False)
 114     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False, autoincrement=False)
 115     min_level = Column(Integer, nullable=False, autoincrement=False)
 116     max_level = Column(Integer, nullable=False, autoincrement=False)
 117
 118 class EncounterCondition(TableBase):
 119     """Rows in this table represent varying conditions in the game world, such
 120     as time of day.
 121     """
 122
 123     __tablename__ = 'encounter_conditions'
 124     id = Column(Integer, primary_key=True, nullable=False)
 125     name = Column(Unicode(64), nullable=False)
 126
 127 class EncounterConditionValue(TableBase):
 128     """Rows in this table represent possible states for a condition; for
 129     example, the state of 'swarm' could be 'swarm' or 'no swarm'.
 130     """
 131
 132     __tablename__ = 'encounter_condition_values'
 133     id = Column(Integer, primary_key=True, nullable=False)
 134     encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=False, nullable=False, autoincrement=False)
 135     name = Column(Unicode(64), nullable=False)
 136     is_default = Column(Boolean, nullable=False)
 137
 138 class EncounterConditionValueMap(TableBase):
 139     """Maps encounters to the specific conditions under which they occur."""
 140
 141     __tablename__ = 'encounter_condition_value_map'
 142     encounter_id = Column(Integer, ForeignKey('encounters.id'), primary_key=True, nullable=False, autoincrement=False)
 143     encounter_condition_value_id = Column(Integer, ForeignKey('encounter_condition_values.id'), primary_key=True, nullable=False, autoincrement=False)
 144
 145 class EncounterTerrain(TableBase):
 146     """Rows in this table represent ways the player can enter a wild encounter,
 147     e.g., surfing, fishing, or walking through tall grass.
 148     """
 149
 150     __tablename__ = 'encounter_terrain'
 151     id = Column(Integer, primary_key=True, nullable=False)
 152     name = Column(Unicode(64), nullable=False)
 153
 154 class EncounterSlot(TableBase):
 155     """Rows in this table represent an abstract "slot" within a terrain,
 156     associated with both some set of conditions and a rarity.
 157
 158     Note that there are two encounters per slot, so the rarities will only add
 159     up to 50.
 160     """
 161
 162     __tablename__ = 'encounter_slots'
 163     id = Column(Integer, primary_key=True, nullable=False)
 164     version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False, autoincrement=False)
 165     encounter_terrain_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=False, nullable=False, autoincrement=False)
 166     slot = Column(Integer, nullable=True)
 167     rarity = Column(Integer, nullable=False)
 168
 169 class EncounterSlotCondition(TableBase):
 170     """Lists all conditions that affect each slot."""
 171
 172     __tablename__ = 'encounter_slot_conditions'
 173     encounter_slot_id = Column(Integer, ForeignKey('encounter_slots.id'), primary_key=True, nullable=False, autoincrement=False)
 174     encounter_condition_id = Column(Integer, ForeignKey('encounter_conditions.id'), primary_key=True, nullable=False, autoincrement=False)
 175
 176 class EvolutionChain(TableBase):
 177     __tablename__ = 'evolution_chains'
 178     id = Column(Integer, primary_key=True, nullable=False)
 179     growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), nullable=False)
 180     baby_trigger_item = Column(Unicode(12))
 181
 182 class EvolutionTrigger(TableBase):
 183     __tablename__ = 'evolution_triggers'
 184     id = Column(Integer, primary_key=True, nullable=False)
 185     identifier = Column(Unicode(16), nullable=False)
 186
 187 class Experience(TableBase):
 188     __tablename__ = 'experience'
 189     growth_rate_id = Column(Integer, ForeignKey('growth_rates.id'), primary_key=True, nullable=False)
 190     level = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 191     experience = Column(Integer, nullable=False)
 192
 193 class Generation(TableBase):
 194     __tablename__ = 'generations'
 195     id = Column(Integer, primary_key=True, nullable=False)
 196     main_region_id = Column(Integer, ForeignKey('regions.id'))
 197     canonical_pokedex_id = Column(Integer, ForeignKey('pokedexes.id'))
 198     name = Column(Unicode(16), nullable=False)
 199
 200 class GrowthRate(TableBase):
 201     """`formula` is written in LaTeX math notation."""
 202     __tablename__ = 'growth_rates'
 203     id = Column(Integer, primary_key=True, nullable=False)
 204     name = Column(Unicode(20), nullable=False)
 205     formula = Column(Unicode(500), nullable=False)
 206
 207 class Item(TableBase):
 208     __tablename__ = 'items'
 209     __singlename__ = 'item'
 210     id = Column(Integer, primary_key=True, nullable=False)
 211     name = Column(Unicode(16), nullable=False)
 212     category_id = Column(Integer, ForeignKey('item_categories.id'), nullable=False)
 213     cost = Column(Integer, nullable=False)
 214     fling_power = Column(Integer, nullable=True)
 215     fling_effect_id = Column(Integer, ForeignKey('item_fling_effects.id'), nullable=True)
 216     effect = Column(markdown.MarkdownColumn(5120), nullable=False)
 217
 218     @property
 219     def appears_underground(self):
 220         return any(flag.identifier == u'underground' for flag in self.flags)
 221
 222 class ItemCategory(TableBase):
 223     __tablename__ = 'item_categories'
 224     id = Column(Integer, primary_key=True, nullable=False)
 225     pocket_id = Column(Integer, ForeignKey('item_pockets.id'), nullable=False)
 226     name = Column(Unicode(16), nullable=False)
 227
 228 class ItemFlag(TableBase):
 229     __tablename__ = 'item_flags'
 230     id = Column(Integer, primary_key=True, nullable=False)
 231     identifier = Column(Unicode(24), nullable=False)
 232     name = Column(Unicode(64), nullable=False)
 233
 234 class ItemFlagMap(TableBase):
 235     __tablename__ = 'item_flag_map'
 236     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
 237     item_flag_id = Column(Integer, ForeignKey('item_flags.id'), primary_key=True, autoincrement=False, nullable=False)
 238
 239 class ItemFlavorText(TableBase):
 240     __tablename__ = 'item_flavor_text'
 241     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
 242     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, autoincrement=False, nullable=False)
 243     flavor_text = Column(Unicode(255), nullable=False)
 244
 245 class ItemFlingEffect(TableBase):
 246     __tablename__ = 'item_fling_effects'
 247     id = Column(Integer, primary_key=True, nullable=False)
 248     effect = Column(Unicode(255), nullable=False)
 249
 250 class ItemInternalID(TableBase):
 251     __tablename__ = 'item_internal_ids'
 252     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, autoincrement=False, nullable=False)
 253     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, autoincrement=False, nullable=False)
 254     internal_id = Column(Integer, nullable=False)
 255
 256 class ItemName(TableBase):
 257     __tablename__ = 'item_names'
 258     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
 259     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 260     name = Column(Unicode(16), nullable=False)
 261
 262 class ItemPocket(TableBase):
 263     __tablename__ = 'item_pockets'
 264     id = Column(Integer, primary_key=True, nullable=False)
 265     identifier = Column(Unicode(16), nullable=False)
 266     name = Column(Unicode(16), nullable=False)
 267
 268 class Language(TableBase):
 269     __tablename__ = 'languages'
 270     id = Column(Integer, primary_key=True, nullable=False)
 271     iso639 = Column(Unicode(2), nullable=False)
 272     iso3166 = Column(Unicode(2), nullable=False)
 273     name = Column(Unicode(16), nullable=False)
 274
 275 class Location(TableBase):
 276     __tablename__ = 'locations'
 277     __singlename__ = 'location'
 278     id = Column(Integer, primary_key=True, nullable=False)
 279     region_id = Column(Integer, ForeignKey('regions.id'))
 280     name = Column(Unicode(64), nullable=False)
 281
 282 class LocationArea(TableBase):
 283     __tablename__ = 'location_areas'
 284     id = Column(Integer, primary_key=True, nullable=False)
 285     location_id = Column(Integer, ForeignKey('locations.id'), nullable=False)
 286     internal_id = Column(Integer, nullable=False)
 287     name = Column(Unicode(64), nullable=True)
 288
 289 class LocationAreaEncounterRate(TableBase):
 290     __tablename__ = 'location_area_encounter_rates'
 291     location_area_id = Column(Integer, ForeignKey('location_areas.id'), primary_key=True, nullable=False, autoincrement=False)
 292     encounter_terrain_id = Column(Integer, ForeignKey('encounter_terrain.id'), primary_key=True, nullable=False, autoincrement=False)
 293     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, autoincrement=False)
 294     rate = Column(Integer, nullable=True)
 295
 296 class LocationInternalID(TableBase):
 297     __tablename__ = 'location_internal_ids'
 298     location_id = Column(Integer, ForeignKey('locations.id'), nullable=False, primary_key=True)
 299     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False, primary_key=True)
 300     internal_id = Column(Integer, nullable=False)
 301
 302 class Machine(TableBase):
 303     __tablename__ = 'machines'
 304     machine_number = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 305     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 306     item_id = Column(Integer, ForeignKey('items.id'), nullable=False)
 307     move_id = Column(Integer, ForeignKey('moves.id'), nullable=False)
 308
 309     @property
 310     def is_hm(self):
 311         return self.machine_number >= 100
 312
 313 class MoveBattleStyle(TableBase):
 314     __tablename__ = 'move_battle_styles'
 315     id = Column(Integer, primary_key=True, nullable=False)
 316     name = Column(Unicode(8), nullable=False)
 317
 318 class MoveEffectCategory(TableBase):
 319     __tablename__ = 'move_effect_categories'
 320     id = Column(Integer, primary_key=True, nullable=False)
 321     name = Column(Unicode(64), nullable=False)
 322     can_affect_user = Column(Boolean, nullable=False)
 323
 324 class MoveEffectCategoryMap(TableBase):
 325     __tablename__ = 'move_effect_category_map'
 326     move_effect_id = Column(Integer, ForeignKey('move_effects.id'), primary_key=True, nullable=False)
 327     move_effect_category_id = Column(Integer, ForeignKey('move_effect_categories.id'), primary_key=True, nullable=False)
 328     affects_user = Column(Boolean, primary_key=True, nullable=False)
 329
 330 class MoveDamageClass(TableBase):
 331     __tablename__ = 'move_damage_classes'
 332     id = Column(Integer, primary_key=True, nullable=False)
 333     name = Column(Unicode(8), nullable=False)
 334     description = Column(Unicode(64), nullable=False)
 335
 336 class MoveEffect(TableBase):
 337     __tablename__ = 'move_effects'
 338     id = Column(Integer, primary_key=True, nullable=False)
 339     priority = Column(SmallInteger, nullable=False)
 340     short_effect = Column(Unicode(256), nullable=False)
 341     effect = Column(Unicode(5120), nullable=False)
 342
 343 class MoveFlag(TableBase):
 344     __tablename__ = 'move_flags'
 345     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 346     move_flag_type_id = Column(Integer, ForeignKey('move_flag_types.id'), primary_key=True, nullable=False, autoincrement=False)
 347
 348 class MoveFlagType(TableBase):
 349     __tablename__ = 'move_flag_types'
 350     id = Column(Integer, primary_key=True, nullable=False)
 351     identifier = Column(Unicode(16), nullable=False)
 352     name = Column(Unicode(32), nullable=False)
 353     description = Column(markdown.MarkdownColumn(128), nullable=False)
 354
 355 class MoveFlavorText(TableBase):
 356     __tablename__ = 'move_flavor_text'
 357     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 358     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 359     flavor_text = Column(Unicode(255), nullable=False)
 360
 361 class MoveName(TableBase):
 362     __tablename__ = 'move_names'
 363     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 364     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 365     name = Column(Unicode(16), nullable=False)
 366
 367 class MoveTarget(TableBase):
 368     __tablename__ = 'move_targets'
 369     id = Column(Integer, primary_key=True, nullable=False)
 370     name = Column(Unicode(32), nullable=False)
 371     description = Column(Unicode(128), nullable=False)
 372
 373 class Move(TableBase):
 374     __tablename__ = 'moves'
 375     __singlename__ = 'move'
 376     id = Column(Integer, primary_key=True, nullable=False)
 377     name = Column(Unicode(12), nullable=False)
 378     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 379     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 380     power = Column(SmallInteger)
 381     pp = Column(SmallInteger, nullable=False)
 382     accuracy = Column(SmallInteger)
 383     target_id = Column(Integer, ForeignKey('move_targets.id'), nullable=False)
 384     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False)
 385     effect_id = Column(Integer, ForeignKey('move_effects.id'), nullable=False)
 386     effect_chance = Column(Integer)
 387     contest_type_id = Column(Integer, ForeignKey('contest_types.id'), nullable=True)
 388     contest_effect_id = Column(Integer, ForeignKey('contest_effects.id'), nullable=True)
 389     super_contest_effect_id = Column(Integer, ForeignKey('super_contest_effects.id'), nullable=False)
 390
 391 class Nature(TableBase):
 392     __tablename__ = 'natures'
 393     __singlename__ = 'nature'
 394     id = Column(Integer, primary_key=True, nullable=False)
 395     name = Column(Unicode(8), nullable=False)
 396     decreased_stat_id = Column(Integer, ForeignKey('stats.id'), nullable=False)
 397     increased_stat_id = Column(Integer, ForeignKey('stats.id'), nullable=False)
 398     hates_flavor_id = Column(Integer, ForeignKey('contest_types.id'), nullable=False)
 399     likes_flavor_id = Column(Integer, ForeignKey('contest_types.id'), nullable=False)
 400
 401 class NatureBattleStylePreference(TableBase):
 402     __tablename__ = 'nature_battle_style_preferences'
 403     nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False)
 404     move_battle_style_id = Column(Integer, ForeignKey('move_battle_styles.id'), primary_key=True, nullable=False)
 405     low_hp_preference = Column(Integer, nullable=False)
 406     high_hp_preference = Column(Integer, nullable=False)
 407
 408 class NatureName(TableBase):
 409     __tablename__ = 'nature_names'
 410     nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False, autoincrement=False)
 411     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 412     name = Column(Unicode(8), nullable=False)
 413
 414 class NaturePokeathlonStat(TableBase):
 415     __tablename__ = 'nature_pokeathlon_stats'
 416     nature_id = Column(Integer, ForeignKey('natures.id'), primary_key=True, nullable=False)
 417     pokeathlon_stat_id = Column(Integer, ForeignKey('pokeathlon_stats.id'), primary_key=True, nullable=False)
 418     max_change = Column(Integer, nullable=False)
 419
 420 class PokeathlonStat(TableBase):
 421     __tablename__ = 'pokeathlon_stats'
 422     id = Column(Integer, primary_key=True, nullable=False)
 423     name = Column(Unicode(8), nullable=False)
 424
 425 class Pokedex(TableBase):
 426     __tablename__ = 'pokedexes'
 427     id = Column(Integer, primary_key=True, nullable=False)
 428     region_id = Column(Integer, ForeignKey('regions.id'), nullable=True)
 429     name = Column(Unicode(16), nullable=False)
 430     description = Column(Unicode(512))
 431
 432 class PokedexVersionGroup(TableBase):
 433     __tablename__ = 'pokedex_version_groups'
 434     pokedex_id = Column(Integer, ForeignKey('pokedexes.id'), primary_key=True, nullable=False, autoincrement=False)
 435     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 436
 437 class Pokemon(TableBase):
 438     """The core to this whole mess.
 439
 440     Note that I use both 'forme' and 'form' in both code and the database.  I
 441     only use 'forme' when specifically referring to Pokémon that have multiple
 442     distinct species as forms—i.e., different stats or movesets.  'Form' is a
 443     more general term referring to any variation within a species, including
 444     purely cosmetic forms like Unown.
 445     """
 446     __tablename__ = 'pokemon'
 447     __singlename__ = 'pokemon'
 448     id = Column(Integer, primary_key=True, nullable=False)
 449     name = Column(Unicode(20), nullable=False)
 450     forme_name = Column(Unicode(16))
 451     forme_base_pokemon_id = Column(Integer, ForeignKey('pokemon.id'))
 452     generation_id = Column(Integer, ForeignKey('generations.id'))
 453     evolution_chain_id = Column(Integer, ForeignKey('evolution_chains.id'))
 454     height = Column(Integer, nullable=False)
 455     weight = Column(Integer, nullable=False)
 456     species = Column(Unicode(16), nullable=False)
 457     color_id = Column(Integer, ForeignKey('pokemon_colors.id'), nullable=False)
 458     pokemon_shape_id = Column(Integer, ForeignKey('pokemon_shapes.id'), nullable=False)
 459     habitat_id = Column(Integer, ForeignKey('pokemon_habitats.id'), nullable=True)
 460     gender_rate = Column(Integer, nullable=False)
 461     capture_rate = Column(Integer, nullable=False)
 462     base_experience = Column(Integer, nullable=False)
 463     base_happiness = Column(Integer, nullable=False)
 464     is_baby = Column(Boolean, nullable=False)
 465     hatch_counter = Column(Integer, nullable=False)
 466     has_gen4_fem_sprite = Column(Boolean, nullable=False)
 467     has_gen4_fem_back_sprite = Column(Boolean, nullable=False)
 468
 469     ### Stuff to handle alternate Pokémon forms
 470
 471     @property
 472     def national_id(self):
 473         """Returns the National Pokédex number for this Pokémon.  Use this
 474         instead of the id directly; alternate formes may make the id incorrect.
 475         """
 476
 477         if self.forme_base_pokemon_id:
 478             return self.forme_base_pokemon_id
 479         return self.id
 480
 481     @property
 482     def full_name(self):
 483         """Returns the name of this Pokémon, including its Forme, if any."""
 484
 485         if self.forme_name:
 486             return "%s %s" % (self.forme_name.title(), self.name)
 487         return self.name
 488
 489     @property
 490     def normal_form(self):
 491         """Returns the normal form for this Pokémon; i.e., this will return
 492         regular Deoxys when called on any Deoxys form.
 493         """
 494
 495         if self.forme_base_pokemon:
 496             return self.forme_base_pokemon
 497
 498         return self
 499
 500     ### Not forms!
 501
 502     def stat(self, stat_name):
 503         """Returns a PokemonStat record for the given stat name (or Stat row
 504         object).  Uses the normal has-many machinery, so all the stats are
 505         effectively cached.
 506         """
 507         if isinstance(stat_name, Stat):
 508             stat_name = stat_name.name
 509
 510         for pokemon_stat in self.stats:
 511             if pokemon_stat.stat.name == stat_name:
 512                 return pokemon_stat
 513
 514         raise KeyError(u'No stat named %s' % stat_name)
 515
 516     @property
 517     def better_damage_class(self):
 518         u"""Returns the MoveDamageClass that this Pokémon is best suited for,
 519         based on its attack stats.
 520
 521         If the attack stats are about equal (within 5), returns None.  The
 522         value None, not the damage class called 'None'.
 523         """
 524         phys = self.stat(u'Attack')
 525         spec = self.stat(u'Special Attack')
 526
 527         diff = phys.base_stat - spec.base_stat
 528
 529         if diff > 5:
 530             return phys.stat.damage_class
 531         elif diff < -5:
 532             return spec.stat.damage_class
 533         else:
 534             return None
 535
 536 class PokemonAbility(TableBase):
 537     __tablename__ = 'pokemon_abilities'
 538     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 539     ability_id = Column(Integer, ForeignKey('abilities.id'), nullable=False)
 540     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 541
 542 class PokemonColor(TableBase):
 543     __tablename__ = 'pokemon_colors'
 544     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 545     name = Column(Unicode(6), nullable=False)
 546
 547 class PokemonDexNumber(TableBase):
 548     __tablename__ = 'pokemon_dex_numbers'
 549     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 550     pokedex_id = Column(Integer, ForeignKey('pokedexes.id'), primary_key=True, nullable=False, autoincrement=False)
 551     pokedex_number = Column(Integer, nullable=False)
 552
 553 class PokemonEggGroup(TableBase):
 554     __tablename__ = 'pokemon_egg_groups'
 555     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 556     egg_group_id = Column(Integer, ForeignKey('egg_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 557
 558 class PokemonEvolution(TableBase):
 559     __tablename__ = 'pokemon_evolution'
 560     from_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=False)
 561     to_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 562     evolution_trigger_id = Column(Integer, ForeignKey('evolution_triggers.id'), nullable=False)
 563     trigger_item_id = Column(Integer, ForeignKey('items.id'), nullable=True)
 564     minimum_level = Column(Integer, nullable=True)
 565     gender = Column(Enum('male', 'female', name='pokemon_evolution_gender'), nullable=True)
 566     location_id = Column(Integer, ForeignKey('locations.id'), nullable=True)
 567     held_item_id = Column(Integer, ForeignKey('items.id'), nullable=True)
 568     time_of_day = Column(Enum('morning', 'day', 'night', name='pokemon_evolution_time_of_day'), nullable=True)
 569     known_move_id = Column(Integer, ForeignKey('moves.id'), nullable=True)
 570     minimum_happiness = Column(Integer, nullable=True)
 571     minimum_beauty = Column(Integer, nullable=True)
 572     relative_physical_stats = Column(Integer, nullable=True)
 573     party_pokemon_id = Column(Integer, ForeignKey('pokemon.id'), nullable=True)
 574
 575 class PokemonFlavorText(TableBase):
 576     __tablename__ = 'pokemon_flavor_text'
 577     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 578     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 579     flavor_text = Column(Unicode(255), nullable=False)
 580
 581 class PokemonFormGroup(TableBase):
 582     __tablename__ = 'pokemon_form_groups'
 583     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 584     is_battle_only = Column(Boolean, nullable=False)
 585     description = Column(markdown.MarkdownColumn(1024), nullable=False)
 586
 587 class PokemonFormSprite(TableBase):
 588     __tablename__ = 'pokemon_form_sprites'
 589     id = Column(Integer, primary_key=True, nullable=False)
 590     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 591     introduced_in_version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 592     name = Column(Unicode(16), nullable=True)
 593     is_default = Column(Boolean, nullable=True)
 594
 595 class PokemonHabitat(TableBase):
 596     __tablename__ = 'pokemon_habitats'
 597     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 598     name = Column(Unicode(16), nullable=False)
 599
 600 class PokemonInternalID(TableBase):
 601     __tablename__ = 'pokemon_internal_ids'
 602     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, autoincrement=False, nullable=False)
 603     generation_id = Column(Integer, ForeignKey('generations.id'), primary_key=True, autoincrement=False, nullable=False)
 604     internal_id = Column(Integer, nullable=False)
 605
 606 class PokemonItem(TableBase):
 607     __tablename__ = 'pokemon_items'
 608     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 609     version_id = Column(Integer, ForeignKey('versions.id'), primary_key=True, nullable=False, autoincrement=False)
 610     item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
 611     rarity = Column(Integer, nullable=False)
 612
 613 class PokemonMove(TableBase):
 614     __tablename__ = 'pokemon_moves'
 615     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 616     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
 617     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
 618     pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
 619     level = Column(Integer, primary_key=True, nullable=True, autoincrement=False, index=True)
 620     order = Column(Integer, nullable=True, index=True)
 621
 622 class PokemonMoveMethod(TableBase):
 623     __tablename__ = 'pokemon_move_methods'
 624     id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 625     name = Column(Unicode(64), nullable=False)
 626     description = Column(Unicode(255), nullable=False)
 627
 628 class PokemonName(TableBase):
 629     __tablename__ = 'pokemon_names'
 630     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 631     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 632     name = Column(Unicode(16), nullable=False)
 633
 634 class PokemonShape(TableBase):
 635     __tablename__ = 'pokemon_shapes'
 636     id = Column(Integer, primary_key=True, nullable=False)
 637     name = Column(Unicode(24), nullable=False)
 638     awesome_name = Column(Unicode(16), nullable=False)
 639
 640 class PokemonStat(TableBase):
 641     __tablename__ = 'pokemon_stats'
 642     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 643     stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
 644     base_stat = Column(Integer, nullable=False)
 645     effort = Column(Integer, nullable=False)
 646
 647 class PokemonType(TableBase):
 648     __tablename__ = 'pokemon_types'
 649     pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
 650     type_id = Column(Integer, ForeignKey('types.id'), nullable=False)
 651     slot = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
 652
 653 class Region(TableBase):
 654     """Major areas of the world: Kanto, Johto, etc."""
 655     __tablename__ = 'regions'
 656     id = Column(Integer, primary_key=True, nullable=False)
 657     name = Column(Unicode(16), nullable=False)
 658
 659 class Stat(TableBase):
 660     __tablename__ = 'stats'
 661     id = Column(Integer, primary_key=True, nullable=False)
 662     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=True)
 663     name = Column(Unicode(16), nullable=False)
 664
 665 class SuperContestCombo(TableBase):
 666     __tablename__ = 'super_contest_combos'
 667     first_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 668     second_move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
 669
 670 class SuperContestEffect(TableBase):
 671     __tablename__ = 'super_contest_effects'
 672     id = Column(Integer, primary_key=True, nullable=False)
 673     appeal = Column(SmallInteger, nullable=False)
 674     flavor_text = Column(Unicode(64), nullable=False)
 675
 676 class TypeEfficacy(TableBase):
 677     __tablename__ = 'type_efficacy'
 678     damage_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 679     target_type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 680     damage_factor = Column(Integer, nullable=False)
 681
 682 class Type(TableBase):
 683     __tablename__ = 'types'
 684     __singlename__ = 'type'
 685     id = Column(Integer, primary_key=True, nullable=False)
 686     name = Column(Unicode(8), nullable=False)
 687     abbreviation = Column(Unicode(3), nullable=False)
 688     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 689     damage_class_id = Column(Integer, ForeignKey('move_damage_classes.id'), nullable=False) ## ??? is none; everything else is physical or special
 690
 691 class TypeName(TableBase):
 692     __tablename__ = 'type_names'
 693     type_id = Column(Integer, ForeignKey('types.id'), primary_key=True, nullable=False, autoincrement=False)
 694     language_id = Column(Integer, ForeignKey('languages.id'), primary_key=True, nullable=False, autoincrement=False)
 695     name = Column(Unicode(16), nullable=False)
 696
 697 class VersionGroup(TableBase):
 698     __tablename__ = 'version_groups'
 699     id = Column(Integer, primary_key=True, nullable=False)
 700     generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False)
 701
 702 class VersionGroupRegion(TableBase):
 703     __tablename__ = 'version_group_regions'
 704     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False)
 705     region_id = Column(Integer, ForeignKey('regions.id'), primary_key=True, nullable=False)
 706
 707 class Version(TableBase):
 708     __tablename__ = 'versions'
 709     id = Column(Integer, primary_key=True, nullable=False)
 710     version_group_id = Column(Integer, ForeignKey('version_groups.id'), nullable=False)
 711     name = Column(Unicode(32), nullable=False)
 712
 713
 714 ### Relations down here, to avoid ordering problems
 715 Ability.flavor_text = relation(AbilityFlavorText, order_by=AbilityFlavorText.version_group_id, backref='ability')
 716 Ability.foreign_names = relation(AbilityName, backref='ability')
 717 Ability.generation = relation(Generation, backref='abilities')
 718
 719 AbilityFlavorText.version_group = relation(VersionGroup)
 720
 721 AbilityName.language = relation(Language)
 722
 723 Berry.berry_firmness = relation(BerryFirmness, backref='berries')
 724 Berry.firmness = association_proxy('berry_firmness', 'name')
 725 Berry.flavors = relation(BerryFlavor, order_by=BerryFlavor.contest_type_id, backref='berry')
 726 Berry.natural_gift_type = relation(Type)
 727
 728 BerryFlavor.contest_type = relation(ContestType)
 729
 730 ContestCombo.first = relation(Move, primaryjoin=ContestCombo.first_move_id==Move.id,
 731                                     backref='contest_combo_first')
 732 ContestCombo.second = relation(Move, primaryjoin=ContestCombo.second_move_id==Move.id,
 733                                      backref='contest_combo_second')
 734
 735 Encounter.location_area = relation(LocationArea, backref='encounters')
 736 Encounter.pokemon = relation(Pokemon, backref='encounters')
 737 Encounter.version = relation(Version, backref='encounters')
 738 Encounter.slot = relation(EncounterSlot, backref='encounters')
 739
 740 EncounterConditionValue.condition = relation(EncounterCondition, backref='values')
 741
 742 Encounter.condition_value_map = relation(EncounterConditionValueMap, backref='encounter')
 743 Encounter.condition_values = association_proxy('condition_value_map', 'condition_value')
 744 EncounterConditionValueMap.condition_value = relation(EncounterConditionValue,
 745                                                       backref='encounter_map')
 746
 747 EncounterSlot.terrain = relation(EncounterTerrain, backref='slots')
 748
 749 EncounterSlot.condition_map = relation(EncounterSlotCondition, backref='slot')
 750 EncounterSlot.conditions = association_proxy('condition_map', 'condition')
 751 EncounterSlotCondition.condition = relation(EncounterCondition,
 752                                             backref='slot_map')
 753
 754 EvolutionChain.growth_rate = relation(GrowthRate, backref='evolution_chains')
 755
 756 Experience.growth_rate = relation(GrowthRate, backref='experience_table')
 757
 758 Generation.canonical_pokedex = relation(Pokedex, backref='canonical_for_generation')
 759 Generation.versions = relation(Version, secondary=VersionGroup.__table__)
 760 Generation.main_region = relation(Region)
 761
 762 GrowthRate.max_experience_obj = relation(Experience, primaryjoin=and_(Experience.growth_rate_id == GrowthRate.id, Experience.level == 100), uselist=False)
 763 GrowthRate.max_experience = association_proxy('max_experience_obj', 'experience')
 764
 765 Item.berry = relation(Berry, uselist=False, backref='item')
 766 Item.flags = relation(ItemFlag, secondary=ItemFlagMap.__table__)
 767 Item.flavor_text = relation(ItemFlavorText, order_by=ItemFlavorText.version_group_id.asc(), backref='item')
 768 Item.fling_effect = relation(ItemFlingEffect, backref='items')
 769 Item.foreign_names = relation(ItemName, backref='item')
 770 Item.machines = relation(Machine, order_by=Machine.version_group_id.asc())
 771 Item.category = relation(ItemCategory)
 772 Item.pocket = association_proxy('category', 'pocket')
 773
 774 ItemCategory.items = relation(Item, order_by=Item.name)
 775 ItemCategory.pocket = relation(ItemPocket)
 776
 777 ItemFlavorText.version_group = relation(VersionGroup)
 778
 779 ItemInternalID.item = relation(Item, backref='internal_ids')
 780 ItemInternalID.generation = relation(Generation)
 781
 782 ItemName.language = relation(Language)
 783
 784 ItemPocket.categories = relation(ItemCategory, order_by=ItemCategory.name)
 785
 786 Location.region = relation(Region, backref='locations')
 787
 788 LocationArea.location = relation(Location, backref='areas')
 789
 790 LocationInternalID.location = relation(Location, backref='internal_ids')
 791 LocationInternalID.generation = relation(Generation)
 792
 793 Machine.item = relation(Item)
 794 Machine.version_group = relation(VersionGroup)
 795
 796 Move.contest_effect = relation(ContestEffect, backref='moves')
 797 Move.contest_combo_next = association_proxy('contest_combo_first', 'second')
 798 Move.contest_combo_prev = association_proxy('contest_combo_second', 'first')
 799 Move.contest_type = relation(ContestType, backref='moves')
 800 Move.damage_class = relation(MoveDamageClass, backref='moves')
 801 Move.flags = association_proxy('move_flags', 'flag')
 802 Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.version_group_id, backref='move')
 803 Move.foreign_names = relation(MoveName, backref='move')
 804 Move.generation = relation(Generation, backref='moves')
 805 Move.machines = relation(Machine, backref='move')
 806 Move.move_effect = relation(MoveEffect, backref='moves')
 807 Move.move_flags = relation(MoveFlag, backref='move')
 808 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
 809 Move.super_contest_combo_next = association_proxy('super_contest_combo_first', 'second')
 810 Move.super_contest_combo_prev = association_proxy('super_contest_combo_second', 'first')
 811 Move.target = relation(MoveTarget, backref='moves')
 812 Move.type = relation(Type, backref='moves')
 813
 814 Move.effect = markdown.MoveEffectProperty('effect')
 815 Move.priority = association_proxy('move_effect', 'priority')
 816 Move.short_effect = markdown.MoveEffectProperty('short_effect')
 817
 818 MoveEffect.category_map = relation(MoveEffectCategoryMap)
 819 MoveEffect.categories = association_proxy('category_map', 'category')
 820 MoveEffectCategoryMap.category = relation(MoveEffectCategory)
 821
 822 MoveFlag.flag = relation(MoveFlagType)
 823
 824 MoveFlavorText.version_group = relation(VersionGroup)
 825
 826 MoveName.language = relation(Language)
 827
 828 Nature.foreign_names = relation(NatureName, backref='nature')
 829 Nature.decreased_stat = relation(Stat, primaryjoin=Nature.decreased_stat_id==Stat.id,
 830                                        backref='decreasing_natures')
 831 Nature.increased_stat = relation(Stat, primaryjoin=Nature.increased_stat_id==Stat.id,
 832                                        backref='increasing_natures')
 833 Nature.hates_flavor = relation(ContestType, primaryjoin=Nature.hates_flavor_id==ContestType.id,
 834                                        backref='hating_natures')
 835 Nature.likes_flavor = relation(ContestType, primaryjoin=Nature.likes_flavor_id==ContestType.id,
 836                                        backref='liking_natures')
 837 Nature.battle_style_preferences = relation(NatureBattleStylePreference,
 838                                            order_by=NatureBattleStylePreference.move_battle_style_id,
 839                                            backref='nature')
 840 Nature.pokeathlon_effects = relation(NaturePokeathlonStat, order_by=NaturePokeathlonStat.pokeathlon_stat_id)
 841
 842 NatureBattleStylePreference.battle_style = relation(MoveBattleStyle, backref='nature_preferences')
 843
 844 NatureName.language = relation(Language)
 845
 846 NaturePokeathlonStat.pokeathlon_stat = relation(PokeathlonStat, backref='nature_effects')
 847
 848 Pokedex.region = relation(Region, backref='pokedexes')
 849 Pokedex.version_groups = relation(VersionGroup, secondary=PokedexVersionGroup.__table__, backref='pokedexes')
 850
 851 Pokemon.abilities = relation(Ability, secondary=PokemonAbility.__table__,
 852                                       order_by=PokemonAbility.slot,
 853                                       backref='pokemon')
 854 Pokemon.formes = relation(Pokemon, primaryjoin=Pokemon.id==Pokemon.forme_base_pokemon_id,
 855                                                backref=backref('forme_base_pokemon',
 856                                                                remote_side=[Pokemon.id]))
 857 Pokemon.pokemon_color = relation(PokemonColor, backref='pokemon')
 858 Pokemon.color = association_proxy('pokemon_color', 'name')
 859 Pokemon.dex_numbers = relation(PokemonDexNumber, order_by=PokemonDexNumber.pokedex_id.asc(), backref='pokemon')
 860 Pokemon.default_form_sprite = relation(PokemonFormSprite,
 861                                        primaryjoin=and_(
 862                                             Pokemon.id==PokemonFormSprite.pokemon_id,
 863                                             PokemonFormSprite.is_default==True,
 864                                        ),
 865                                        uselist=False)
 866 Pokemon.egg_groups = relation(EggGroup, secondary=PokemonEggGroup.__table__,
 867                                         order_by=PokemonEggGroup.egg_group_id,
 868                                         backref='pokemon')
 869 Pokemon.evolution_chain = relation(EvolutionChain, backref='pokemon')
 870 Pokemon.child_pokemon = relation(Pokemon,
 871     primaryjoin=Pokemon.id==PokemonEvolution.from_pokemon_id,
 872     secondary=PokemonEvolution.__table__,
 873     secondaryjoin=PokemonEvolution.to_pokemon_id==Pokemon.id,
 874     backref=backref('parent_pokemon', uselist=False),
 875 )
 876 Pokemon.flavor_text = relation(PokemonFlavorText, order_by=PokemonFlavorText.version_id.asc(), backref='pokemon')
 877 Pokemon.foreign_names = relation(PokemonName, backref='pokemon')
 878 Pokemon.pokemon_habitat = relation(PokemonHabitat, backref='pokemon')
 879 Pokemon.habitat = association_proxy('pokemon_habitat', 'name')
 880 Pokemon.items = relation(PokemonItem, backref='pokemon')
 881 Pokemon.generation = relation(Generation, backref='pokemon')
 882 Pokemon.shape = relation(PokemonShape, backref='pokemon')
 883 Pokemon.stats = relation(PokemonStat, backref='pokemon')
 884 Pokemon.types = relation(Type, secondary=PokemonType.__table__, order_by=PokemonType.slot.asc())
 885
 886 PokemonDexNumber.pokedex = relation(Pokedex)
 887
 888 PokemonEvolution.from_pokemon = relation(Pokemon,
 889     primaryjoin=PokemonEvolution.from_pokemon_id==Pokemon.id,
 890     backref='child_evolutions',
 891 )
 892 PokemonEvolution.to_pokemon = relation(Pokemon,
 893     primaryjoin=PokemonEvolution.to_pokemon_id==Pokemon.id,
 894     backref=backref('parent_evolution', uselist=False),
 895 )
 896 PokemonEvolution.child_evolutions = relation(PokemonEvolution,
 897     primaryjoin=PokemonEvolution.from_pokemon_id==PokemonEvolution.to_pokemon_id,
 898     foreign_keys=[PokemonEvolution.to_pokemon_id],
 899     backref=backref('parent_evolution',
 900         remote_side=[PokemonEvolution.from_pokemon_id],
 901         uselist=False,
 902     ),
 903 )
 904 PokemonEvolution.trigger = relation(EvolutionTrigger, backref='evolutions')
 905 PokemonEvolution.trigger_item = relation(Item,
 906     primaryjoin=PokemonEvolution.trigger_item_id==Item.id,
 907     backref='triggered_evolutions',
 908 )
 909 PokemonEvolution.held_item = relation(Item,
 910     primaryjoin=PokemonEvolution.held_item_id==Item.id,
 911     backref='required_for_evolutions',
 912 )
 913 PokemonEvolution.location = relation(Location, backref='triggered_evolutions')
 914 PokemonEvolution.known_move = relation(Move, backref='triggered_evolutions')
 915 PokemonEvolution.party_pokemon = relation(Pokemon,
 916     primaryjoin=PokemonEvolution.party_pokemon_id==Pokemon.id,
 917     backref='triggered_evolutions',
 918 )
 919
 920 PokemonFlavorText.version = relation(Version)
 921
 922 PokemonItem.item = relation(Item, backref='pokemon')
 923 PokemonItem.version = relation(Version)
 924
 925 PokemonFormGroup.pokemon = relation(Pokemon, backref=backref('form_group',
 926                                                              uselist=False))
 927 PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
 928 PokemonFormSprite.introduced_in = relation(VersionGroup)
 929
 930 PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
 931 PokemonMove.version_group = relation(VersionGroup)
 932 PokemonMove.machine = relation(Machine, backref='pokemon_moves',
 933                                primaryjoin=and_(Machine.version_group_id==PokemonMove.version_group_id,
 934                                                 Machine.move_id==PokemonMove.move_id),
 935                                 foreign_keys=[Machine.version_group_id, Machine.move_id],
 936                                 uselist=False)
 937 PokemonMove.move = relation(Move, backref='pokemon_moves')
 938 PokemonMove.method = relation(PokemonMoveMethod)
 939
 940 PokemonName.language = relation(Language)
 941
 942 PokemonStat.stat = relation(Stat)
 943
 944 # This is technically a has-many; Generation.main_region_id -> Region.id
 945 Region.generation = relation(Generation, uselist=False)
 946 Region.version_group_regions = relation(VersionGroupRegion, backref='region',
 947                                         order_by='VersionGroupRegion.version_group_id')
 948 Region.version_groups = association_proxy('version_group_regions', 'version_group')
 949
 950 Stat.damage_class = relation(MoveDamageClass, backref='stats')
 951
 952 SuperContestCombo.first = relation(Move, primaryjoin=SuperContestCombo.first_move_id==Move.id,
 953                                         backref='super_contest_combo_first')
 954 SuperContestCombo.second = relation(Move, primaryjoin=SuperContestCombo.second_move_id==Move.id,
 955                                          backref='super_contest_combo_second')
 956
 957 Type.damage_efficacies = relation(TypeEfficacy,
 958                                   primaryjoin=Type.id
 959                                       ==TypeEfficacy.damage_type_id,
 960                                   backref='damage_type')
 961 Type.target_efficacies = relation(TypeEfficacy,
 962                                   primaryjoin=Type.id
 963                                       ==TypeEfficacy.target_type_id,
 964                                   backref='target_type')
 965
 966 Type.generation = relation(Generation, backref='types')
 967 Type.damage_class = relation(MoveDamageClass, backref='types')
 968 Type.foreign_names = relation(TypeName, backref='type')
 969
 970 TypeName.language = relation(Language)
 971
 972 Version.version_group = relation(VersionGroup, backref='versions')
 973 Version.generation = association_proxy('version_group', 'generation')
 974
 975 VersionGroup.generation = relation(Generation, backref='version_groups')
 976 VersionGroup.version_group_regions = relation(VersionGroupRegion, backref='version_group')
 977 VersionGroup.regions = association_proxy('version_group_regions', 'region')