moin_ERD

Tables (24)

Address (주소)

  • id (주소id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • city (시/도) — VARCHAR(20) — NOT NULL
  • district (행정구역) — VARCHAR(20)
  • street (동) — VARCHAR(255) — NOT NULL

ChatImage (채팅이미지)

  • id (사진id) — BIGINT — Primary key — NOT NULL
  • id (채팅메시지id) — BIGINT — Foreign key → chat_message.id — NOT NULL
  • (채팅방id) — Foreign key → chat_message.chat_room_id — NOT NULL
  • (크루원id) — Foreign key → chat_message.크루원id — NOT NULL
  • (회원id) — Foreign key → chat_message.회원id — NOT NULL
  • (크루id) — BIGINT — Foreign key → chat_message.crew_id — NOT NULL
  • (크루장id) — Foreign key → chat_message.크루장id — NOT NULL
  • id (채팅방id2) — BIGINT — Foreign key → chat_message.id — NOT NULL
  • id (크루id2) — BIGINT — Foreign key → chat_message.id — NOT NULL
  • leader_id (크루장id2) — BIGINT — Foreign key → chat_message.leader_id — NOT NULL

Crew_Favorite (크루 찜하기)

  • id (찜id) — BIGINT — Primary key — NOT NULL
  • id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → crew.leader_id — NOT NULL

category (카테고리)

  • id (카테고리id) — BUGINT — Primary key — NOT NULL
  • id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • (크루장id) — Foreign key → crew.leader_id — NOT NULL
  • categoryTpye (관심 카테고리) — ENUM — NOT NULL

chat_Participant (채팅방 참여자)

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id (채팅방id) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • id (크루원id) — BIGINT — Foreign key → crew_member.id — NOT NULL
  • (회원id) — Foreign key → crew_member.user_id — NOT NULL
  • (크루id) — Foreign key → crew_member.crew_id — NOT NULL
  • (크루장id) — Foreign key → crew_member.크루장id — NOT NULL
  • id (채팅방id2) — BIGINT — Foreign key → crew_member.chat_room_id — NOT NULL
  • id (크루id2) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • leader_id (크루장id2) — BIGINT — Foreign key → chat_room.크루장id — NOT NULL
  • last_read_chat_id (마지막 읽은 메시지id) — BIGINT
  • start_message_id (입장 시점의 메시지id) — BIGINT
  • chatparticipantstatus (채팅방참여상태) — ENUM

chat_message (채팅 메시지)

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id (채팅방id) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • (크루원id) — Foreign key → crew_member.id — NOT NULL
  • (회원id) — Foreign key → crew_member.user_id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew_member.crew_id — NOT NULL
  • (크루장id) — Foreign key → crew_member.크루장id — NOT NULL
  • id (채팅방id2) — BIGINT — Foreign key → crew_member.chat_room_id — NOT NULL
  • id (크루id2) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • leader_id (크루장id2) — BIGINT — Foreign key → chat_room.크루장id — NOT NULL
  • content (메시지 내용) — TEXT
  • message_type (메시지유형) — VARCHAR(20) — NOT NULL
  • DelYn (삭제 여부) — TEXT — NOT NULL
  • deleted_at (삭제일) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • imageUrls (이미지urls) — VARCHAR(500)

chat_room (채팅방)

  • id (채팅방id) — BIGINT — Primary key — NOT NULL
  • id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • (크루장id) — Foreign key → crew.leader_id — NOT NULL
  • name (채팅방이름)
  • created_at (생성일) — DATETIME — NOT NULL
  • isGroupChat (채팅방유형)

comment (댓글)

  • id (댓글id) — BIGINT — Primary key — NOT NULL
  • id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • id (회원id) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • id (크루id) — BIGINT — Foreign key → feed.crew_id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → feed.크루장id — NOT NULL
  • id (회원id2) — BIGINT — Foreign key → user.id — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (작성일) — DATETIME — NOT NULL

comment_like (댓글좋아요)

  • id (댓글좋아요id) — BIGINT — Primary key — NOT NULL
  • id (댓글id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (회원id3) — BIGINT — Foreign key → user.id — NOT NULL
  • id (피드id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (회원id) — BIGINT — Foreign key → comment.id — NOT NULL
  • id (크루id) — BIGINT — Foreign key → comment.id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → comment.leader_id — NOT NULL
  • id (회원id2) — BIGINT — Foreign key → comment.id — NOT NULL

crew (크루)

  • id (크루id) — BIGINT — Primary key — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → user.id — NOT NULL
  • name (크루명) — VARCHAR(100) — NOT NULL
  • region (지역) — VARCHAR(50)
  • district (행정구역) — VARCHAR(50)
  • description (크루소개) — TEXT — NOT NULL
  • crew_image (Field) — VARCHAR(255)
  • currentmembercount (현재인원수) — int
  • maxMembers (크루정원) — int — NOT NULL
  • created_at (생성일자) — DATE_TIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • role (권한) — ENUM — NOT NULL
  • favorite_count (찜갯수) — int — NOT NULL
  • delyn (삭제여부) — text — NOT NULL
  • categorytype (카테고리) — ENUM — NOT NULL
  • viewcount (조회수) — LONG — NOT NULL
  • ratingavg (크루평점) — BIGDECIMAL
  • ratingcount (평가갯수) — LONG
  • ratingtotal (평점합) — BIGDECIMAL

crew_member (크루 맴버)

  • id (크루원id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • (크루장id) — Foreign key → crew.leader_id — NOT NULL
  • chat_room_id (채팅방id) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • id (크루id2) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • leader_id (크루장id2) — BIGINT — Foreign key → chat_room.크루장id — NOT NULL
  • crewrole (권한) — ENUM — NOT NULL
  • join_at (가입일) — DATETIME
  • crewmemberstatus (가임상태) — ENUM — NOT NULL
  • joinmessage (가입메세지) — VARCHAR(255)
  • crewrating (크루원평가) — BIGDECIMAL

feeLog (회비장부)

  • id (회비id) — BIGINT — Primary key — NOT NULL
  • meetingId (모임id) — BIGINT — Foreign key → meeting.id — NOT NULL
  • creator_id (생성자id) — BIGINT — Foreign key → meeting.creator_id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → meeting.crew_id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → meeting.leader_id — NOT NULL
  • email (유저이메일) — VARCHAR(100) — NOT NULL
  • amount (결제금액) — BIGINT
  • createdTume (결제 시간) — LocalDateTime — NOT NULL
  • status (결제상태) — ENUM — NOT NULL

feed (피드)

  • id (피드id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → crew.leader_id — NOT NULL
  • content (게시글) — TEXT
  • create_time (생성일)

feed_image (피드사진)

  • id (이미지id) — BIGINT — Primary key — NOT NULL
  • feed_id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • (회원id) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • (크루id) — BIGINT — Foreign key → feed.crew_id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → feed.크루장id — NOT NULL
  • image_url (이미지url) — VARCHAR(500)
  • sequence (사진정렬) — INT

feed_like (피드좋아요)

  • id (좋아요id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
  • (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → crew.leader_id — NOT NULL
  • id (피드id) — BIGINT — Foreign key → feed.id — NOT NULL
  • (회원id2) — BIGINT — Foreign key → feed.user_id — NOT NULL
  • (크루id2) — BIGINT — Foreign key → feed.crew_id — NOT NULL
  • (크루장id2) — BIGINT — Foreign key → feed.크루장id — NOT NULL
  • create_time (생성시간) — LOCALDATE

manner_log (매너로그)

  • id (매너id) — BIGINT — Primary key — NOT NULL
  • evaluator_id (평가자id) — BIGINT — Foreign key → user.id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • target_user_id (피평가자id) — BIGINT — Foreign key → crew.leader_id — NOT NULL
  • meeting_id (모임id) — BIGINT — Foreign key → meeting.id — NOT NULL
  • (생성자id) — BIGINT — Foreign key → meeting.creator_id — NOT NULL
  • (크루id2) — BIGINT — Foreign key → meeting.crew_id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → meeting.leader_id — NOT NULL
  • score_delta (변화량) — DECIMAL — NOT NULL
  • type (평가타입) — VARCHAR(50)
  • created_time (생성일) — DATETIME

meeting (모임)

  • id (모임id) — BIGINT — Primary key — NOT NULL
  • creator_id (생성자id) — BIGINT — Foreign key → user.id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → crew.id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → crew.leader_id — NOT NULL
  • name (모임명) — VARCHAR(100) — NOT NULL
  • description (설명) — VARCHAR(255)
  • max_people (최대정원) — int — NOT NULL
  • current_people (현재인원) — int — NOT NULL
  • meetingDate (일정) — DATETIME — NOT NULL
  • place (장소) — VARCHAR(100) — NOT NULL
  • status (모집상태) — ENUM — NOT NULL
  • created_at (생성일자) — DATE_TIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • fee (회비) — int — NOT NULL
  • feeType (유료/무료) — EUNM — NOT NULL
  • totalFeePool (총모인금액) — BIGINT
  • bankName (은행명) — VARCHAR(100)
  • accountNumber (계좌번호) — VARCHAR(100)
  • accountHolder (예금주) — VARCHAR(100)
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE
  • issettled (환불여부) — BOOLEAN

meeting_member (모임 맴버)

  • id (모임원id) — BIGINT — Primary key — NOT NULL
  • meeting_id (모임id) — BIGINT — Foreign key → meeting.id — NOT NULL
  • (생성자id) — BIGINT — Foreign key → meeting.creator_id — NOT NULL
  • user_id (회원id3) — BIGINT — Foreign key → user.id — NOT NULL
  • id (크루id) — BIGINT — Foreign key → meeting.crew_id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → meeting.leader_id — NOT NULL
  • status (참여상태) — VARCHAR(20) — NOT NULL
  • joined_at (신청일) — DATETIME — NOT NULL
  • meetingrole (권한) — ENUM — NOT NULL
  • joinmessege (참여인사) — VARCHAR(100)
  • merchantuid (주문번호) — VARCHAR(100)
  • impuid (결제번호) — VARCHAR(100)
  • refundreason (환불사유) — VARCHAR(100)

message_read_status (메시지 읽음)

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id (채팅방id) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • (id2) — Foreign key → chat_message.id — NOT NULL
  • (채팅방id2) — Foreign key → chat_message.chat_room_id — NOT NULL
  • id (크루원id) — BIGINT — Foreign key → chat_message.크루원id — NOT NULL
  • (회원id) — Foreign key → chat_message.회원id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → chat_message.crew_id — NOT NULL
  • (크루장id) — Foreign key → chat_message.크루장id — NOT NULL
  • id (크루원id2) — BIGINT — Foreign key → crew_member.id — NOT NULL
  • user_id (회원id2) — BIGINT — Foreign key → crew_member.user_id — NOT NULL
  • crew_id (크루id2) — BIGINT — Foreign key → crew_member.crew_id — NOT NULL
  • leader_id (크루장id2) — BIGINT — Foreign key → crew_member.크루장id — NOT NULL
  • id (채팅방id3) — BIGINT — Foreign key → crew_member.chat_room_id — NOT NULL
  • id (크루id3) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • leader_id (크루장id3) — BIGINT — Foreign key → chat_room.크루장id — NOT NULL
  • isRead (읽음여부) — NOT NULL

notification (알림)

  • id (알림id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id2) — BIGINT — Foreign key → user.id — NOT NULL
  • type (알림유형) — VARCHAR(30) — NOT NULL
  • message (내용) — VARCHAR(255) — NOT NULL
  • is_read (읽음여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • reference_type (대상유형) — VARCHAR(20) — NOT NULL
  • reference_id (대상id) — BIGINT — NOT NULL

reFundLog (환불장부)

  • id (환불id) — BIGINT — Primary key — NOT NULL
  • meetingMemberId (모임원id) — BIGINT — Foreign key → meeting_member.id — NOT NULL
  • meeting_id (모임id) — BIGINT — Foreign key → meeting_member.meeting_id — NOT NULL
  • (생성자id) — BIGINT — Foreign key → meeting_member.생성자id — NOT NULL
  • user_id (회원id3) — BIGINT — Foreign key → meeting_member.user_id — NOT NULL
  • id (크루id) — BIGINT — Foreign key → meeting_member.id — NOT NULL
  • (크루장id) — BIGINT — Foreign key → meeting_member.크루장id — NOT NULL
  • imp_uid (포트원결제고유번호) — VARCHAR(100) — NOT NULL
  • amount (환불금액) — BIGINT
  • status (승인상태) — ENUM
  • refund_type (정산상태) — ENUM
  • refundreason (환불사유) — VARCHAR(100)

report (신고)

  • id (신고id) — BIGINT — Primary key — NOT NULL
  • user_id (회원id2) — BIGINT — Foreign key → user.id — NOT NULL
  • target_id (대상id) — BIGINT — NOT NULL
  • create_at (신고일) — DATETIME — NOT NULL
  • target_type (신고유형) — enum — NOT NULL
  • reason_type (신고사유타입) — enum — NOT NULL
  • reason_text (신고사유텍스트) — VARCHAR(255)
  • status (신고상태) — enum — NOT NULL

settlementLog (정산로그)

  • id (정산id) — BIGINT — Primary key — NOT NULL
  • host_id (정산받을id) — BIGINT — Foreign key → user.id — NOT NULL
  • meeting_id (모임id) — BIGINT — Foreign key → meeting.id — NOT NULL
  • creator_id (생성자id) — BIGINT — Foreign key → meeting.creator_id — NOT NULL
  • crew_id (크루id) — BIGINT — Foreign key → meeting.crew_id — NOT NULL
  • leader_id (크루장id) — BIGINT — Foreign key → meeting.leader_id — NOT NULL
  • amount (정산금액) — BIGINT — NOT NULL
  • isSettled (정산승인) — ENUM — NOT NULL
  • bankName (보낸 은행) — VARCHAR(100) — NOT NULL
  • accountNumber (보낸계좌) — VARCHAR(100) — NOT NULL

user (회원)

  • id (회원id) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • nickName (닉네임) — VARCHAR(50) — NOT NULL
  • profile_image (프로필이미지) — VARCHAR(255)
  • role (권한) — ENUM — NOT NULL
  • provider (로그인유형) — ENUM — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME
  • manner_score (매너 지수) — DECIMAL — NOT NULL
  • del_yn (삭제여부) — NOT NULL
  • provider_id (소셜id) — BIGINT — NOT NULL
  • gender (성별) — ENUM — NOT NULL
  • mbti — ENUM — NOT NULL
  • birthDate (생년월일) — LocalDate — NOT NULL