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