OnMaru
Tables (49)
Untitled
ai_chunks
- chunk_id — char(36) — Primary key — NOT NULL
- document_id — char(36) — Foreign key → ai_documents.document_id — NOT NULL
- revision — varchar(255) — Foreign key → ai_documents.revision — NOT NULL
- position — int — NOT NULL
- text — text — NOT NULL
- offsets — text
ai_documents
- document_id — char(36) — Primary key — NOT NULL
- revision — varchar(255) — Primary key — NOT NULL
- content_hash — varchar(255) — NOT NULL
- active — boolean — NOT NULL
- source_type — varchar(255) — NOT NULL
- source_ref — varchar(255) — NOT NULL
- metadata — text
ai_embeddings
- embedding_profile_id — varchar(255) — Primary key — NOT NULL
- chunk_id — char(36) — Foreign key → ai_chunks.chunk_id — NOT NULL
- vector — vector
audio_odii_spots
- id — char(36) — Primary key — NOT NULL
- provider — varchar(255) — NOT NULL
- tid — varchar(255) — NOT NULL
- tlid — varchar(255) — NOT NULL
- lang_code — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
audio_odii_stories
- id — char(36) — Primary key — NOT NULL
- spot_id — char(36) — Foreign key → audio_odii_spots.id — NOT NULL
- provider — varchar(255) — NOT NULL
- stid — varchar(255) — NOT NULL
- stlid — varchar(255) — NOT NULL
- lang_code — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
audio_place_odii_links
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- spot_id — char(36) — Foreign key → audio_odii_spots.id — NOT NULL
- match_method — varchar(255) — NOT NULL
- confidence — decimal(18,6)
- verified_at — datetime
audio_spot_versions
- revision_id — char(36) — Primary key — NOT NULL
- spot_id — char(36) — Foreign key → audio_odii_spots.id — NOT NULL
- title — varchar(255) — NOT NULL
- address — text
- location — text
- status — varchar(32) — NOT NULL
- hash — varchar(255) — NOT NULL
audio_story_versions
- revision_id — char(36) — Primary key — NOT NULL
- story_id — char(36) — Foreign key → audio_odii_stories.id — NOT NULL
- spot_id — char(36) — Foreign key → audio_odii_spots.id — NOT NULL
- title — varchar(255) — NOT NULL
- script — text
- audio_url — text
- image_url — text
- duration_seconds — int
- status — varchar(32) — NOT NULL
- hash — varchar(255) — NOT NULL
audio_subtitle_lines
- revision_id — char(36) — Primary key — NOT NULL
- position — int — Primary key — NOT NULL
- story_id — char(36) — Foreign key → audio_odii_stories.id — NOT NULL
- text — text — NOT NULL
- start_seconds — decimal(18,6)
- timing_mode — varchar(255) — NOT NULL
catalog_active_datasets
- dataset — varchar(255) — Primary key — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- activated_at — datetime — NOT NULL
catalog_dataset_revisions
- id — char(36) — Primary key — NOT NULL
- dataset — varchar(255) — NOT NULL
- status — varchar(32) — NOT NULL
- base_revision_id — char(36) — Foreign key → catalog_dataset_revisions.id
- source_observed_at — datetime
- fetched_at — datetime — NOT NULL
- published_at — datetime
catalog_hanok_detail_versions
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- type — varchar(255)
- hours — text
- parking — text
- homepage — text
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
catalog_kto_korean_content_versions
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
- contentid — varchar(255) — NOT NULL
- contenttypeid — varchar(255)
- title — varchar(255) — NOT NULL
- addr1 — text
- addr2 — text
- zipcode — varchar(255)
- areacode — varchar(255)
- sigungucode — varchar(255)
- cat1 — varchar(255)
- cat2 — varchar(255)
- cat3 — varchar(255)
- lcls_systm1 — varchar(255)
- lcls_systm2 — varchar(255)
- lcls_systm3 — varchar(255)
- firstimage — text
- firstimage2 — text
- cpyrht_div_cd — varchar(255)
- mapx — decimal(18,6)
- mapy — decimal(18,6)
- mlevel — varchar(255)
- tel — varchar(255)
- createdtime — varchar(255)
- modifiedtime — varchar(255)
- showflag — varchar(255)
- raw_hash — varchar(255) — NOT NULL
catalog_kto_korean_info_versions
- serialnum — varchar(255) — Primary key — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
- infoname — varchar(255)
- infotext — text
- fldgubun — varchar(255)
- raw_hash — varchar(255) — NOT NULL
catalog_kto_korean_intro_versions
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
- heritage1 — varchar(255)
- heritage2 — varchar(255)
- heritage3 — varchar(255)
- infocenter — text
- opendate — text
- restdate — text
- expguide — text
- expagerange — text
- accomcount — text
- useseason — text
- usetime — text
- parking — text
- chkbabycarriage — text
- chkpet — text
- chkcreditcard — text
- raw_hash — varchar(255) — NOT NULL
catalog_place_identity
- id — char(36) — Primary key — NOT NULL
- created_at — datetime — NOT NULL
catalog_place_image_versions
- position — int — Primary key — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- origin_img_url — text — NOT NULL
- small_image_url — text
- image_name — varchar(255)
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
- rights_note — text
catalog_place_sources
- id — char(36) — Primary key — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- provider — varchar(255) — NOT NULL
- dataset — varchar(255) — NOT NULL
- external_id — varchar(255) — NOT NULL
- language — varchar(255) — NOT NULL
- fetched_at — datetime — NOT NULL
- payload_hash — varchar(255)
catalog_place_versions
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- source_ref_id — char(36) — Foreign key → catalog_place_sources.id — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id
- name — varchar(255) — NOT NULL
- category — varchar(255) — NOT NULL
- address — text
- location — text
- overview — text
- visit_review_eligible — boolean — NOT NULL
- status — varchar(32) — NOT NULL
- normalized_hash — varchar(255) — NOT NULL
catalog_region_boundaries
- boundary_revision — varchar(255) — Primary key — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id — NOT NULL
- geometry — text — NOT NULL
- source_name — varchar(255) — NOT NULL
- rights_note — text — NOT NULL
- observed_at — datetime — NOT NULL
catalog_region_source_codes
- provider — varchar(255) — Primary key — NOT NULL
- dataset — varchar(255) — Primary key — NOT NULL
- source_code — varchar(255) — Primary key — NOT NULL
- valid_from — date — Primary key — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id — NOT NULL
- valid_to — date
catalog_regions
- id — char(36) — Primary key — NOT NULL
- parent_id — char(36) — Foreign key → catalog_regions.id
- code — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- level — varchar(32) — NOT NULL
- active — boolean — NOT NULL
community_review_likes
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- review_id — char(36) — Foreign key → community_visit_reviews.id — NOT NULL
- created_at — datetime — NOT NULL
community_visit_reviews
- id — char(36) — Primary key — NOT NULL
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- text — text — NOT NULL
- status — varchar(32) — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
discovery_explorations
- id — char(36) — Primary key — NOT NULL
- owner_member_id — char(36) — Foreign key → identity_members.id
- owner_guest_id — char(36) — Foreign key → identity_guests.id
- state_version — int — NOT NULL
- board — text
- pinned_refs — text — NOT NULL
- excluded_refs — text — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id
- expires_at — datetime
- deleted_at — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
discovery_proposals
- id — char(36) — Primary key — NOT NULL
- run_id — char(36) — Foreign key → discovery_runs.id — NOT NULL
- exploration_id — char(36) — Foreign key → discovery_explorations.id — NOT NULL
- base_version — int — NOT NULL
- ordered_refs — text — NOT NULL
- reasons — text — NOT NULL
- evidence — text — NOT NULL
- expires_at — datetime — NOT NULL
- status — varchar(32) — NOT NULL
discovery_runs
- id — char(36) — Primary key — NOT NULL
- exploration_id — char(36) — Foreign key → discovery_explorations.id — NOT NULL
- actor_key — varchar(255) — NOT NULL
- base_version — int — NOT NULL
- status — varchar(32) — NOT NULL
- stage — varchar(255)
- outcome — varchar(255)
- clarification — text
- created_at — datetime — NOT NULL
- deadline_at — datetime — NOT NULL
- started_at — datetime
- generation — int — NOT NULL
- error_code — varchar(255)
- engine — varchar(255) — NOT NULL
discovery_turns
- id — char(36) — Primary key — NOT NULL
- exploration_id — char(36) — Foreign key → discovery_explorations.id — NOT NULL
- client_turn_id — char(36) — NOT NULL
- query — text — NOT NULL
- created_at — datetime — NOT NULL
identity_exploration_grants
- exploration_id — char(36) — Foreign key → discovery_explorations.id — NOT NULL
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- expires_at — datetime — NOT NULL
identity_external_accounts
- id — char(36) — Primary key — NOT NULL
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- provider — varchar(255) — NOT NULL
- issuer — varchar(255) — NOT NULL
- subject — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
identity_guests
- id — char(36) — Primary key — NOT NULL
- token_hash — varchar(255) — NOT NULL
- expires_at — datetime — NOT NULL
- revoked_at — datetime
identity_members
- id — char(36) — Primary key — NOT NULL
- status — varchar(32) — NOT NULL
- created_at — datetime — NOT NULL
identity_oauth_states
- state_hash — varchar(255) — Primary key — NOT NULL
- guest_id — char(36) — Foreign key → identity_guests.id
- browser_nonce_hash — varchar(255) — NOT NULL
- exploration_id — char(36) — Foreign key → discovery_explorations.id
- provider — varchar(255) — NOT NULL
- return_path — varchar(255) — NOT NULL
- expires_at — datetime — NOT NULL
- consumed_at — datetime
identity_sessions
- token_hash — varchar(255) — Primary key — NOT NULL
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- created_at — datetime — NOT NULL
- last_seen_at — datetime — NOT NULL
- absolute_expires_at — datetime — NOT NULL
- revoked_at — datetime
insights_concentration_observations
- basis_date — date — Primary key — NOT NULL
- metric_type — varchar(255) — Primary key — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- target_id — char(36) — Foreign key → insights_tourism_targets.id — NOT NULL
- value — decimal(18,6) — NOT NULL
- unit — varchar(255) — NOT NULL
- source_observed_at — datetime
- fetched_at — datetime — NOT NULL
insights_target_place_links
- target_id — char(36) — Foreign key → insights_tourism_targets.id — NOT NULL
- place_id — char(36) — Foreign key → catalog_place_identity.id — NOT NULL
- match_method — varchar(255) — NOT NULL
- verified_at — datetime
insights_tourism_targets
- id — char(36) — Primary key — NOT NULL
- provider — varchar(255) — NOT NULL
- source_target_key — varchar(255) — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id — NOT NULL
- source_name — varchar(255) — NOT NULL
insights_visitor_observations
- basis_date — date — Primary key — NOT NULL
- visitor_type — varchar(255) — Primary key — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL
- region_id — char(36) — Foreign key → catalog_regions.id — NOT NULL
- provider — varchar(255) — NOT NULL
- spatial_level — varchar(255) — NOT NULL
- visitor_count — bigint — NOT NULL
- source_observed_at — datetime
- fetched_at — datetime — NOT NULL
journey_saved_journeys
- id — char(36) — Primary key — NOT NULL
- member_id — char(36) — Foreign key → identity_members.id — NOT NULL
- source_exploration_id — char(36) — Foreign key → discovery_explorations.id
- source_version — int — NOT NULL
- saved_at — datetime — NOT NULL
- title — varchar(255) — NOT NULL
- snapshot — text — NOT NULL
- snapshot_hash — varchar(255) — NOT NULL
journey_saved_resources
- id — char(36) — Primary key — NOT NULL
- member_id — char(36) — NOT NULL
- resource_type — varchar(32) — NOT NULL
- resource_id — char(36) — NOT NULL
- saved_at — datetime — NOT NULL
operations_admission
- scope_key — varchar(255) — Primary key — NOT NULL
- window_start — datetime — NOT NULL
- consumed — int — NOT NULL
- active_count — int — NOT NULL
operations_idempotency
- actor_key — varchar(255) — Primary key — NOT NULL
- operation — varchar(255) — Primary key — NOT NULL
- key — char(36) — Primary key — NOT NULL
- request_hash — varchar(255) — NOT NULL
- response_status — int — NOT NULL
- response_body — text
- expires_at — datetime — NOT NULL
operations_sync_checkpoints
- partition_key — varchar(255) — Primary key — NOT NULL
- run_id — char(36) — Foreign key → operations_sync_runs.id — NOT NULL
- next_page — int
- source_cursor — varchar(255)
- expected_total — int
- seen_count — int — NOT NULL
- last_source_modified — varchar(255)
- last_external_id — varchar(255)
operations_sync_leases
- dataset — varchar(255) — Primary key — NOT NULL
- owner_token — varchar(255) — NOT NULL
- generation — int — NOT NULL
- lease_until — datetime — NOT NULL
operations_sync_quarantine
- record_key — varchar(255) — Primary key — NOT NULL
- run_id — char(36) — Foreign key → operations_sync_runs.id — NOT NULL
- error_code — varchar(255) — NOT NULL
- payload_hash — varchar(255) — NOT NULL
- redacted_payload — text
- expires_at — datetime — NOT NULL
operations_sync_runs
- id — char(36) — Primary key — NOT NULL
- dataset — varchar(255) — NOT NULL
- scheduled_for — datetime — NOT NULL
- attempt — int — NOT NULL
- status — varchar(32) — NOT NULL
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id
- started_at — datetime
- finished_at — datetime
- next_attempt_at — datetime
- error_code — varchar(255)
- counts — text
operations_sync_schedules
- dataset — varchar(255) — Primary key — NOT NULL
- timezone — varchar(255) — NOT NULL
- local_time — varchar(255) — NOT NULL
- enabled — boolean — NOT NULL
- next_due_at — datetime — NOT NULL
operations_sync_watermarks
- dataset — varchar(255) — Primary key — NOT NULL
- source_modified_at — varchar(255)
- external_id — varchar(255)
- last_full_success_at — datetime
- last_success_at — datetime
- revision_id — char(36) — Foreign key → catalog_dataset_revisions.id — NOT NULL