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