tft
Tables (7)
champion (챔피언)
- champ_id (챔피언아이디) — NN — Primary key
- name (챔피언이름) — NN
- cost (비용) — NN
- skill (스킬) — NN
- class (직업) — NN
combination (조합)
- combination_id (조합아이디) — NN — Primary key
- result_item_id (결과아이템아이디) — NN — Foreign key → item.item_id
- component1_id (재료아이템1아이디) — NN — Foreign key → item.item_id
- component2_id (재료아이템2아이디) — NN — Foreign key → item.item_id
comment (댓글)
- comment_id (댓글아이디) — NN — Primary key
- content (댓글내용)
- created_at (작성일) — NN
- user_id (아이디2) — NN — Foreign key → user.user_id
- post_id (글아이디2) — NN — Foreign key → post.post_id
guide (가이드)
- guide_id (가이드아이디) — NN — Primary key
- title (가이드제목) — NN
- description (설명) — NN
- rating (평점)
item (아이템)
- item_id (아이템아이디) — NN — Primary key
- name (아이템이름) — NN
- effect (효과) — NN
post (게시글)
- post_id (글아이디) — NN — Primary key
- title (글제목) — NN
- content (내용)
- created_at (작성일) — NN
- updated_at (수정일)
- user_id (아이디2) — NN — Foreign key → user.user_id
user (유저)
- user_id (아이디) — NN — Primary key
- username (이름) — NN
- password (비밀번호) — NN
- email (이메일)
- role (권한) — NN
- join_date (가입일) — NN