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