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