veekun / pokedex

more than you ever wanted to know about Pokémon
MIT License
1.44k stars 637 forks source link

No pokemon evolution relational table. #227

Closed ahester57 closed 5 years ago

ahester57 commented 6 years ago

In pokemon_evolutions, the id column does not match up with the species_id. And there is no pokemon_id column to filter with. Also evolution_chains only has id & baby_item_id. How are we supposed to find the evolutions?

magical commented 6 years ago

You're looking for pokemon_species.evolves_from_species_id. The pokemon_evolution tables only tells you how a pokemon evolves, not what it evolves from. I agree that this is a little weird.

ahester57 commented 6 years ago

Yea it is weird. I have the evolves from working, but evolves to using the same method gives me something wrong. e.g. Aipom evolves from None but evolves to metang. So I have to filter species with evolves_from_species_id.