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