Ditto

Tables (24)

ai_recommendation

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • language_code — VARCHAR(10) — NOT NULL
  • model_key — VARCHAR(100) — NOT NULL
  • conversation — JSON
  • input_condition — JSON — NOT NULL
  • recommendation_summary — TEXT
  • status — VARCHAR(30) — NOT NULL
  • error_code — VARCHAR(100)
  • processing_ms — INT
  • created_at — DATETIME — NOT NULL

ai_recommendation_item

  • id — BIGINT — Primary key — NOT NULL
  • ai_recommendation_id — BIGINT — Foreign key → ai_recommendation.id — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • stop_order — INT — NOT NULL
  • recommendation_reason — TEXT — NOT NULL
  • estimated_stay_minutes — INT
  • recommendation_score — DECIMAL(10, 4)

auth_session

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id — NOT NULL
  • refresh_token_hash — VARCHAR(255) — NOT NULL
  • device_info — VARCHAR(500)
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

brand

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • category_code — VARCHAR(50)
  • logo_url — VARCHAR(1000)
  • description_i18n — JSON
  • keyword_ids — JSON
  • status — VARCHAR(30) — NOT NULL

celebrity_brand

  • id — BIGINT — Primary key — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.id — NOT NULL
  • celebrity_name — VARCHAR(200) — NOT NULL
  • celebrity_type — VARCHAR(50)
  • celebrity_image_url — VARCHAR(1000)
  • recommendation_reason_i18n — JSON
  • status — VARCHAR(30) — NOT NULL

country

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • default_language_code — VARCHAR(10) — NOT NULL
  • domain_host — VARCHAR(255) — NOT NULL
  • status — VARCHAR(30) — NOT NULL

course

  • id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → user_account.id
  • source_course_id — BIGINT — Foreign key → course.id
  • ai_recommendation_id — BIGINT — Foreign key → ai_recommendation.id
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • language_code — VARCHAR(10) — NOT NULL
  • creation_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • estimated_minutes — INT
  • target_country_codes — JSON
  • keyword_ids — JSON
  • share_code — VARCHAR(100)
  • share_expires_at — DATETIME
  • share_active — BOOLEAN — NOT NULL
  • is_published — BOOLEAN — NOT NULL
  • community_content — TEXT
  • view_count — BIGINT — NOT NULL
  • confirmed_at — DATETIME
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

course_comment

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → course_comment.id
  • content — TEXT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

course_place

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • stop_order — INT — NOT NULL
  • recommendation_reason — TEXT
  • estimated_stay_minutes — INT
  • visit_status — VARCHAR(30) — NOT NULL
  • visited_at — DATETIME

course_reaction

  • id — BIGINT — Primary key — NOT NULL
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id — NOT NULL
  • reaction_type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

event_log

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id
  • country_id — BIGINT — Foreign key → country.id
  • request_id — VARCHAR(100)
  • event_type — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • status — VARCHAR(30)
  • error_code — VARCHAR(100)
  • processing_ms — INT
  • event_data — JSON
  • created_at — DATETIME — NOT NULL

floor

  • id — BIGINT — Primary key — NOT NULL
  • store_branch_id — BIGINT — Foreign key → store_branch.id — NOT NULL
  • floor_code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INT — NOT NULL
  • map_asset_url — VARCHAR(1000)
  • map_version — VARCHAR(50)
  • map_width — DECIMAL(12, 4)
  • map_height — DECIMAL(12, 4)
  • status — VARCHAR(30) — NOT NULL

keyword

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • category_code — VARCHAR(50)
  • name_i18n — JSON — NOT NULL
  • status — VARCHAR(30) — NOT NULL

map_edge

  • id — BIGINT — Primary key — NOT NULL
  • from_node_id — BIGINT — Foreign key → map_node.id — NOT NULL
  • to_node_id — BIGINT — Foreign key → map_node.id — NOT NULL
  • distance_meter — DECIMAL(12, 4) — NOT NULL
  • travel_seconds — INT
  • transport_type — VARCHAR(30) — NOT NULL
  • is_bidirectional — BOOLEAN — NOT NULL
  • status — VARCHAR(30) — NOT NULL

map_node

  • id — BIGINT — Primary key — NOT NULL
  • floor_id — BIGINT — Foreign key → floor.id — NOT NULL
  • node_type — VARCHAR(30) — NOT NULL
  • coordinate_x — DECIMAL(12, 4) — NOT NULL
  • coordinate_y — DECIMAL(12, 4) — NOT NULL
  • is_accessible — BOOLEAN — NOT NULL
  • status — VARCHAR(30) — NOT NULL

news_feed

  • id — BIGINT — Primary key — NOT NULL
  • primary_course_id — BIGINT — Foreign key → course.id — NOT NULL
  • primary_place_id — BIGINT — Foreign key → place.id — NOT NULL
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • author_user_id — BIGINT — Foreign key → user_account.id
  • language_code — VARCHAR(10) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • slug — VARCHAR(500) — NOT NULL
  • representative_image_url — VARCHAR(1000)
  • body — LONGTEXT — NOT NULL
  • keyword_ids — JSON
  • related_course_ids — JSON
  • related_place_ids — JSON
  • related_product_ids — JSON
  • author_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL

ocr_request

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id
  • store_branch_id — BIGINT — Foreign key → store_branch.id — NOT NULL
  • selected_place_id — BIGINT — Foreign key → place.id
  • image_url — VARCHAR(1000) — NOT NULL
  • recognized_text — TEXT
  • location_candidates — JSON
  • status — VARCHAR(30) — NOT NULL
  • image_expires_at — DATETIME
  • created_at — DATETIME — NOT NULL

place

  • id — BIGINT — Primary key — NOT NULL
  • primary_node_id — BIGINT — Foreign key → map_node.id — NOT NULL
  • floor_id — BIGINT — Foreign key → floor.id — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.id
  • place_type — VARCHAR(30) — NOT NULL
  • category_code — VARCHAR(50)
  • name — VARCHAR(200) — NOT NULL
  • name_i18n — JSON
  • description_i18n — JSON
  • image_url — VARCHAR(1000)
  • keyword_ids — JSON
  • business_hours — JSON
  • coordinate_x — DECIMAL(12, 4)
  • coordinate_y — DECIMAL(12, 4)
  • popup_starts_at — DATETIME
  • popup_ends_at — DATETIME
  • operation_status — VARCHAR(30) — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • category_code — VARCHAR(50)
  • image_url — VARCHAR(1000)
  • description_i18n — JSON
  • keyword_ids — JSON
  • status — VARCHAR(30) — NOT NULL

route_request

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.id
  • store_branch_id — BIGINT — Foreign key → store_branch.id — NOT NULL
  • course_id — BIGINT — Foreign key → course.id
  • target_course_place_id — BIGINT — Foreign key → course_place.id
  • start_node_id — BIGINT — Foreign key → map_node.id — NOT NULL
  • destination_node_id — BIGINT — Foreign key → map_node.id — NOT NULL
  • start_source — VARCHAR(30) — NOT NULL
  • path_node_ids — JSON
  • path_edge_ids — JSON
  • total_distance_meter — DECIMAL(12, 4)
  • total_travel_seconds — INT
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

store_branch

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL

trend_item

  • id — BIGINT — Primary key — NOT NULL
  • trend_snapshot_id — BIGINT — Foreign key → trend_snapshot.id — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.id
  • brand_id — BIGINT — Foreign key → brand.id
  • product_id — BIGINT — Foreign key → product.id
  • place_id — BIGINT — Foreign key → place.id
  • course_id — BIGINT — Foreign key → course.id
  • item_type — VARCHAR(30) — NOT NULL
  • ranking — INT — NOT NULL
  • interest_score — DECIMAL(10, 4)
  • is_visible — BOOLEAN — NOT NULL

trend_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • period_type — VARCHAR(30) — NOT NULL
  • collected_at — DATETIME — NOT NULL

user_account

  • id — BIGINT — Primary key — NOT NULL
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • preferred_language_code — VARCHAR(10) — NOT NULL
  • role_type — VARCHAR(30) — NOT NULL
  • interest_keyword_ids — JSON
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME