Making a Pokemon Card Database

A while ago, I was making a Pokémon deck and realized that I should make a database of all my Pokémon cards, so I created a database in MySQL to organize them. This is how the database is structured so far:

• Database PKMNCARDS
  • Table POKEMON
    • NAME (text)
    • TYPE (number¹)
    • STAGE (number²)
    • RETREAT (number)
    • HP (number)
    • CARDTYPE (number³)
  • Table ENERGY
    • TYPE (number¹)
    • NUM (number)

1. 0: Normal/Flying
   1: Grass
   2: Fire
   3: Water
   4: Atomic
   5: Psychic/Ghost/Poison
   6: Fighting/Rock/Ground
   7: Dark
   8: Steel
   9: Fairy
   10: Dragon ↩︎
2. 0: Basic
   1: Stage 1
   2: Stage 2 ↩︎
3. 0: Normal
   1: GX
   2: EX
   3: ex
   4: Tera ex ↩︎