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