db

Tables (29)

bookmark

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • updated_at — DATETIME(6)
  • json — TEXT
  • INDEX — `FKne2a5hh2hcvrhtx8vyqybg3tx`
  • INDEX — `FK5bm7rup91j277mc7gg63akie2`

category

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • name — VARCHAR(10) — NOT NULL

city

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • lat — DOUBLE
  • lon — DOUBLE
  • news_penalty_score — DOUBLE
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • city_name — VARCHAR(50)
  • description — TEXT
  • img_url — TEXT
  • INDEX — `FKrpd7j1p7yxr784adkx4pyepba`

city_climate_tag

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • month — BIGINT — NOT NULL
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — `FKre0ncobp35c8g6kf8i1dwrxya`
  • INDEX — `FKp4s9itmv6vtimot6q8y13w0sh`

city_tag

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • tag_score — DOUBLE
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — `FKb4y91h6i2qx3i40su2lrncf0p`
  • INDEX — `FKbq0h6344yr2jbera7hhpqj6wi`

city_view_history

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — `FKf2jutgs69tt63aixeir1oawap`
  • INDEX — `FK61n401r2k5o3a775iwavyrax2`

climate

  • id — BIGINT — Primary key — NOT NULL
  • humidity — DOUBLE
  • is_deleted — BIT(1)
  • month — INT
  • precipitation — DOUBLE
  • snowfall — DOUBLE
  • temperature — DOUBLE
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • INDEX — `FK4b16l3lvhq3oiu7otc3yysx1d`

country

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • lat — DOUBLE
  • lon — DOUBLE
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • country_name — VARCHAR(50)
  • img_url — TEXT
  • continent — ENUM('AFRICA', 'ASIA', 'EUROPE', 'NORTH_AMERICA', 'OCEANIA', 'SOUTH_AMERICA')
  • currency — ENUM('AED', 'ARS', 'AUD', 'BOB', 'BRL', 'CAD', 'CHF', 'CLP', 'CNY', 'CUP', 'CZK', 'DKK', 'EGP', 'EUR', 'GBP', 'HKD', 'HUF', 'IDR', 'INR', 'ISK', 'JPY', 'KES', 'KHR', 'KRW', 'KZT', 'LAK', 'MAD', 'MNT', 'MOP', 'MUR', 'MVR', 'MXN', 'MYR', 'NOK', 'NPR', 'NZD', 'PEN', 'PHP', 'PLN', 'QAR', 'RUB', 'SEK', 'SGD', 'THB', 'TRY', 'TWD', 'USD', 'VND', 'ZAR') — NOT NULL

country_top

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • ranking — INT
  • country_id — BIGINT — Foreign key → country.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • INDEX — `FKevtn4su91b87lnfma0va6wjxo`

danger

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • attention — VARCHAR(10)
  • control — VARCHAR(10)
  • limita — VARCHAR(10)
  • country_name — VARCHAR(20)
  • country_en_name — VARCHAR(100)
  • attention_note — VARCHAR(255)
  • attention_partial — VARCHAR(255)
  • ban_note — VARCHAR(255)
  • ban_yn_partial — VARCHAR(255)
  • ban_yna — VARCHAR(255)
  • control_note — VARCHAR(255)
  • control_partial — VARCHAR(255)
  • evacuate_rcmnd_remark — VARCHAR(255)
  • evacuate_region_ty — VARCHAR(255)
  • forbidden__region_ty — VARCHAR(255)
  • forbidden_rcmnd_remark — VARCHAR(255)
  • limita_note — VARCHAR(255)
  • limita_partial — VARCHAR(255)
  • INDEX — `FKonw5f3hfp05f1t2volqfh83m7`

exchanges

  • id — BIGINT — Primary key — NOT NULL
  • display_unit — INT
  • event_date — DATE
  • is_deleted — BIT(1)
  • krw_per_1cur — DOUBLE
  • krw_per_display_unit — DOUBLE
  • rate_1krw_to_cur — DOUBLE
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • display_symbol — VARCHAR(15)
  • currency — ENUM('AED', 'ARS', 'AUD', 'BOB', 'BRL', 'CAD', 'CHF', 'CLP', 'CNY', 'CUP', 'CZK', 'DKK', 'EGP', 'EUR', 'GBP', 'HKD', 'HUF', 'IDR', 'INR', 'ISK', 'JPY', 'KES', 'KHR', 'KRW', 'KZT', 'LAK', 'MAD', 'MNT', 'MOP', 'MUR', 'MVR', 'MXN', 'MYR', 'NOK', 'NPR', 'NZD', 'PEN', 'PHP', 'PLN', 'QAR', 'RUB', 'SEK', 'SGD', 'THB', 'TRY', 'TWD', 'USD', 'VND', 'ZAR')

flight_summary

  • id — BIGINT — Primary key — NOT NULL
  • avg_flight_price — INT
  • avg_hotel_price — INT
  • flight_duration — INT
  • is_deleted — BIT(1)
  • stops — INT
  • city_id — BIGINT — Foreign key → city.id
  • created_at — DATETIME(6)
  • flight_collected_date — DATETIME(6)
  • hotel_collected_date — DATETIME(6)
  • updated_at — DATETIME(6)
  • off_month_list — VARCHAR(255)
  • origin_airport — VARCHAR(255)
  • peak_month_list — VARCHAR(255)
  • target_year_month — VARCHAR(255)

living_cost_of_city

  • id — BIGINT — Primary key — NOT NULL
  • apple — DOUBLE
  • banana — DOUBLE
  • beer — DOUBLE
  • beer_in_a_pub — DOUBLE
  • brand_jeans — DOUBLE
  • brand_sneakers — DOUBLE
  • bread — DOUBLE
  • cappuccino — DOUBLE
  • chicken — DOUBLE
  • cigarette — DOUBLE
  • cinema_ticket — DOUBLE
  • coke — DOUBLE
  • coke_pepsi — DOUBLE
  • cold_medicine — DOUBLE
  • daily_budget — DOUBLE
  • dinner_in_a_resturant_for_2 — DOUBLE
  • egg — DOUBLE
  • fast_food_meal — DOUBLE
  • food — DOUBLE — NOT NULL
  • gas_petrol — DOUBLE
  • gym_month — DOUBLE
  • haircut — DOUBLE
  • is_deleted — BIT(1)
  • local_transport_ticket — DOUBLE
  • lunch_menu — DOUBLE — NOT NULL
  • milk — DOUBLE
  • monthly_salary_after_tax — DOUBLE
  • monthly_ticket_local_transport — DOUBLE
  • onion — DOUBLE
  • orange — DOUBLE
  • population — DOUBLE — NOT NULL
  • potato — DOUBLE
  • rice — DOUBLE
  • shampoo — DOUBLE
  • steak — DOUBLE
  • taxi_ride — DOUBLE
  • toilet_paper — DOUBLE
  • tomato — DOUBLE
  • toothpaste — DOUBLE
  • transport — DOUBLE — NOT NULL
  • water — DOUBLE
  • wine — DOUBLE
  • without_rent — DOUBLE — NOT NULL
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • INDEX — `FKis009rqdjmen4mb8bjoqwv6wq`

living_cost_of_country

  • id — BIGINT — Primary key — NOT NULL
  • apple — DOUBLE
  • banana — DOUBLE
  • beer — DOUBLE
  • beer_in_a_pub — DOUBLE
  • brand_jeans — DOUBLE
  • brand_sneakers — DOUBLE
  • bread — DOUBLE
  • cappuccino — DOUBLE
  • chicken — DOUBLE
  • cigarette — DOUBLE
  • cinema_ticket — DOUBLE
  • coke — DOUBLE
  • coke_pepsi — DOUBLE
  • cold_medicine — DOUBLE
  • daily_budget — DOUBLE
  • dinner_in_a_resturant_for_2 — DOUBLE
  • egg — DOUBLE
  • fast_food_meal — DOUBLE
  • food — DOUBLE
  • gas_petrol — DOUBLE
  • gym_month — DOUBLE
  • haircut — DOUBLE
  • is_deleted — BIT(1)
  • local_transport_ticket — DOUBLE
  • lunch_menu — DOUBLE
  • milk — DOUBLE
  • monthly_salary_after_tax — DOUBLE
  • monthly_ticket_local_transport — DOUBLE
  • onion — DOUBLE
  • orange — DOUBLE
  • population — DOUBLE
  • potato — DOUBLE
  • rice — DOUBLE
  • shampoo — DOUBLE
  • steak — DOUBLE
  • taxi_ride — DOUBLE
  • toilet_paper — DOUBLE
  • tomato — DOUBLE
  • toothpaste — DOUBLE
  • transport — DOUBLE
  • water — DOUBLE
  • wine — DOUBLE
  • without_rent — DOUBLE
  • country_id — BIGINT — Foreign key → country.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • INDEX — `FK1ijl0vpfaaitwkr3lai02iye3`

member

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • created_at — DATETIME(6)
  • deleted_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • role — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • social_id — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • profileImageUrl — TEXT

member_tag

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • is_from_youtube — BIT(1)
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — `FKgodbg35wb92j09pt5pi64udco`
  • INDEX — `FKcg8t5r0fghpy478wylesc2sfj`

spot_tags

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • score — DOUBLE — NOT NULL
  • created_at — DATETIME(6)
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL
  • tourist_spot_id — BIGINT — Foreign key → tourist_spot.id — NOT NULL
  • updated_at — DATETIME(6)
  • INDEX — `FKmtduti60ub98oolsjtn1denmw`
  • INDEX — `FK7p6ftuklgcvinq5i622e51ml7`

tag

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • category_id — BIGINT — Foreign key → category.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • name — VARCHAR(10) — NOT NULL
  • INDEX — `FKruoloyh4bf4kdko2ccv18xyyx`

tourist_spot

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • lat — DOUBLE
  • lon — DOUBLE
  • city_id — BIGINT — Foreign key → city.id — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • tourist_name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • INDEX — `FKeej4nk6ufih18jd8mghfn8pte`

youtube_account

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • created_at — DATETIME(6)
  • last_synced_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • token_expires_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • google_email — VARCHAR(100)
  • youtube_channel_id — VARCHAR(100)
  • access_token — TEXT
  • refresh_token — TEXT
  • sync_status — ENUM('FAILED', 'PENDING', 'SYNCED') — NOT NULL

youtube_interest_keyword

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • score — DOUBLE — NOT NULL
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • analyzed_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • keyword — VARCHAR(100) — NOT NULL
  • normalized_keyword — VARCHAR(100)
  • source_type — ENUM('LIKED_VIDEO_TAG', 'LIKED_VIDEO_TITLE', 'PLAYLIST_TITLE', 'PLAYLIST_VIDEO_TAG', 'PLAYLIST_VIDEO_TITLE', 'SUBSCRIPTION_TITLE') — NOT NULL
  • INDEX — `FKl5ido3f6fes3vj684up6kcxaf`

youtube_liked_video

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • collected_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • liked_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • video_id — BIGINT — Foreign key → youtube_video.id — NOT NULL
  • INDEX — `FKi8sc7mc5wyctg9n6hte4723fx`
  • INDEX — `FK4ahb89q64a67rw8v0r08kxddc`

youtube_playlist

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • collected_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • youtube_playlist_id — VARCHAR(100) — NOT NULL
  • title — VARCHAR(255)
  • privacy_status — ENUM('PRIVATE', 'PUBLIC', 'UNLISTED') — NOT NULL
  • INDEX — `FKq6c907af9mntac8ryvmmtdlcw`

youtube_playlist_video

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • position — INT
  • collected_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • playlist_id — BIGINT — Foreign key → youtube_playlist.id — NOT NULL
  • updated_at — DATETIME(6)
  • video_id — BIGINT — Foreign key → youtube_video.id — NOT NULL
  • INDEX — `FKrn1pfh8daasvb6lc4oib60l7y`
  • INDEX — `FK9l34o9vba7yjnpty0t0ck703g`

youtube_subscription

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • collected_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • subscribed_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • youtube_channel_id — VARCHAR(100) — NOT NULL
  • description — TEXT
  • title — VARCHAR(255)
  • INDEX — `FKt0vgv4krp4jb43n6ylq2p8k2b`

youtube_sync_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • collected_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • raw_json — LONGTEXT
  • snapshot_type — ENUM('FULL_SYNC', 'LIKED_VIDEOS', 'PLAYLISTS', 'PLAYLIST_ITEMS', 'SUBSCRIPTIONS', 'VIDEO_DETAILS') — NOT NULL
  • INDEX — `FKheegm4icu8xwfw1xp6u2n4e2q`

youtube_travel_tag

  • id — BIGINT — Primary key — NOT NULL
  • confidence — DOUBLE — NOT NULL
  • is_deleted — BIT(1)
  • score — DOUBLE — NOT NULL
  • account_id — BIGINT — Foreign key → youtube_account.id — NOT NULL
  • analyzed_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • category_name — VARCHAR(50) — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL
  • reason — VARCHAR(500)
  • INDEX — `FKj2r1wxp0axyordteypksigcdy`

youtube_video

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • category_id — VARCHAR(20)
  • youtube_video_id — VARCHAR(50) — NOT NULL
  • channel_title — VARCHAR(100)
  • title — VARCHAR(255)

youtube_video_tag

  • id — BIGINT — Primary key — NOT NULL
  • is_deleted — BIT(1)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • video_id — BIGINT — Foreign key → youtube_video.id — NOT NULL
  • tag_name — VARCHAR(100) — NOT NULL
  • INDEX — `FKih01lu8mkutaai52dn24mswm7`