meettify

Tables (26)

answer (문의글 답변)

  • answer_id (PK) — Long — Primary key — NOT NULL — PK
  • answer (답글 내용) — String
  • writer_email (작성자 이메일) — String
  • admin_id (답변한 관리자) — Long — Foreign key → members.member_id — NOT NULL
  • question_id (문의글) — Long — Foreign key → questions.question_id — NOT NULL

ban_members (차단유저)

  • id (Key) — Long — Primary key — NOT NULL
  • member_email (이메일) — String

cart_item (장바구니 상품들)

  • cart_item_id (PK) — Long — Primary key — NOT NULL
  • cart_count (주문갯수) — int
  • item_cart_status (ItemCartStatus) — ENUM
  • cart_id (장바구니) — Long — Foreign key → carts.cart_id — NOT NULL
  • item_id (상품) — Long — Foreign key → item.item_id — NOT NULL

carts (장바구니 정보)

  • cart_id (PK) — Long — Primary key — NOT NULL
  • cart_total_count (총 가격) — int
  • member_id (주문자) — Long — Foreign key → members.member_id — NOT NULL

chat_room (채팅방)

  • room_id (PK) — Long — Primary key — NOT NULL
  • room_name (방이름) — String
  • created_nick_name (생성자 닉네임) — String
  • invite_member_ids (방 멤버들의 id) — List<Long>
  • room_status (RoomStatus) — ENUM
  • meet_id (Long) — ????

comments (댓글)

  • comment_id (PK) — Long — Primary key — NOT NULL
  • comment (내용) — String
  • children (대댓글모음) — List<CommentEntity>
  • member_id (작성자) — Long — Foreign key → members.member_id — NOT NULL
  • parents_id (부모댓글) — Long — Foreign key → comments.comment_id — NOT NULL

communities (커뮤니티)

  • community_id (PK) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • images (이미지 리스트) — List<CommunitiImgEntity>
  • view_count (조회수) — int
  • member_id (생성자) — Long — Foreign key → members.member_id — NOT NULL

community_images (커뮤니티 이미지)

  • item_img_id (PK) — Long — Primary key — NOT NULL
  • upload_img_name (업로드 파일 이름 UUID로 변경) — String
  • original_img_name (원본 이미지 이름) — String
  • upload_img_url (s3 이미지 조회 경로) — String
  • community_id (커뮤니티) — Long — Foreign key → communities.community_id — NOT NULL

coupon (쿠폰)

  • coupon_id (PK) — Long — Primary key — NOT NULL
  • expiration_date (쿠폰의 만료일자) — LocalDateTime
  • sale_price (쿠폰 할인 금액) — Long
  • coupon_key (쿠폰 키) — String
  • event_id (관련이벤트) — Long — Foreign key → event.event_id — NOT NULL

event (이벤트)

  • event_id (PK) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • coupon_count (쿠폰 갯수) — int

iamport_payment (iamport결제)

  • iamport_payment_id (PK) — Long — Primary key — NOT NULL
  • payMethod (????) — String
  • impUid (???) — String
  • orderUid (주문번호) — String
  • count (??) — int
  • payPrice (주문금액) — int
  • member_id (주문자) — Long — Foreign key → members.member_id — NOT NULL

item (상품)

  • item_id (PK) — Long — Primary key — NOT NULL
  • item_name (이름) — String
  • item_price (가격) — int
  • item_details (설명) — String
  • item_status (ItemStatus) — ENUM
  • item_count (재고수량) — int
  • item_category (Category) — ENUM

item_images (상품 이미지들)

  • item_img_id (PK) — Long — Primary key — NOT NULL
  • upload_img_path (파일이 업로드될 경로) — String
  • upload_img_name (업로드 파일 이름 UUID로 변경) — String
  • original_img_name (원본 이미지 이름) — String
  • upload_img_url (s3 이미지 조회 경로) — String
  • item_id (상품) — Long — Foreign key → item.item_id — NOT NULL

meetBoardComments (모임 게시글 댓글)

  • comment_id (PK) — Long — Primary key — NOT NULL
  • content (내용) — String
  • postDate (작성날짜) — LocalDateTime
  • meetBoard_id (해당 게시글) — Long — Foreign key → meetBoards.meetBoard_id — NOT NULL
  • member_id (댓글 작성자) — Long — Foreign key → members.member_id — NOT NULL
  • parent_comment_id (부모댓글) — Long — Foreign key → meetBoardComments.comment_id — NOT NULL

meetBoardImages (게시글 이미지)

  • meetBoardImage_id (PK) — Long — Primary key — NOT NULL
  • meetBoardImage_oriFileName (기존 파일 이름) — String
  • meetBoardImage_uploadFileName (UUID 파일 이름) — String
  • meetBoardImage_uploadFilePath (파일 업로드 경로) — String
  • meetBoardImage_uploadFileUrl (S3 파일 url) — String
  • meetBoard_id (게시글) — Long — Foreign key → meetBoards.meetBoard_id — NOT NULL

meetBoards (모임 게시글)

  • meetBoard_id (PK) — Long — Primary key — NOT NULL
  • meetBoard_title (제목) — String
  • meetBoard_content (내용) — String
  • meetBoard_postDate (작성날짜) — LocalDateTime
  • member_id (작성자) — Long — Foreign key → members.member_id — NOT NULL
  • meet_id (모임) — Long — Foreign key → meets.meet_id — NOT NULL

meetMembers (모임멤버)

  • meetMember_id (PK) — Long — Primary key — NOT NULL
  • meetMember_role (MeetRole) — ENUM
  • member_id (멤버) — Long — Foreign key → members.member_id — NOT NULL
  • meet_id (모임) — Long — Foreign key → meets.meet_id — NOT NULL
  • joinDate (가입날짜) — LocalDateTime

meet_images (모임 이미지들)

  • meet_iamge_id (PK) — Long — Primary key — NOT NULL
  • meetImage_uploadFilePath (파일이 업로드될 경로) — String
  • meetImage_uploadFileName (업로드 파일 이름 UUID로 변경) — String
  • meetImage_oriFileName (원본 이미지 이름) — String
  • meetImage_uploadFileUrl (s3 이미지 조회 경로) — String
  • meet_id (모임) — Long — Foreign key → meets.meet_id — NOT NULL

meets (모임)

  • meet_id (PK) — Long — Primary key — NOT NULL
  • meet_name (이름) — String
  • meet_maximum (최대 인원) — Long
  • meet_location (모임장소) — String
  • meetCategory (Category) — ENUM

members (유저)

  • member_id (PK) — Long — Primary key — NOT NULL
  • member_name (이름) — String
  • member_email (이메일) — String
  • member_pw (비밀번호) — String
  • nick_name (닉네임) — String
  • member_role (UserRole) — Enum
  • provider (공급자?) — String
  • privider_id (공급자ID?) — String
  • member_addr_detail (상세주소) — String
  • member_zip_code (우편번호) — String
  • member_addr (주소) — String

notice (공지사항)

  • notice_id (PK) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • member_id (작성자) — Long — Foreign key → members.member_id — NOT NULL

notification (알림)

  • id (PK) — Long — Primary key — NOT NULL
  • message (메세지) — String
  • isRead (읽음여부) — boolean
  • member_id (PK2) — Long — Foreign key → members.member_id — NOT NULL

order_items (주문상품)

  • order_item_id (PK) — Long — Primary key — NOT NULL
  • item_id (상품) — Long — Foreign key → item.item_id — NOT NULL
  • order_id (주문) — Long — Foreign key → orders.order_id — NOT NULL
  • order_count (상품 주문 개수) — int
  • order_price (상품 주문 금액) — int

orders (주문)

  • order_id (PK) — Long — Primary key — NOT NULL
  • member_id (주문자) — Long — Foreign key → members.member_id — NOT NULL
  • memberAddr (주문자 주소) — String
  • memberAddrDetail (주문자 상세주소) — String
  • memberZipCode (우편번호) — String
  • totalPrice (주문 총 금액) — int
  • orderUUIDid (주문 랜덤 번호) — String
  • payStatus (PayStatus) — ENUM

questions (문의글)

  • question_id (PK) — Long — Primary key — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • member_id (작성자) — Long — Foreign key → members.member_id — NOT NULL
  • reply_status (ReplyStatus) — Enum

toss_payment (toss결제)

  • toss_payment_id (PK) — Long — Primary key — NOT NULL
  • pay_amount (주문금액) — Long
  • order_id (주문번호) — String
  • paymentKey (주문키) — String
  • reqeustedAt (요청일시) — offsetDateTime
  • approveAt (승인일시) — OffsetDateTime
  • orderUid (주문Uid) — String
  • member_id (PK2) — Long — Foreign key → members.member_id — NOT NULL