1

Tables (27)

cart

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID (1:1)

cart_item

  • id — BIGINT — Primary key — NOT NULL
  • cart_id — BIGINT — Foreign key → cart.id — NOT NULL — 장바구니 ID
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — 상품 ID
  • quantity — INT — NOT NULL — 수량

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL — 채팅방 ID
  • sender_id — BIGINT — Foreign key → member.id — NOT NULL — 발신자 ID
  • message — TEXT — NOT NULL — 메시지 내용
  • type — VARCHAR(20) — NOT NULL — 타입 (TEXT/PRICE_OFFER/SYSTEM)
  • created_at — DATETIME — NOT NULL — 발신일시

chat_room

  • id — BIGINT — Primary key — NOT NULL
  • used_post_id — BIGINT — Foreign key → used_post.id — NOT NULL — 게시글 ID
  • seller_id — BIGINT — Foreign key → member.id — NOT NULL — 판매자 ID
  • buyer_id — BIGINT — Foreign key → member.id — NOT NULL — 구매자 ID
  • status — VARCHAR(20) — NOT NULL — 채팅방 상태 (OPEN/CLOSED)
  • created_at — DATETIME — NOT NULL — 생성일시

comment

  • id — BIGINT — Primary key — NOT NULL
  • community_post_id — BIGINT — Foreign key → community_post.id — NOT NULL — 게시글 ID
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • parent_id — BIGINT — Foreign key → comment.id — 부모 댓글 ID (대댓글용)
  • content — TEXT — NOT NULL — 내용
  • is_reported — TINYINT(1) — NOT NULL — 신고 여부 (0/1)
  • created_at — DATETIME — NOT NULL — 작성일시

community_post

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • title — VARCHAR(200) — NOT NULL — 제목
  • content — TEXT — NOT NULL — 내용
  • category — VARCHAR(50) — NOT NULL — 카테고리
  • img_url — VARCHAR(255) — 이미지 URL (S3)
  • view_count — INT — NOT NULL — 조회수
  • like_count — INT — NOT NULL — 좋아요 수
  • is_reported — TINYINT(1) — NOT NULL — 신고 여부 (0/1)
  • created_at — DATETIME — NOT NULL — 작성일시
  • updated_at — DATETIME — NOT NULL — 수정일시

diagnosis_history

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • pet_id — BIGINT — Foreign key → pet_profile.id — NOT NULL — 반려동물 ID
  • symptom_text — TEXT — 증상 텍스트
  • image_url — VARCHAR(255) — 증상 사진 URL (S3)
  • result_disease — TEXT — NOT NULL — 의심 질환
  • result_severity — VARCHAR(20) — NOT NULL — 심각도 (LOW/MEDIUM/HIGH)
  • result_recommend — TEXT — NOT NULL — 권고사항
  • created_at — DATETIME — NOT NULL — 진단일시

hospital

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 병원명
  • address — VARCHAR(255) — NOT NULL — 주소
  • latitude — DECIMAL(10, 7) — NOT NULL — 위도
  • longitude — DECIMAL(10, 7) — NOT NULL — 경도
  • phone — VARCHAR(20) — NOT NULL — 전화번호
  • opening_hours — VARCHAR(255) — NOT NULL — 영업시간
  • is_emergency — TINYINT(1) — NOT NULL — 24시 응급 여부 (0/1)
  • department — VARCHAR(255) — 진료과목 (콤마 구분)
  • rating — DECIMAL(3, 1) — 평균 평점
  • created_at — DATETIME — NOT NULL — 등록일시

hospital_review

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • hospital_id — BIGINT — Foreign key → hospital.id — NOT NULL — 병원 ID
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL — 예약 ID
  • rating — INT — NOT NULL — 평점 (1~5)
  • content — TEXT — NOT NULL — 리뷰 내용
  • is_reported — TINYINT(1) — NOT NULL — 신고 여부 (0/1)
  • created_at — DATETIME — NOT NULL — 작성일시

lost_animal

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • pet_name — VARCHAR(50) — NOT NULL — 반려동물 이름
  • species — VARCHAR(50) — NOT NULL — 품종
  • feature — TEXT — NOT NULL — 특징
  • lost_date — DATE — NOT NULL — 실종 날짜
  • lost_location — VARCHAR(255) — NOT NULL — 실종 장소
  • latitude — DECIMAL(10, 7) — NOT NULL — 위도 (Kakao Map)
  • longitude — DECIMAL(10, 7) — NOT NULL — 경도 (Kakao Map)
  • img_url — VARCHAR(255) — 사진 URL (S3)
  • status — VARCHAR(20) — NOT NULL — 상태 (MISSING/FOUND)
  • created_at — DATETIME — NOT NULL — 등록일시

manner_score

  • id — BIGINT — Primary key — NOT NULL
  • from_member_id — BIGINT — Foreign key → member.id — NOT NULL — 평가자 ID
  • to_member_id — BIGINT — Foreign key → member.id — NOT NULL — 피평가자 ID
  • used_post_id — BIGINT — Foreign key → used_post.id — NOT NULL — 거래 게시글 ID
  • score — INT — NOT NULL — 매너 점수
  • created_at — DATETIME — NOT NULL — 평가일시

medical_record

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL — 예약 ID
  • pet_id — BIGINT — Foreign key → pet_profile.id — NOT NULL — 반려동물 ID
  • diagnosis — TEXT — NOT NULL — 진단 내용
  • prescription — TEXT — 처방 내용
  • pdf_url — VARCHAR(255) — 처방전 PDF URL (S3)
  • visit_date — DATE — NOT NULL — 진료 날짜
  • created_at — DATETIME — NOT NULL — 등록일시

member

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL — 아이디
  • password — VARCHAR(100) — NOT NULL — 비밀번호 (BCrypt 암호화)
  • name — VARCHAR(30) — NOT NULL — 이름
  • email — VARCHAR(100) — NOT NULL — 이메일
  • social_type — VARCHAR(20) — 소셜 로그인 타입 (KAKAO/GOOGLE)
  • social_id — VARCHAR(100) — 소셜 로그인 ID
  • role — VARCHAR(20) — NOT NULL — 권한 (USER/ADMIN)
  • status — VARCHAR(20) — NOT NULL — 계정 상태 (ACTIVE/BANNED/WITHDRAWN)
  • created_at — DATETIME — NOT NULL — 가입일시
  • updated_at — DATETIME — NOT NULL — 수정일시

order_item

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL — 주문 ID
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — 상품 ID
  • quantity — INT — NOT NULL — 수량
  • price — INT — NOT NULL — 결제 금액 (원)

orders

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • order_name — VARCHAR(200) — NOT NULL — 주문명
  • total_price — INT — NOT NULL — 총 금액 (원)
  • delivery_address — VARCHAR(255) — NOT NULL — 배송지
  • status — VARCHAR(20) — NOT NULL — 상태 (ORDERED/SHIPPING/DONE/CANCEL)
  • payment_method — VARCHAR(30) — NOT NULL — 결제 수단
  • payment_key — VARCHAR(200) — 결제 키 (카카오페이)
  • created_at — DATETIME — NOT NULL — 주문일시

pet_profile

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • name — VARCHAR(50) — NOT NULL — 반려동물 이름
  • species — VARCHAR(50) — NOT NULL — 품종
  • age — INT — NOT NULL — 나이
  • weight — DECIMAL(5, 2) — 체중 (kg)
  • gender — VARCHAR(10) — NOT NULL — 성별 (MALE/FEMALE)
  • allergy — TEXT — 알러지 정보
  • profile_img — VARCHAR(255) — 프로필 사진 URL (S3)
  • created_at — DATETIME — NOT NULL — 등록일시

post_like

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • community_post_id — BIGINT — Foreign key → community_post.id — NOT NULL — 게시글 ID
  • created_at — DATETIME — NOT NULL — 좋아요 일시

product

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 상품명
  • price — INT — NOT NULL — 가격 (원)
  • stock — INT — NOT NULL — 재고 수량
  • category — VARCHAR(50) — NOT NULL — 카테고리
  • description — TEXT — 상품 설명
  • img_url — VARCHAR(255) — NOT NULL — 상품 이미지 URL (S3)
  • pet_species — VARCHAR(50) — 적합 품종
  • is_active — TINYINT(1) — NOT NULL — 판매 여부 (0/1)
  • created_at — DATETIME — NOT NULL — 등록일시

product_qna

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — 상품 ID
  • question — TEXT — NOT NULL — 질문 내용
  • answer — TEXT — 답변 내용
  • created_at — DATETIME — NOT NULL — 작성일시

product_review

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — 상품 ID
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL — 주문 ID
  • rating — INT — NOT NULL — 평점 (1~5)
  • content — TEXT — 리뷰 내용
  • img_url — VARCHAR(255) — 리뷰 사진 URL (S3)
  • created_at — DATETIME — NOT NULL — 작성일시

report

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 신고자 ID
  • target_type — VARCHAR(30) — NOT NULL — 신고 대상 타입 (POST/COMMENT/USED_POST/MEMBER)
  • target_id — BIGINT — NOT NULL — 신고 대상 ID
  • reason — TEXT — NOT NULL — 신고 사유
  • status — VARCHAR(20) — NOT NULL — 처리 상태 (PENDING/PROCESSED)
  • created_at — DATETIME — NOT NULL — 신고일시

reservation

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • hospital_id — BIGINT — Foreign key → hospital.id — NOT NULL — 병원 ID
  • pet_id — BIGINT — Foreign key → pet_profile.id — NOT NULL — 반려동물 ID
  • reserve_date — DATE — NOT NULL — 예약 날짜
  • reserve_time — TIME — NOT NULL — 예약 시간
  • department — VARCHAR(50) — NOT NULL — 진료과
  • status — VARCHAR(20) — NOT NULL — 상태 (WAITING/CONFIRMED/DONE/CANCEL)
  • wait_number — INT — 대기 번호
  • created_at — DATETIME — NOT NULL — 예약 생성일시

subscription

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • product_id — BIGINT — Foreign key → product.id — NOT NULL — 상품 ID
  • quantity — INT — NOT NULL — 구독 수량
  • cycle_days — INT — NOT NULL — 배송 주기 (일)
  • next_delivery_date — DATE — NOT NULL — 다음 배송일
  • status — VARCHAR(20) — NOT NULL — 상태 (ACTIVE/PAUSED/CANCELLED)
  • created_at — DATETIME — NOT NULL — 구독 시작일

used_post

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • title — VARCHAR(100) — NOT NULL — 제목
  • content — TEXT — NOT NULL — 내용
  • price — INT — NOT NULL — 가격 (원)
  • category — VARCHAR(50) — NOT NULL — 카테고리
  • region — VARCHAR(100) — NOT NULL — 거래 지역
  • status — VARCHAR(20) — NOT NULL — 거래 상태 (SALE/RESERVED/DONE)
  • is_hidden — TINYINT(1) — NOT NULL — 숨김 여부 (0/1)
  • report_count — INT — NOT NULL — 신고 횟수
  • pulled_up_at — DATETIME — 끌어올리기 일시
  • created_at — DATETIME — NOT NULL — 등록일시

used_post_img

  • id — BIGINT — Primary key — NOT NULL
  • used_post_id — BIGINT — Foreign key → used_post.id — NOT NULL — 게시글 ID
  • img_url — VARCHAR(255) — NOT NULL — 이미지 URL (S3)
  • sort_order — INT — NOT NULL — 정렬 순서

vaccination

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → pet_profile.id — NOT NULL — 반려동물 ID
  • vaccine_name — VARCHAR(100) — NOT NULL — 백신명
  • vaccinated_date — DATE — NOT NULL — 접종일
  • next_date — DATE — NOT NULL — 다음 접종일
  • created_at — DATETIME — NOT NULL — 등록일시

wishlist

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL — 회원 ID
  • used_post_id — BIGINT — Foreign key → used_post.id — NOT NULL — 게시글 ID
  • created_at — DATETIME — NOT NULL — 찜 등록일시