Scene

Tables (7)

filming_location

  • filming_location_id — INT — Primary key — NOT NULL — 촬영지 · 출발점

ingest_log

  • ingest_history_id — INT — Primary key — NOT NULL — 적재 감사
  • ingest_history — VARCHAR(1) — 적재 실행 요약
  • error_history — VARCHAR(1) — 실패 행 상세

matching_and_reservation

  • match_history_id — INT — Primary key — NOT NULL
  • filming_location_id — INT — Foreign key → filming_location.filming_location_id — 결과 저장
  • match_history — VARCHAR(1) — 매칭 결과(폴리모픽)
  • reservation_handoff — VARCHAR(1) — 예약 연계

nearby_content

  • nearby_content_id — INT — Primary key — NOT NULL
  • filming_location_id — INT — Foreign key → filming_location.filming_location_id — 반경·이름 매칭
  • attraction — VARCHAR(1) — 관광지 (매칭 다리)
  • safe_restaurant — VARCHAR(1) — 안심맛집 (반경검색)
  • heritage — VARCHAR(1) — 국가유산
  • cosmetic_store — VARCHAR(1) — K-뷰티 매장
  • attraction_enrichment — VARCHAR(1) — 관광지 보강

region_and_congestion

  • sigungu_code — INT — Primary key — NOT NULL — 시도/시군구 기준표
  • nearby_content_id — INT — Foreign key → nearby_content.nearby_content_id — 관광지 경유 → 혼잡도 지역기준
  • area_master — VARCHAR(1) — 시도
  • sigungu_master — VARCHAR(1) — 시군구
  • congestion_forecast — VARCHAR(1) — 혼잡도 예측

trend

  • trend_id — INT — Primary key — NOT NULL
  • filming_location_id — INT — Foreign key → filming_location.filming_location_id — 매칭 앵커
  • youtube_trending — VARCHAR(1) — YouTube 원문(Mongo)
  • hallyu_keyword — VARCHAR(1) — 정규화 한류 키워드

user_and_travel

  • user_id — INT — Primary key — NOT NULL
  • filming_location_id — INT — Foreign key → filming_location.filming_location_id — 담기·경로에 추가
  • app_user — VARCHAR(1) — 회원
  • trip_card — VARCHAR(1) — 찜(순서X)
  • route — VARCHAR(1) — 여행 경로
  • route_stop — VARCHAR(1) — 경유지(순서O)
  • search_log — VARCHAR(1) — 검색어 로그