board

Tables (4)

Board (게시판)

  • board_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL
  • title (Field)
  • wirter (Field2)
  • content (Field3)
  • member_id (Field4)
  • likes (Field5)
  • views (Field6)

Comments (댓글)

  • comment_id (Key) — Primary key — NOT NULL
  • board_id (Key2) — Foreign key → Board.board_id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL
  • text (Field)
  • Field2
  • Field3
  • Field4

Member (사용자)

  • member_id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • role (Field3)

MembmerBoardView (게시판 읽음)

  • member_board_view_id (Key) — Primary key — NOT NULL
  • board_id (Key2) — Foreign key → Board.board_id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL