board

Tables (4)

Board (게시판)

  • board_id (Key) — Primary key — NOT NULL
  • user_id (작성자 아이디) — Foreign key → User.user_id — NOT NULL
  • game_id (게임 아이디) — Foreign key → Games.game_id — NOT NULL
  • title (제목)
  • content (내용)
  • c_date (작성일)
  • m_date (수정일)
  • likes (좋아요)
  • views (조회수)

Comment (댓글)

  • comment_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • board_id (Key3) — Foreign key → Board.board_id — NOT NULL
  • comment (댓글)
  • c_date (작성일)
  • m_date (수정일)

Games (게임들)

  • game_id (Key) — Primary key — NOT NULL

User (회원)

  • user_id (Key) — Primary key — NOT NULL