Making a Pokemon Card Database

[EDIT] This format is now deprecated.

This format will no longer be updated because I switched to TCGPlayer, a free app that can scan your cards and show how much they are worth. But if you want to use this old format for whatever reason, read on:

A while ago, I was making a Pokémon card 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 ↩︎