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 (탈퇴여부)