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 (승률)