v2.1

Tables (31)

ai_prompt_templates

  • id (AI 프롬프트 템플릿 ID) — BIGINT — Primary key — NOT NULL
  • feature (AI 기능) — VARCHAR(50) — NOT NULL
  • category (프롬프트 카테고리) — VARCHAR(30) — NOT NULL — SMALL_DOG / SENIOR_DOG / MEDICAL_CARE / GENERAL
  • prompt_version (프롬프트 버전) — VARCHAR(30) — NOT NULL
  • template (프롬프트 템플릿) — TEXT — NOT NULL
  • active (활성화 여부) — TINYINT(1) — NOT NULL — SUCCESS / FALLBACK / FAILED
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

ai_usage_logs

  • id (AI 사용 로그 ID) — BIGINT — Primary key — NOT NULL
  • feature (AI 기능) — VARCHAR(50) — NOT NULL — SITTER_REVIEW_SUMMARY / SITTER_RECOMMENDATION
  • model (AI 모델) — VARCHAR(100)
  • prompt_tokens (프롬프트 토큰) — INT
  • completion_tokens (응답 토큰) — INT
  • total_tokens (전체 토큰) — INT
  • latency_ms (응답 시간(ms)) — BIGINT — NOT NULL
  • status (사용 상태) — VARCHAR(20) — NOT NULL — SUCCESS / FALLBACK / FAILED
  • error_type (에러 타입) — VARCHAR(30) — TIMEOUT / RATE_LIMIT / SERVER_ERROR / PARSE_ERROR / INVALID_RESPONSE / UNKNOWN
  • prompt_version (프롬프트 버전) — VARCHAR(100)
  • failure_reason (실패 사유) — VARCHAR(500)
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

care_log

  • id (돌봄 일지 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • sitter_member_id (시터 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • content (돌봄 일지 내용) — VARCHAR(1000) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

care_log_image

  • id (돌봄 일지 이미지 ID) — BIGINT — Primary key — NOT NULL
  • care_log_id (돌봄 일지 ID) — BIGINT — Foreign key → care_log.id — NOT NULL
  • image_url (이미지 URL) — VARCHAR(255) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

care_request

  • id (돌봄 요청 ID) — BIGINT — Primary key — NOT NULL
  • member_id (요청 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • sitter_profile_id (시터 프로필 ID) — BIGINT — Foreign key → sitter_profile.id — NOT NULL
  • sitter_member_id (시터 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • care_type (돌봄 타입) — VARCHAR(20) — NOT NULL — VISIT / BOARDING
  • message (요청 메시지) — TEXT
  • request_price (요청 가격) — INT — NOT NULL
  • status (요청 상태) — VARCHAR(20) — NOT NULL — PENDING / ACCEPTED / REJECTED / CANCELED / EXPIRED
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

care_request_pet

  • id (돌봄 요청 반려동물 ID) — BIGINT — Primary key — NOT NULL
  • care_request_id (돌봄 요청 ID) — BIGINT — Foreign key → care_request.id — NOT NULL
  • pet_id (반려동물 ID) — BIGINT — Foreign key → pet.id — NOT NULL
  • name (반려동물 이름 Snapshot) — VARCHAR(50) — NOT NULL
  • species (동물 종류 Snapshot) — VARCHAR(20) — NOT NULL — DOG / CAT / ETC
  • breed (품종 Snapshot) — VARCHAR(50)
  • size (크기 Snapshot) — VARCHAR(20) — SMALL / MEDIUM / LARGE
  • age (나이 Snapshot) — INT
  • gender (성별 Snapshot) — VARCHAR(20) — MALE / FEMALE / UNKNOWN

care_request_time_slot

  • id (돌봄 요청 시간 ID) — BIGINT — Primary key — NOT NULL
  • care_request_id (돌봄 요청 ID) — BIGINT — Foreign key → care_request.id — NOT NULL
  • care_date (돌봄 날짜) — DATE — NOT NULL
  • start_time (시작 시간) — TIME — NOT NULL
  • end_time (종료 시간) — TIME — NOT NULL
  • sequence (순서) — INT — NOT NULL

chat_message

  • id (채팅 메시지 ID) — BIGINT — Primary key — NOT NULL
  • chat_room_id (채팅방 ID) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • sender_id (보낸 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • sender_nickname (보낸 회원 닉네임 Snapshot) — VARCHAR(50) — NOT NULL
  • message_type (메시지 타입) — VARCHAR(20) — NOT NULL — TEXT
  • content (메시지 내용) — VARCHAR(1000) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL

chat_room

  • id (채팅방 ID) — BIGINT — Primary key — NOT NULL — 채팅방 ID
  • member_a_id (작은 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • member_b_id (큰 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • room_key (1:1 채팅방 키) — VARCHAR(50) — NOT NULL
  • last_message_id (마지막 메시지 ID) — BIGINT — Foreign key → chat_message.id
  • last_message_at (마지막 메시지 시간) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

chat_room_participant

  • id (채팅방 참여자 ID) — BIGINT — Primary key — NOT NULL
  • chat_room_id (채팅방 ID) — BIGINT — Foreign key → chat_room.id — NOT NULL
  • member_id (회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • is_left (나가기 여부) — TINYINT(1) — NOT NULL
  • left_at (나간 시간) — DATETIME
  • visible_from_at (메시지 조회 기준 시간) — DATETIME
  • last_read_message_id (마지막 읽은 메시지 ID) — BIGINT — Foreign key → chat_message.id
  • last_read_at (마지막 읽은 시간) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

coupons (쿠폰)

  • id (쿠폰 ID) — BIGINT — Primary key — NOT NULL
  • name (쿠폰명) — VARCHAR(255) — NOT NULL
  • discount_rate (할인율) — INT — NOT NULL
  • total_quantity (총 수량) — INT — NOT NULL
  • remaining_quantity (남은 수량) — INT — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

member

  • id (회원 ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL
  • phone (전화번호) — VARCHAR(30)
  • region (지역) — VARCHAR(20) — NOT NULL — UNKNOWN / GANGNAM / SEOCHO / SONGPA 등 30개 서울 지역
  • gender (성별) — VARCHAR(20) — NOT NULL — MALE / FEMALE / UNKNOWN
  • role (회원 역할) — VARCHAR(20) — NOT NULL — MEMBER / SITTER / ADMIN
  • status (회원 상태) — VARCHAR(20) — NOT NULL — ACTIVE / SUSPENDED
  • deleted (삭제 여부) — TINYINT(1) — NOT NULL
  • deleted_at (삭제 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

notification

  • id (알림 ID) — BIGINT — Primary key — NOT NULL
  • receiver_id (수신 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • sender_id (발신 회원 ID) — BIGINT — Foreign key → member.id
  • type (알림 타입) — VARCHAR(30) — NOT NULL — CARE_LOG / PROPOSAL_ARRIVED / MATCHING_CONFIRMED / REQUEST_RECEIVED 등
  • message (알림 메시지) — VARCHAR(255) — NOT NULL
  • reference_id (참조 대상 ID) — BIGINT
  • reference_type (참조 대상 타입) — VARCHAR(255)
  • is_read (읽음 여부) — TINYINT(1) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

payment_webhooks

  • id (결제 웹훅 ID) — BIGINT — Primary key — NOT NULL
  • payment_id (결제 ID) — BIGINT — Foreign key → payments.id
  • provider (결제 제공자) — VARCHAR(20) — NOT NULL — PORTONE
  • event_id (웹훅 이벤트 ID) — VARCHAR(100) — NOT NULL
  • event_type (웹훅 이벤트 타입) — VARCHAR(50)
  • merchant_uid (주문 번호) — VARCHAR(100)
  • imp_uid (포트원 imp_uid) — VARCHAR(100)
  • portone_payment_id (포트원 결제 ID) — VARCHAR(100)
  • status (웹훅 처리 상태) — VARCHAR(20) — NOT NULL — RECEIVED / PROCESSED / FAILED / IGNORED
  • payload (웹훅 원본 데이터) — TEXT
  • failure_reason (실패 사유) — VARCHAR(255)
  • received_at (수신 일시) — DATETIME — NOT NULL
  • processed_at (처리 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

payments

  • id (결제 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • member_id (결제 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • payment_role (결제자 역할) — VARCHAR(20) — NOT NULL — GUARDIAN / SITTER
  • payment_type (결제 타입) — VARCHAR(20) — NOT NULL — FULL / DEPOSIT
  • original_amount (원 금액) — BIGINT — NOT NULL
  • discount_amount (할인 금액) — BIGINT — NOT NULL
  • final_amount (최종 금액) — BIGINT — NOT NULL
  • user_coupon_id (사용자 쿠폰 ID) — BIGINT — Foreign key → user_coupons.id
  • status (결제 상태) — VARCHAR(20) — NOT NULL — READY / PENDING / PAID / FAILED / CANCELED / REFUNDED / EXPIRED
  • provider (결제 제공자) — VARCHAR(20) — NOT NULL — PORTONE
  • imp_uid (포트원 imp_uid) — VARCHAR(255)
  • merchant_uid (주문 번호) — VARCHAR(100) — NOT NULL
  • portone_payment_id (포트원 결제 ID) — VARCHAR(255)
  • requested_at (결제 요청 일시) — DATETIME — NOT NULL
  • approved_at (승인 일시) — DATETIME
  • canceled_at (취소 일시) — DATETIME
  • refunded_at (환불 일시) — DATETIME
  • failed_reason (실패 사유) — VARCHAR(255)
  • cancel_reason (취소 사유) — VARCHAR(255)
  • raw_response (원본 응답) — TEXT
  • version (낙관적 락 버전) — BIGINT — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

pet

  • id (반려동물 ID) — BIGINT — Primary key — NOT NULL
  • member_id (회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • name (반려동물 이름) — VARCHAR(50) — NOT NULL
  • species (동물 종류) — VARCHAR(20) — NOT NULL — DOG / CAT / ETC
  • breed (품종) — VARCHAR(50)
  • size (크기) — VARCHAR(20) — SMALL / MEDIUM / LARGE
  • age (나이) — INT
  • gender (성별) — VARCHAR(20) — MALE / FEMALE / UNKNOWN
  • profile_image_url (프로필 이미지 URL) — VARCHAR(500)
  • note (특이사항) — TEXT
  • deleted (삭제 여부) — TINYINT(1) — NOT NULL
  • deleted_at (삭제 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

post

  • id (게시글 ID) — BIGINT — Primary key — NOT NULL
  • member_id (작성 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • title (제목) — VARCHAR(100) — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • care_type (돌봄 타입) — VARCHAR(20) — NOT NULL — 방문 돌봄: VISIT, 위탁 돌봄: BOARDING
  • budget_amount (예산) — INT
  • status (게시글 상태) — VARCHAR(20) — NOT NULL — OPEN / CLOSED / EXPIRED
  • deleted (삭제 여부) — TINYINT(1) — NOT NULL
  • deleted_at (삭제 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

post_pet

  • id (게시글 반려동물 ID) — BIGINT — Primary key — NOT NULL
  • post_id (게시글 ID) — BIGINT — Foreign key → post.id — NOT NULL
  • pet_id (반려동물 ID) — BIGINT — Foreign key → pet.id — NOT NULL
  • name (반려동물 이름 Snapshot) — VARCHAR(50) — NOT NULL
  • species (동물 종류 Snapshot) — VARCHAR(20) — NOT NULL — DOG / CAT / ETC
  • breed (품종 Snapshot) — VARCHAR(50)
  • size (크기 Snapshot) — VARCHAR(20) — SMALL / MEDIUM / LARGE
  • age (나이 Snapshot) — INT
  • gender — VARCHAR(20) — MALE / FEMALE / UNKNOWN

post_time_slot

  • id (게시글 희망 시간 ID) — BIGINT — Primary key — NOT NULL
  • post_id (게시글) — BIGINT — Foreign key → post.id — NOT NULL
  • care_date (돌봄 날짜) — DATE — NOT NULL
  • start_time (시작 시간) — TIME — NOT NULL
  • end_time (종료 시간) — TIME — NOT NULL
  • sequence (순서) — INT — NOT NULL

proposal

  • id (지원 제안 ID) — BIGINT — Primary key — NOT NULL
  • post_id (게시글 ID) — BIGINT — Foreign key → post.id — NOT NULL
  • sitter_profile_id (시터 프로필 ID) — BIGINT — Foreign key → sitter_profile.id — NOT NULL
  • sitter_member_id (시터 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • member_id (게시글 작성 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • proposed_price (제안 가격) — INT — NOT NULL
  • message (제안 메시지) — TEXT
  • status (제안 상태) — VARCHAR(20) — NOT NULL — PENDING / ACCEPTED / REJECTED / WITHDRAWN / EXPIRED
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

reservation

  • id (예약 ID) — BIGINT — Primary key — NOT NULL
  • member_id (보호자 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • sitter_member_id (시터 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • sitter_profile_id (시터 프로필 ID) — BIGINT — Foreign key → sitter_profile.id — NOT NULL
  • care_type (돌봄 타입) — VARCHAR(20) — NOT NULL
  • status (예약 상태) — VARCHAR(20) — NOT NULL — PENDING/ CONFIRMED/ COMPLETED/ CANCELED/ EXPIRED
  • source (예약 생성 출처) — VARCHAR(20) — NOT NULL — CARE_REQUEST/ PROPOSAL
  • source_id (출처 ID: proposal 또는 care_request) — BIGINT — NOT NULL
  • cancel_reason (취소 사유) — VARCHAR(500)
  • cancel_category (취소 카테고리) — VARCHAR(20) — PERSONAL/ SCHEDULE_CHANGED/ UNAVOIDABLE/ OTHER
  • canceled_at (취소 일시) — DATETIME
  • canceled_by (취소 주체) — VARCHAR(20) — GUARDIAN / SITTER
  • confirmedAt (확정 일시) — DATETIME
  • completed_at (완료 일시) — DATETIME
  • expired_at (만료 일시) — DATETIME
  • version (낙관적 락 버전) — BIGINT — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

reservation_payment (예약 결제 상태)

  • id (예약 결제 상태 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • guardian_paid (보호자 결제 여부) — TINYINT(1) — NOT NULL
  • guardian_price (보호자 결제 금액) — INT — NOT NULL
  • sitter_paid (시터 결제 여부) — TINYINT(1) — NOT NULL
  • sitter_price (시터 결제 금액) — INT — NOT NULL
  • version (낙관적 락 버전) — BIGINT — NOT NULL

reservation_pet

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • pet_id (반려동물 ID) — BIGINT — Foreign key → pet.id — NOT NULL
  • name (반려동물 이름 Snapshot) — VARCHAR(50) — NOT NULL
  • species (동물 종류 Snapshot) — VARCHAR(20) — NOT NULL — DOG / CAT / ETC
  • breed (품종 Snapshot) — VARCHAR(50)
  • size (크기 Snapshot) — VARCHAR(20) — SMALL / MEDIUM / LARGE
  • age (나이 Snapshot) — INT
  • gender (성별 Snapshot) — VARCHAR(20) — MALE / FEMALE / UNKNOWN

reservation_time_slot

  • id (예약 시간 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • care_date (돌봄 날짜) — DATE — NOT NULL
  • start_time (시작 시간) — TIME — NOT NULL
  • end_time (종료 시간) — TIME — NOT NULL
  • sequence (순서) — INT — NOT NULL

review

  • id (리뷰 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • reviewer_id (리뷰 작성자 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • reviewee_id (리뷰 대상자 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • review_comment (리뷰 내용) — TEXT — NOT NULL
  • rating (평점) — INT — NOT NULL
  • deleted (삭제 여부) — TINYINT(1) — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

settlements

  • id (정산 ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약 ID) — BIGINT — Foreign key → reservation.id — NOT NULL
  • receiver_member_id (정산 수령 회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • source_payment_id (원 결제 ID) — BIGINT — Foreign key → payments.id
  • settlement_type (정산 타입) — VARCHAR(30) — NOT NULL — CARE_COMPLETION / CANCEL_PENALTY / GUARDIAN_PARTIAL_REFUND
  • status (정산 상태) — VARCHAR(20) — NOT NULL — READY / HOLD / APPROVED / PROCESSING
  • original_amount (원 금액) — BIGINT — NOT NULL
  • platform_fee_rate (플랫폼 수수료율) — INT — NOT NULL
  • platform_fee_amount (플랫폼 수수료 금액) — BIGINT — NOT NULL
  • settlement_amount (정산 금액) — BIGINT — NOT NULL
  • reason (정산 사유) — VARCHAR(500)
  • hold_reason (보류 사유) — VARCHAR(500)
  • failed_reason (실패 사유) — VARCHAR(500)
  • requested_at (정산 요청 일시) — DATETIME — NOT NULL
  • approved_at (승인 일시) — DATETIME
  • processed_at (처리 시작 일시) — DATETIME
  • settled_at (정산 완료 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

sitter_profile

  • id (시터 프로필 ID) — BIGINT — Primary key — NOT NULL
  • member_id (회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • introduction (소개글) — TEXT
  • experience_years (경력 연수) — INT — NOT NULL
  • possible_pet_type (돌봄 가능 동물 타입) — VARCHAR(20) — NOT NULL — DOG/ CAT/ ETC/ ALL
  • possible_pet_size (돌봄 가능 동물 크기) — VARCHAR(20) — SMALL/ MEDIUM/ LARGE/ ALL
  • price_per_hour (시간당 가격) — INT — NOT NULL
  • average_rating (평균 평점) — DECIMAL(2, 1) — NOT NULL — 0.0
  • review_count (리뷰 수) — INT — NOT NULL
  • status (시터 프로필 상태) — VARCHAR(20) — NOT NULL — RESERVABLE/ NON_RESERVABLE
  • approval_status (승인 상태) — VARCHAR(20) — NOT NULL — PENDING/APPROVED/REJECTED
  • reject_reason (반려 사유) — VARCHAR(500)
  • evaluated_by (심사 관리자 ID) — BIGINT — Foreign key → member.id
  • evaluated_at (심사 일시) — DATETIME
  • deleted (삭제 여부) — TINYINT(1) — NOT NULL
  • deleted_at (삭제 일시) — DATETIME
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

sitter_review_summaries

  • id (시터 리뷰 요약 ID) — BIGINT — Primary key — NOT NULL
  • sitter_id (시터 프로필 ID) — BIGINT — Foreign key → sitter_profile.id — NOT NULL
  • summary (요약) — TEXT — NOT NULL
  • strengths (장점) — TEXT — NOT NULL
  • cautions (주의사항) — TEXT — NOT NULL
  • recommended_for (추천 대상) — TEXT — NOT NULL
  • keywords (키워드) — TEXT — NOT NULL
  • sentiment (리뷰 감정) — VARCHAR(20) — NOT NULL — POSITIVE / NEUTRAL / NEGATIVE
  • confidence_score (신뢰도 점수) — DOUBLE — NOT NULL
  • review_count (리뷰 수) — INT — NOT NULL
  • ai_generated (AI 생성 여부) — TINYINT(1) — NOT NULL
  • model (AI 모델) — VARCHAR(50) — NOT NULL
  • prompt_version (프롬프트 버전) — VARCHAR(30) — NOT NULL
  • summary_status (요약 상태) — VARCHAR(20) — NOT NULL — FRESH / STALE / FAILED
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

sitter_review_summary_reviews

  • id (시터 리뷰 요약-리뷰 매핑 ID) — BIGINT — Primary key — NOT NULL
  • summary_id (시터 리뷰 요약 ID) — BIGINT — Foreign key → sitter_review_summaries.id — NOT NULL
  • review_id (리뷰 ID) — BIGINT — Foreign key → review.id — NOT NULL

sitter_schedule

  • id (시터 스케줄 ID) — BIGINT — Primary key — NOT NULL
  • sitter_profile_id (시터 프로필 ID) — BIGINT — Foreign key → sitter_profile.id — NOT NULL
  • day_of_week (요일) — VARCHAR(10) — NOT NULL — MON - SUN
  • start_time (시작 시간) — TIME — NOT NULL
  • end_time (종료 시간) — TIME — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

user_coupons

  • id (사용자 쿠폰 ID) — BIGINT — Primary key — NOT NULL
  • user_id (회원 ID) — BIGINT — Foreign key → member.id — NOT NULL
  • coupon_id (쿠폰 ID) — BIGINT — Foreign key → coupons.id — NOT NULL
  • status (사용자 쿠폰 상태) — VARCHAR(255) — NOT NULL — ACTIVE / USED / REVOKED
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL