final

tour_api

Tables (10)

api_fetch_records

  • fetch_record_id — BIGINT — Primary key — NOT NULL
  • ingestion_run_id — BIGINT — Foreign key → ingestion_runs.ingestion_run_id — NOT NULL
  • content_id — BIGINT — Foreign key → places.content_id
  • endpoint — VARCHAR(100)
  • fetch_status — VARCHAR(30)
  • fetch_error — TEXT
  • fetched_at — DATETIME
  • raw_payload — JSON

content_types

  • content_type_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

ingestion_runs

  • ingestion_run_id — BIGINT — Primary key — NOT NULL
  • source_name — VARCHAR(100)
  • dataset — VARCHAR(100)
  • started_at — DATETIME
  • finished_at — DATETIME
  • status — VARCHAR(30)

lcls_categories

  • lcls3_code — VARCHAR(30) — Primary key — NOT NULL
  • lcls1_code — VARCHAR(30)
  • lcls1_name — VARCHAR(100)
  • lcls2_code — VARCHAR(30)
  • lcls2_name — VARCHAR(100)
  • lcls3_name — VARCHAR(100)

place_common_details

  • content_id — BIGINT — Foreign key → places.content_id — NOT NULL
  • tel — VARCHAR(100)
  • tel_name — VARCHAR(100)
  • homepage — TEXT
  • overview — TEXT
  • image_url — TEXT
  • thumbnail_url — TEXT
  • copyright_code — VARCHAR(20)

place_images

  • image_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → places.content_id — NOT NULL
  • image_url — TEXT — NOT NULL
  • thumbnail_url — TEXT
  • image_role — VARCHAR(30)
  • display_order — INT

place_intro

  • content_id — BIGINT — Foreign key → places.content_id — NOT NULL
  • info_center — TEXT
  • opening_hours — TEXT
  • closed_days — TEXT
  • parking — TEXT
  • reservation — TEXT
  • use_fee — TEXT
  • check_in_time — TEXT
  • check_out_time — TEXT
  • type_details — JSON

place_search_chunks

  • chunk_id — BIGINT — Primary key — NOT NULL
  • search_document_id — BIGINT — Foreign key → place_search_documents.search_document_id — NOT NULL
  • chunk_index — INT — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • embedding — TEXT

place_search_documents

  • search_document_id — BIGINT — Primary key — NOT NULL
  • content_id — BIGINT — Foreign key → places.content_id — NOT NULL
  • document_type — VARCHAR(50)
  • rag_eligible — BOOLEAN
  • route_eligible — BOOLEAN
  • schedule_eligible — BOOLEAN
  • requires_verification — BOOLEAN
  • exclusion_reason — TEXT
  • search_text — MEDIUMTEXT
  • tags — JSON
  • preprocessing_version — VARCHAR(50)
  • generated_at — DATETIME

places

  • content_id — BIGINT — Primary key — NOT NULL
  • content_type_id — INT — Foreign key → content_types.content_type_id — NOT NULL
  • lcls3_code — VARCHAR(30) — Foreign key → lcls_categories.lcls3_code
  • title — VARCHAR(200) — NOT NULL
  • addr1 — VARCHAR(255)
  • addr2 — VARCHAR(255)
  • area_code — INT
  • sigungu_code — INT
  • zipcode — VARCHAR(20)
  • longitude — DECIMAL(13, 10)
  • latitude — DECIMAL(13, 10)
  • location — POINT
  • map_level — INT
  • api_created_at — DATETIME
  • api_modified_at — DATETIME