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)