practice

테이블 (6)

Copy Of Untitled (Weapon)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (player_id) — int — 외래 키 → Player.Key — NOT NULL
  • Field (weapon_name) — varchar(20)
  • Field (weapon_type) — varchar(20)
  • Field (power) — int

Player

  • Key (player_id) — int — 기본 키 — NOT NULL
  • Field (player_name) — varchar(15)
  • Field (player_hp) — int
  • Field (player_mp) — int

Untitled (Tag)

  • Key (tag_id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(30)

Untitled (Post_Tag)

  • 기본키 (post_id) — int — 외래 키 → 게시글.기본키 — NOT NULL
  • Key (tag_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Class)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (class_name) — varchar(20)

게시글 (Post)

  • 기본키 (post_id) — int — 기본 키 — NOT NULL
  • Field (title) — varchar(30)
  • Field (contents) — varchar(10000)
  • Field (writer) — varchar(20)
  • Field (view) — int
  • Field (createAt) — date
  • Field (updateAt) — date