Test

테이블 (3)

게시판 (board)

  • Key (id) — uint — 기본 키 — NOT NULL
  • Key (user_id) — uint — 외래 키 → 회원.Key — NOT NULL
  • Field (title) — vchar(256) — NOT NULL
  • Field (body) — text(65535) — NOT NULL
  • Field2 (create_at) — tiemstamp — NOT NULL

댓글 (comment)

  • Key (id) — uint — 기본 키 — NOT NULL
  • Key (board_id) — uint — 외래 키 → 게시판.Key — NOT NULL
  • Key (user_id) — uint — 외래 키 → 회원.Key — NOT NULL
  • Field (comment) — text(65535) — NOT NULL
  • Field2 (create_at) — timestamp — NOT NULL

회원 (user)

  • Key (id) — uint — 기본 키 — NOT NULL
  • Field (user_name) — vchar(64) — NOT NULL — login_id
  • Field (password) — char(64) — NOT NULL — SHA256
  • Field2 (nickname) — vchar(64) — NOT NULL
  • Field3 (profile_image) — vchar(128) — user/profile/2233.jpg
  • Field (role) — tiny int — NOT NULL — 0:admin, 1:normal
  • Field (create_at) — timestamp — NOT NULL