Crawler
Tables (5)
CHAMPIONIMAGE (챔피언스킬 이미지)
- ID (순서) — BIGINT — Primary key — NOT NULL
- NAME (이름) — VARCHAR(200) — Foreign key → Champion.NAME — NOT NULL
- PIMAGE (Field) — VARCHAR(200)
- QIMAGE (Q) — VARCHAR(200)
- WIMAGE (W) — VARCHAR(200)
- EIMAGE (E) — VARCHAR(200)
- RIMAGE (R) — VARCHAR(200)
CHAMPIONTIER (챔피언티어)
- ID (순서) — BIGINT — Primary key — NOT NULL
- NAME (이름) — VARCHAR(200) — Foreign key → Champion.NAME — NOT NULL
- ID (순서2) — BIGINT — Foreign key → TYPE.ID — NOT NULL
- URL (상세정보) — VARCHAR(200)
- TIER (티어) — VARCHAR(200)
- WINNING (승률) — VARCHAR(200)
- PICKRATE (픽률) — VARCHAR(200)
- BANRATE (밴률) — VARCHAR(200)
COUNTERCHAMPION (카운터챔피언)
- ID (순서) — BIGINT — Primary key — NOT NULL
- NAME (이름) — VARCHAR(200) — Foreign key → Champion.NAME — NOT NULL
- COUNTER (카운터 챔피언 이름) — VARCHAR(200)
- COUNTERIMAGE (카운터 챔피언 이미지) — VARCHAR(200)
Champion (챔피언)
- NAME (이름) — VARCHAR(200) — Primary key — NOT NULL
- SKILLP (패시브) — VARCHAR(200)
- SKILLQ (Q) — VARCHAR(200)
- SKILLW (W) — VARCHAR(200)
- SKILLE (E) — VARCHAR(200)
- SKILLR (R) — VARCHAR(200)
- IMAGE (이미지 주소) — VARCHAR(200)
TYPE (라인)
- ID (순서) — BIGINT — Primary key — NOT NULL
- TYPENAME (라인) — VARCHAR(200)