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