dksl.gg
Tables (13)
champions
- name_en — VARCHAR(20) — Primary key — NOT NULL
- name_kr — VARCHAR(15) — NOT NULL
- image_url — VARCHAR(2083)
current_season_summaries
- puu_id — VARCHAR(78) — Primary key
- losses — INT — NOT NULL
- lp — INT — NOT NULL
- queue_id — INT — NOT NULL
- rank — INT — NOT NULL
- summoner_id — VARCHAR(47) — NOT NULL
- tier_name — VARCHAR(20) — NOT NULL
- wins — INT — NOT NULL
items
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- image_url — VARCHAR(2083)
lines
- name — VARCHAR(10) — Primary key
- image_url — VARCHAR(2083)
lol_profiles
- puu_id — VARCHAR(78) — Primary key — NOT NULL
- profile_icon_id — INT — NOT NULL
- region — VARCHAR(5) — NOT NULL
- summoner_id — VARCHAR(47) — NOT NULL
- summoner_level — INT — NOT NULL
- summoner_name — VARCHAR(20)
- last_updated_at — DATETIME
- updated_at — DATETIME
- created_at — DATETIME
match_histories
- id — INT — Primary key — NOT NULL
- level — INT — NOT NULL
- CS — INT — NOT NULL
- item_0_id — INT — NOT NULL
- item_1_id — INT — NOT NULL
- item_2_id — INT — NOT NULL
- item_3_id — INT — NOT NULL
- item_4_id — INT — NOT NULL
- item_5_id — INT — NOT NULL
- item_6_id — INT — NOT NULL
- spell_0_id — INT — NOT NULL
- spell_1_id — INT — NOT NULL
- rune_0_id — INT — NOT NULL
- rune_1_id — INT — NOT NULL
- season — VARCHAR(20) — NOT NULL
- gold — INT — NOT NULL
- play_duration — VARCHAR(40) — NOT NULL
- play_time — VARCHAR(40) — NOT NULL
- queue_type — INT — NOT NULL
- summoner_name — VARCHAR(20) — NOT NULL
- match_id — VARCHAR(100) — NOT NULL
- line_name — VARCHAR(20) — NOT NULL
- champion_name_en — VARCHAR(20) — NOT NULL
- kill — INT — NOT NULL
- death — INT — NOT NULL
- assist — INT — NOT NULL
- win_or_lose — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
most_champion_summaries
- id — INT — Primary key
- current_season_summary_id — VARCHAR(78)
- champion_name — VARCHAR(20)
- kda — DOUBLE
- win_rate — DOUBLE
- count — INT
most_line_summaries
- id — INT — Primary key
- current_season_summary_id — VARCHAR(78) — NOT NULL
- line_name — VARCHAR(20)
- kda — DOUBLE
- win_rate — DOUBLE
- count — INT
profile_icons
- id — INT — Primary key — NOT NULL
- image_url — VARCHAR(2083)
queues
- id — INT — Primary key — NOT NULL — PRIMARY KEY
- name_en — VARCHAR(20) — NOT NULL
- name_kr — VARCHAR(20) — NOT NULL
runes
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- image_url — VARCHAR(2083)
spells
- id — INT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- image_url — VARCHAR(2083)
tiers
- name_en — VARCHAR(20) — Primary key — NOT NULL
- name_kr — VARCHAR(20) — NOT NULL
- image_url — VARCHAR(2083)