MCMcare

Tables (11)

as_case

  • as_id — BIGINT — Primary key — NOT NULL
  • as_no — VARCHAR(30) — NOT NULL — 노출용 접수번호
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • warranty_no — VARCHAR(50) — Foreign key → product.warranty_no — 필수입력 아님
  • product_type — VARCHAR(30) — NOT NULL
  • model_name — VARCHAR(50) — NOT NULL
  • purchased_at — DATE
  • purchase_channel — VARCHAR(30)
  • damage_part — VARCHAR(50) — NOT NULL
  • damage_type — VARCHAR(30) — NOT NULL — 찍힘/긁힘/변색/금속부품손상/봉제손상/기타
  • damage_description — VARCHAR(200)
  • status — VARCHAR(30) — NOT NULL — DEFAULT 없음 · 서비스에서 명시 세팅
  • status_updated_at — DATETIME
  • status_message — VARCHAR(200)
  • expected_completed_at — DATE
  • expected_updated_at — DATE — 완료 예정일 최종 갱신
  • completed_at — DATE — 실제 완료일 - 목록에서 완료 건 표시용
  • delay_reason — VARCHAR(200)
  • intake_type — VARCHAR(30) — 픽업 수거 접수
  • current_location — VARCHAR(50)
  • location_type — VARCHAR(20) — 국내 / 해외
  • location_status — VARCHAR(30)
  • created_at — DATETIME — NOT NULL — 접수일
  • updated_at — DATETIME — NOT NULL

as_photo

  • photo_id — BIGINT — Primary key — NOT NULL
  • as_id — BIGINT — Foreign key → as_case.as_id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL — 스토리지 URL
  • photo_type — VARCHAR(20) — NOT NULL — PRODUCT(전체) / DAMAGE(손상부위)
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

as_status_history

  • history_id — BIGINT — Primary key — NOT NULL
  • as_id — BIGINT — Foreign key → as_case.as_id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • description — VARCHAR(200) — 타임라인 문구
  • occurred_at — DATETIME — NOT NULL

driver

  • driver_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL — 기사 로그인 아이디
  • password — VARCHAR(60) — NOT NULL — BCrypt 해시
  • name — VARCHAR(30) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • vehicle_no — VARCHAR(20) — 12가 3456
  • verify_no — VARCHAR(30) — 신원 확인 번호
  • affiliation — VARCHAR(50) — MCM 공식 파트너 수거 기사
  • active — BOOLEAN — NOT NULL — 배차 대상 여부
  • created_at — DATETIME — NOT NULL

handover

  • handover_id — BIGINT — Primary key — NOT NULL
  • pickup_id — BIGINT — Foreign key → pickup.pickup_id — NOT NULL
  • driver_id — BIGINT — Foreign key → driver.driver_id — NOT NULL
  • driver_name — VARCHAR(30) — NOT NULL — 스냅샷
  • driver_phone — VARCHAR(50) — NOT NULL — 스냅샷
  • driver_vehicle_no — VARCHAR(20) — 스냅샷
  • driver_verify_no — VARCHAR(30) — 스냅샷
  • driver_affiliation — VARCHAR(50) — 스냅샷
  • customer_sign_url — VARCHAR(500) — NOT NULL — 고객 서명 이미지
  • driver_sign_url — VARCHAR(500) — NOT NULL — 기사 서명 이미지
  • handed_over_at — DATETIME — NOT NULL — 인계 완료 시각

handover_photo

  • photo_id — BIGINT — Primary key — NOT NULL
  • handover_id — BIGINT — Foreign key → handover.handover_id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

marketing_consent

  • consent_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • agreed — BOOLEAN — NOT NULL — true=동의, false=철회
  • occurred_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50) — NOT NULL — 아이디 겸용
  • password — VARCHAR(60) — NOT NULL — BCrypt 해시
  • name — VARCHAR(30) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL — 숫자만
  • birth_date — DATE — NOT NULL — 미래 날짜 불가
  • agreed_service — BOOLEAN — NOT NULL — 이용약관(필수)
  • agreed_privacy — BOOLEAN — NOT NULL — 개인정보 수집·이용(필수)
  • agreed_at — DATETIME — NOT NULL — 필수 약관 동의 시점
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pickup

  • pickup_id — BIGINT — Primary key — NOT NULL
  • pickup_no — VARCHAR(30) — NOT NULL — PKP-YYYY-NNNNNN
  • as_id — BIGINT — Foreign key → as_case.as_id — NOT NULL
  • driver_id — BIGINT — Foreign key → driver.driver_id — 예약 확정 시 자동 배정
  • pickup_date — DATE — NOT NULL — 오늘 이후만
  • slot_start — TIME — NOT NULL
  • slot_end — TIME — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • address_detail — VARCHAR(100)
  • note — VARCHAR(200)
  • status — VARCHAR(20) — NOT NULL — BOOKED / CANCELLED / COMPLETED
  • insurance_applied — BOOLEAN
  • insurance_limit — INT — 최대 500만원
  • created_at — DATETIME — NOT NULL

pickup_slot

  • slot_id — BIGINT — Primary key — NOT NULL
  • slot_date — DATE — NOT NULL
  • slot_start — TIME — NOT NULL
  • slot_end — TIME — NOT NULL
  • capacity — INT — NOT NULL — 슬롯 정원
  • is_blocked — BOOLEAN — NOT NULL — 운영 차단

product

  • warranty_no — VARCHAR(50) — Primary key — NOT NULL — 보증서 번호
  • member_id — BIGINT — Foreign key → member.member_id — 소유자 미확인 가능
  • product_type — VARCHAR(30) — NOT NULL — 가방/지갑/벨트/신발/소품/기타
  • model_name — VARCHAR(50) — NOT NULL
  • purchased_at — DATE — 병행수입 등 불명 가능
  • purchase_channel — VARCHAR(30) — 조회 불가 가능
  • warranty_months — INT — NOT NULL — 24 = 2년
  • warranty_expires_at — DATE — purchased_at + months 캐시
  • warranty_scope — VARCHAR(50) — 제조 결함 한정 등