eco-sign-backend-db

Tables (19)

category (카테고리)

  • 카테고리ID (categoryId) — Primary key — NOT NULL
  • 카테고리 제목 (categoryTitle)

daily (데일리 미션)

  • 데일리미션ID (dailyId) — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 데일리 제목 (dailyTitle)
  • 데일리 상세 (dailyDescription)

dailyLike (미션 좋아요)

  • 데일리미션ID (dailyLikeId) — Foreign key → daily.데일리미션ID — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL

meeting (모임)

  • 모임ID (meetingId) — bigint — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL — 주최자
  • 카테고리ID (categoryId) — Foreign key → category.카테고리ID — NOT NULL
  • 모임 제목 (meetingTitle)
  • 모임 상세 (meetingDescription)
  • 모임 인원수 (meeting MaxMemberCount)

meetingAttend (모임 참가자)

  • 모임 참가자ID (attendId) — bigint — Primary key — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL

meetingChat (채팅)

  • 채팅ID (chatId) — Primary key — NOT NULL
  • 모임 참가자ID (attendId) — bigint — Foreign key → meetingAttend.모임 참가자ID — NOT NULL
  • 미팅룸 ID (roomId) — Foreign key → meetingRoom.미팅룸 ID — NOT NULL
  • 채팅 메시지 (chatMsg) — varchar

meetingComment (모임 댓글)

  • 댓글ID (commentId) — Primary key — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 댓글 내용 (commentDescription) — varchar

meetingHashtag (해쉬태그)

  • 해쉬태그ID (hashtagId) — Primary key — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
  • 해쉬태그 제목 (hashtagTitle) — varchar

meetingLike (모임 좋아요)

  • 좋아요ID (meetigLikeId) — Primary key — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL

meetingRoom (모임 성사(채팅))

  • 미팅룸 ID (roomId) — Primary key — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL
  • 모임 참가자ID (attendId) — bigint — Foreign key → meetingAttend.모임 참가자ID — NOT NULL

member (사용자)

  • 유저ID (memberId) — bigint — Primary key — NOT NULL
  • 유저 계정명 (memberEmail) — varchar
  • 유저 비밀번호 (memberPassword) — varchar
  • 유저 핸드폰번호 (memberPhoneNumber) — varchar — NOT NULL
  • 유저 마켓팅 (memberIsMarkettingAgree) — ENUM(Y,N)

memberLike (북마크)

  • 북마크ID (memberLikeId) — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 모임ID (meetingId) — bigint — Foreign key → meeting.모임ID — NOT NULL

notification (알림)

  • 알림ID (notificationId) — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 알림 유형 (notificationType)

post (커뮤니티)

  • 게시물ID (postId) — bigint — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 카테고리ID (categoryId) — Foreign key → category.카테고리ID — NOT NULL
  • 게시물 제목 (postTitle) — varchar
  • 게시물 상세 (postDescription)
  • 커뮤니티 이미지 (postImg)

postComment (커뮤니티 댓글)

  • 커뮤니티 댓글 ID (postCommentId) — Primary key — NOT NULL
  • 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL

postHashTag (커뮤니티 해쉬태그)

  • 커뮤니티 해쉬태그 ID (postHasgTagId) — Primary key — NOT NULL
  • 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
  • 커뮤니티 해쉬태그 제목 (postTitle)

postLike (커뮤니티 좋아요)

  • 커뮤니티 좋아요 ID (postLikeId) — Primary key — NOT NULL
  • 게시물ID (postId) — bigint — Foreign key → post.게시물ID — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL

profile (사용자 프로필)

  • 프로필ID (profileId) — bigint — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 유저 닉네임 (memberNickName) — varchar(8)
  • 유저 이미지 (memberImg) — varchar(256)

social (사용자 유형)

  • 유형ID (socialId) — bigint — Primary key — NOT NULL
  • 유저ID (memberId) — bigint — Foreign key → member.유저ID — NOT NULL
  • 유저 유형 (socialType) — bigint