KBO community
Tables (6)
BOARD (게시판)
- board_id (게시글고유번호) — INT — Primary key
- title (제목)
- content (내용)
- reg_date (작성일지)
- user_id (회원고유번호) — INT — Foreign key → User.user_id
- like_count (추천수) — INT
BoardLike (게시글추천)
- like_id (추천고유번호) — INT — Primary key
- like_date (추천일시)
- board_id (게시글고유번호) — INT — Foreign key → BOARD.board_id
Comment (댓글)
- comment_id (댓글고유번호) — INT — Primary key
- content (댓글내용)
- reg_date (작성일지)
- user_id (회원고유번호) — INT — Foreign key → User.user_id
- board_id (게시글고유번호) — INT — Foreign key → BOARD.board_id
Player (선수)
- player_id (선수고유번호) — INT — Primary key — NOT NULL
- player_name (선수이름)
- team_name (소속구단)
- position (포지션)
- vote_count (득표수) — INT — NOT NULL
User (회원)
- user_id (회원고유번호) — INT — Primary key
- login_id (아이디)
- password (비밀번호)
- nickname (닉네임)
- favorite_team (선호구단)
VoteHistory (투표기록)
- vote_id (투표고유번호) — INT — Primary key
- vote_date (투표일시)
- user_id (회원고유번호) — INT — Foreign key → User.user_id
- player_id (선수고유번호) — INT — Foreign key → Player.player_id — NOT NULL