포켓몬 트레이너 시뮬레이션

테이블 (4)

Background (background)

  • ID (id) — int — 외래 키 → Trainer.ID — NOT NULL
  • City (city) — varchar(30)
  • Bonus (bonus) — int

Pokemon (pokemon)

  • ID (id) — int — 기본 키 — NOT NULL
  • ID (id2) — int — 외래 키 → Trainer_Pokemons.ID — NOT NULL
  • Name (name) — varchar(30)
  • Type (type) — varchar(30)
  • Status (status) — int
  • HP (hp) — int

Trainer (trainer)

  • ID (id) — int — 기본 키 — NOT NULL
  • Name (name) — varchar(30)
  • Background (background) — varchar(30)

Trainer_Pokemons (trainer_pokemons)

  • ID (id) — int — 외래 키 → Trainer.ID — NOT NULL
  • Name (name) — varchar(30)