BoardERD

Tables (7)

Board (게시판)

  • BoardID (board_id) — Primary key — NOT NULL
  • UserID (user_id) — Foreign key → User.UserID — NOT NULL
  • Description (게시판 설명)
  • Username (닉네임)

Comment (댓글)

  • CommentID (comment_id) — Primary key — NOT NULL
  • PostID (post_id) — Foreign key → Post.PostID — NOT NULL
  • UserID (user_id) — Foreign key → Post.UserID — NOT NULL
  • Del (삭제여부)

Follow (팔로우)

  • FollowID (follow_id) — Primary key — NOT NULL
  • BoardID (board_id) — Foreign key → Board.BoardID — NOT NULL
  • UserID (user_id) — Foreign key → Board.UserID — NOT NULL
  • FollowerID (팔로워ID)
  • FollowingID (팔로윙ID)

GuestBook (방명록)

  • GuestbookID (guestbook_id) — Primary key — NOT NULL
  • BoardID (board_id) — Foreign key → Board.BoardID — NOT NULL
  • UserID (user_id) — Foreign key → Board.UserID — NOT NULL
  • Content (방명록 내용)
  • Del (삭제여부)

Heart (하트)

  • HeartID (heart_id) — Primary key — NOT NULL
  • UserID (user_id) — Foreign key → Comment.UserID — NOT NULL
  • PostID (post_id) — Foreign key → Post.PostID — NOT NULL
  • GuestbookID (guestbook_id) — Foreign key → GuestBook.GuestbookID — NOT NULL

Post (게시글)

  • PostID (post_id) — Primary key — NOT NULL
  • BoardID (board_id) — Foreign key → Board.BoardID — NOT NULL
  • UserID (user_id) — Foreign key → Board.UserID — NOT NULL
  • PostContent (게시글 내용)
  • Image (사진)
  • Date (게시 날짜)
  • Count (조회수)
  • Del (삭제여부)

User (사용자)

  • UserID (user_id) — Primary key — NOT NULL
  • Username (닉네임)
  • Password (비밀번호)
  • ProfileImage (프로필 사진)
  • Email (email)
  • Del (탈퇴여부)