keyboard arena

Tables (6)

Board (board)

  • board_id — VARCHAR(40) — Primary key — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • title — VARCHAR(40) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • board_type — INT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • board_rank — INT — NOT NULL
  • likes — INT — NOT NULL
  • if_active — BOOLEAN — NOT NULL
  • views — INT — NOT NULL
  • comments — INT — NOT NULL

Comment (comment_board)

  • comment_id — VARCHAR(32) — Primary key — NOT NULL
  • board_id — VARCHAR(40) — Foreign key → Board.board_id — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • content — VARCHAR(100)
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • nickname — VARCHAR(30)

IP (visit)

  • ip — VARCHAR(40) — Primary key — NOT NULL
  • board_id — VARCHAR(40) — Foreign key → Board.board_id — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL

Like (like_board)

  • board_id — VARCHAR(20) — Foreign key → Board.board_id — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • ifLike (if_like) — BIT(1) — NOT NULL

User (user)

  • id — VARCHAR(20) — Primary key — NOT NULL
  • user_id — VARCHAR(20) — NOT NULL
  • password — VARCHAR(60) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • user_rank — INT — NOT NULL
  • point — INT — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • find_pw — VARCHAR(30) — NOT NULL
  • find_pw_question — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — NOT NULL

user_cleared_board

  • board_id — VARCHAR(40) — Foreign key → Board.board_id — NOT NULL
  • id — VARCHAR(20) — Foreign key → User.id — NOT NULL
  • clear_time — time
  • tries — int — NOT NULL
  • start_time — TIMESTAMP — NOT NULL