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`