ToyProject

Tables (9)

Board (모집글)

  • boardId (게시글 고유식별자) — Primary key — NOT NULL
  • memberId (회원 고유식별자) — Long — Foreign key → Member.memberId — NOT NULL
  • title (제목)
  • destination (내용)
  • destination (목적지)
  • startDate (여행 시작일)
  • endDate (여행 종료일)
  • maxParticipants (모집 인원)
  • viewCount (조회수)
  • likeCount (좋아요수)
  • createAt (작성일)
  • isClosed (마감여부)

Chat (채팅(몽고))

  • chatId (채팅 고유식별자) — Primary key — NOT NULL
  • message (메시지)
  • sender (보낸사람)
  • creatAt (작성일)
  • roomId (채팅방 id)

ChatRoom (채팅방)

  • chatRoomId (채팅방 고유식별자) — Primary key — NOT NULL
  • name (채팅방이름)

Comment (댓글)

  • commentId (댓글 고유식별자) — Primary key — NOT NULL
  • boardId (게시글 고유식별자) — Foreign key → Board.boardId — NOT NULL
  • memberId (회원 고유식별자) — Long — Foreign key → Member.memberId — NOT NULL
  • description (댓글 내용)
  • createAt (작성일)

MeberChatRoom (유저-채팅방 연결테이블)

  • Key — Primary key — NOT NULL
  • chatRoomId (채팅방 고유식별자) — Foreign key → ChatRoom.chatRoomId — NOT NULL
  • memberId (회원 고유식별자) — Long — Foreign key → Member.memberId — NOT NULL
  • boardId (게시글 고유식별자)

Member (회원)

  • memberId (회원 고유식별자) — Long — Primary key — NOT NULL
  • nickname (닉네임) — String
  • email (회원 이메일) — String
  • password (회원 비밀번호) — String
  • profileImg (프로필사진)
  • status (탈퇴여부) — boolean
  • socialId (소셜 식별자) — String
  • creatAt (생성일자) — LocalDateTime
  • updateAt (수정일자) — LocalDateTime

Tag (태그)

  • tagId (태그 고유식별자) — Primary key — NOT NULL
  • tagName (태그명)

TagList (게시글 태그 연결테이블)

  • tagListId (태그 리스트 고유식별자) — Primary key — NOT NULL
  • boardId (게시글 고유식별자) — Foreign key → Board.boardId — NOT NULL
  • tagId (태그 고유식별자) — Foreign key → Tag.tagId — NOT NULL

like (좋아요)

  • likeId (좋아요 고유식별자) — Primary key — NOT NULL
  • memberId (회원 고유식별자) — Long — Foreign key → Member.memberId — NOT NULL
  • boardId (게시글 고유식별자) — Foreign key → Board.boardId — NOT NULL