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 (픽업 여부)