pokemon

Tables (8)

Encyclopedia (Untitled5)

  • EncyclopediaID (도감ID) — Primary key — NOT NULL
  • USER ID (유저 id) — Foreign key → User.USER ID — NOT NULL
  • pokemonID (포켓몬 ID) — Foreign key → pokemon.pokemonID — NOT NULL
  • isownd (보유여부)
  • Field2
  • Field3

Favorite (Untitled4)

  • 즐겨찾기ID (Key) — Primary key — NOT NULL
  • pokemonID (포켓몬 ID) — Foreign key → pokemon.pokemonID — NOT NULL
  • USER ID (유저 id) — Foreign key → User.USER ID — NOT NULL

GachaPoolDetail (Untitled7)

  • GachaPoolDetailID (뽑기디테일ID) — Primary key — NOT NULL
  • pokemonID (포켓몬 ID) — Foreign key → pokemon.pokemonID — NOT NULL
  • Field
  • Field2
  • Field3

PickUpHistory (Untitled3)

  • Key — Primary key — NOT NULL
  • pokemonID (포켓몬 ID) — Foreign key → pokemon.pokemonID — NOT NULL
  • rate (확률)
  • Field2
  • Field3

User (Untitled)

  • USER ID (유저 id) — Primary key — NOT NULL
  • NAME (이름)
  • AGE (나이)
  • Field3
  • Coin (코인 개수)

gacha (Untitled6)

  • gacha_ID (뽑기아이디) — Primary key — NOT NULL
  • GachaPoolDetailID (뽑기디테일ID) — Foreign key → GachaPoolDetail.GachaPoolDetailID — NOT NULL
  • pokemonID (포켓몬 ID) — Foreign key → GachaPoolDetail.pokemonID — NOT NULL
  • name (뽑기명)
  • price (가격)
  • startDate (시작일)
  • EndDate (종료일)

gachaResult (Untitled8)

  • GachaResultId (뽑기결과아이디) — Primary key — NOT NULL
  • USER ID (유저 id) — Foreign key → User.USER ID — NOT NULL
  • gacha_ID (뽑기아이디) — Foreign key → gacha.gacha_ID — NOT NULL
  • gachaDate (뽑은 날짜)
  • Field2

pokemon (Untitled2)

  • pokemonID (포켓몬 ID) — Primary key — NOT NULL
  • name (포켓몬 이름)
  • type (타입)
  • rank (등급)
  • pickup (픽업 여부)