project

Tables (3)

ChampionAnalysis (championAnalysis)

  • id (indexing) — int — Primary key — NOT NULL — auto increment
  • riot_id (소환사명) — String — Foreign key → User.riot_id — 가입 후 등록
  • season (시즌) — int — NOT NULL
  • win (이긴 판 수) — int — NOT NULL
  • lose (진 판 수) — int — NOT NULL
  • kill (평균 킬) — double — NOT NULL
  • death (평균 데스) — double — NOT NULL
  • assist (평균 어시) — double — NOT NULL
  • cs (평균 cs) — double — NOT NULL
  • gold (평균 gold) — int — NOT NULL
  • doubleKill (더블킬) — int — NOT NULL
  • tripleKill (트리플킬) — int — NOT NULL
  • quadraKill (쿼드라킬) — int — NOT NULL
  • pentaKill (펜타킬) — int — NOT NULL

User (user)

  • id (Key) — int — Primary key — NOT NULL — 자동생성
  • riot_id (소환사명) — String — Primary key — 가입 후 등록
  • pwd (password) — String — NOT NULL
  • rank (티어) — int — NOT NULL — -1이면 언랭
  • Field4
  • Field

community

  • id (key) — int — Primary key — NOT NULL — 자동생성
  • id (Key) — int — Foreign key → User.id — NOT NULL — 자동생성
  • riot_id (소환사명) — String — Foreign key → User.riot_id — 가입 후 등록
  • title (제목) — String — NOT NULL
  • champion (챔피언) — String
  • tier (티어) — int