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