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