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