Final Project

Tables (7)

division_info (Untitled6)

  • division_id (등급번호) — int — Primary key — NOT NULL
  • division_name (등급명) — varchar(100)

gamer_match_info (Untitled7)

  • ouid (감독 고유아이디) — varchar(100) — Primary key — NOT NULL
  • gamer_nickname (감독명2) — varchar(100) — Foreign key → team_color_info.gamer_nickname — NOT NULL
  • match_id (매치번호) — varchar(100)
  • match_time (매치시간) — Datetime

match_info (Untitled3)

  • match_id (매치 고유 번호) — varchar(50) — Primary key — NOT NULL
  • season_id (시즌_id) — int — Foreign key → season_info.season_id — NOT NULL
  • spid (선수 시즌 정보가 포함된 ID2) — int — Foreign key → player_image_info.spid — NOT NULL
  • gamer_id (플래이어 ID) — int
  • spGrade (선수 강화 레벨) — int
  • matchResult (매치결과) — varchar(10)

player_image_info (Untitled5)

  • spid (선수 시즌 정보가 포함된 ID) — int — Primary key — NOT NULL
  • pid (선수 고유 ID) — int
  • url (선수 image 저장 장소) — varchar(255)

ranking_info (Untitled)

  • ranking (순위) — int — Primary key — NOT NULL
  • created_at (랭킹조회 시간) — DATETIME — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • division_id (등급번호) — int — Foreign key → division_info.division_id — NOT NULL
  • gamer_nickname (감독명) — varchar(100) — Foreign key → team_color_info.gamer_nickname — NOT NULL
  • level (게이머_레벨) — int
  • team_worth (팀가치) — bigint
  • points (승점) — decimal(10,2)
  • winning_rate (승률) — decimal(10,2)
  • total_win (승리수) — int
  • total_draw (무승부수) — int
  • total_lose (패배수) — int
  • formation (포매이션) — varchar(50)
  • match_id (매치 고유 번호) — varchar(50)

season_info (Untitled4)

  • season_id (시즌_id) — int — Primary key — NOT NULL
  • name (시즌명) — varchar(100)
  • image_url (시즌 아이콘 사진_url) — varchar(200)

team_color_info (Untitled2)

  • gamer_nickname (감독명) — varchar(100) — Primary key — NOT NULL
  • team_color (랭킹사이트에 있는 팀컬러) — Primary key — NOT NULL
  • created_at (데이터 입력시간) — Datetime
  • updated_at (정보 변경시간) — Datetime
  • member_no (인원수) — int
  • Field