ha-search

Tables (9)

build (아이템 빌드)

  • build_id (빌드 id) — Primary key — NOT NULL
  • champion_id (챔피언 id) — Foreign key → champion.champion_id — NOT NULL
  • item_id (아이템 id) — Foreign key → item.item_id — NOT NULL
  • item_id (아이템 id2) — Foreign key → item.item_id — NOT NULL
  • item_id (아이템 id3) — Foreign key → item.item_id — NOT NULL
  • winrate (승률)

champion (챔피언)

  • champion_id (챔피언 id) — Primary key — NOT NULL
  • name (이름)
  • image_path (이미지 경로)
  • tier (티어)
  • tip (팁)
  • winrate (승률)

comment (한줄평)

  • commen_id (코멘트 id) — Primary key — NOT NULL
  • member_id (멤버 id) — Foreign key → member.member_id — NOT NULL
  • champion_id (챔피언 id) — Foreign key → champion.champion_id — NOT NULL
  • content (내용)
  • like (좋아요)
  • version (버젼)
  • created_at (생성일)
  • modified_at (수정일)

item (아이템)

  • item_id (아이템 id) — Primary key — NOT NULL
  • name (이름)
  • image (이미지)
  • content (내용)
  • price (가격)

like (좋아요)

  • like_id (좋아요 id) — Primary key — NOT NULL
  • commen_id (코멘트 id) — Foreign key → comment.commen_id — NOT NULL
  • member_id (멤버 id) — Foreign key → member.member_id — NOT NULL
  • created_at (생성일)
  • modified_at (수정일)

member (멤버)

  • member_id (멤버 id) — Primary key — NOT NULL
  • name (유저 아이디)
  • password (패스워드)
  • nickname (닉네임)
  • created_at (가입일)
  • modified_at (수정일)

report (신고)

  • report_id (신고 id) — Primary key — NOT NULL
  • commen_id (코멘트 id) — Foreign key → comment.commen_id — NOT NULL
  • member_id (멤버 id) — Foreign key → member.member_id — NOT NULL
  • content (내용)
  • created_at (생성일)

skill (스킬)

  • skill_id (스킬 id) — Primary key — NOT NULL
  • champion_id (챔피언 id) — Foreign key → champion.champion_id — NOT NULL
  • name (이름)
  • image (이미지)
  • content (내용)

skilltree (스킬트리)

  • skilltree_id (스킬트리 id) — Primary key — NOT NULL
  • champion_id (챔피언 id) — Foreign key → champion.champion_id — NOT NULL
  • skill_id (스킬 id) — Foreign key → skill.skill_id — NOT NULL
  • skill_id (스킬 id2) — Foreign key → skill.skill_id — NOT NULL
  • skill_id (스킬 id3) — Foreign key → skill.skill_id — NOT NULL
  • winrate (승률)