board

Tables (7)

Board (게시판)

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

Comment (댓글)

  • CommentID (comment_id) — Primary key — NOT NULL
  • UserID (user_id) — Primary key — NOT NULL
  • PostID (post_id) — Primary key — NOT NULL
  • GuestBookID (guestbook_id) — Primary key — NOT NULL
  • CommentContent (댓글 내용) — Primary key — NOT NULL
  • Date (댓글 날짜) — Primary key — NOT NULL

Follow (팔로우)

  • FollowID (follow_id) — Primary key — NOT NULL
  • FollowerID (팔로워ID) — Primary key — NOT NULL
  • FollowingID (팔로윙ID) — Primary key — NOT NULL

GuestBook (방명록)

  • GuestbookID (guestbook_id) — Primary key — NOT NULL
  • UserID (user_id) — Primary key — NOT NULL
  • GBContent (방명록 내용) — Primary key — NOT NULL
  • Date (게시날짜) — Primary key — NOT NULL

Heart (하트)

  • HeartID (heart_id) — Primary key — NOT NULL
  • UserID (user_id) — Primary key — NOT NULL
  • PostID (post_id) — Primary key — NOT NULL
  • GuestbookID (guestbook_id) — Primary key — NOT NULL
  • Field

Post (게시글)

  • PostID (post_id) — Primary key — NOT NULL
  • UserID (user_id) — Primary key — NOT NULL
  • BoardID (board_id) — Primary key — NOT NULL
  • PostContent (게시글 내용) — Primary key — NOT NULL
  • Image (사진) — Primary key — NOT NULL
  • Date (게시날짜) — Primary key — NOT NULL
  • Count (조회수) — Primary key — NOT NULL

User (Untitled)

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