여행꾹꾹

테이블 (7)

course_places

  • id — BIGINT — 기본 키 — NOT NULL
  • course_id — BIGINT — 외래 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → places.id — NOT NULL
  • sequence — INT — NOT NULL — 방문 순서

course_progresses

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 — NOT NULL
  • course_id — BIGINT — 외래 키 — NOT NULL
  • status — VARCHAR(20) — NOT NULL — IN_PROGRESS/COMPLETED/ABANDONED
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

courses

  • id — BIGINT — 기본 키 — NOT NULL
  • region_id — BIGINT — 외래 키 → regions.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • thumbnail_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

place_verifications

  • id — BIGINT — 기본 키
  • course_progress_id — BIGINT — 외래 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → places.id — NOT NULL
  • verified_latitude — DECIMAL(10, 8) — NOT NULL — 인증 위도
  • verified_longitude — DECIMAL(11, 8) — NOT NULL — 인증 경도
  • photo_verified — BOOLEAN
  • photo_url — VARCHAR(255)
  • verified_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

places

  • id — BIGINT — 기본 키
  • region_id — BIGINT — 외래 키 → regions.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • latitude — DECIMAL(10, 8) — NOT NULL — 위도
  • longitude — DECIMAL(11, 8) — NOT NULL — 경도
  • image_url — VARCHAR(255)
  • address — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

regions

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255)

users

  • id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — kakao/naver
  • provider_id — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • total_points — INTEGER
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL