Trip Board(old)

Tables (15)

ai_recommendations

  • recommendation_id — BIGINT
  • plan_id — BIGINT — NOT NULL
  • recommendation_type — VARCHAR(50)
  • content_id — VARCHAR(50)
  • title — VARCHAR(200)
  • description — TEXT
  • reason — TEXT
  • created_at — DATETIME
  • INDEX — idx_plan_id
  • INDEX — idx_type

board_comments

  • comment_id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → board_posts.post_id
  • user_id — BIGINT — Foreign key → users.user_id
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_post_id

board_posts

  • post_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • plan_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • region_code — VARCHAR(10)
  • trip_type — VARCHAR(50)
  • season — VARCHAR(20)
  • view_count — INT
  • like_count — INT
  • is_public — BOOLEAN
  • category — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_user_id
  • INDEX — idx_region_code
  • INDEX — idx_is_public

bookmarks

  • bookmark_id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → board_posts.post_id
  • user_id — BIGINT — Foreign key → users.user_id
  • plan_id — BIGINT
  • created_at — DATETIME
  • INDEX — idx_user_id

plan_accommodations

  • plan_accommodation_id — BIGINT — Primary key
  • plan_id — BIGINT — Foreign key → travel_plans.plan_id
  • content_id — VARCHAR(50)
  • check_in_date — DATE
  • check_out_date — DATE
  • is_selected — BOOLEAN
  • created_at — DATETIME
  • INDEX — idx_plan_id

plan_destinations

  • plan_destination_id — BIGINT — Primary key
  • plan_id — BIGINT — Foreign key → travel_plans.plan_id
  • content_id — VARCHAR(50)
  • visit_date — DATE
  • visit_time — TIME
  • duration — INT
  • is_selected — BOOLEAN
  • created_at — DATETIME
  • INDEX — idx_plan_id

post_likes

  • like_id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → board_posts.post_id
  • user_id — BIGINT — Foreign key → users.user_id
  • created_at — DATETIME

record_images

  • image_id — BIGINT — Primary key
  • record_id — BIGINT — Foreign key → travel_records.record_id
  • image_url — TEXT
  • image_order — INT
  • created_at — DATETIME
  • INDEX — idx_record_id

templates

  • template_id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50)
  • structure — TEXT
  • is_default — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

tour_api_cache

  • cache_id — BIGINT
  • content_id — VARCHAR(50) — NOT NULL
  • content_type_id — VARCHAR(10)
  • title — VARCHAR(500)
  • area_code — VARCHAR(10)
  • sigungu_code — VARCHAR(10)
  • cat1 — VARCHAR(10)
  • cat2 — VARCHAR(10)
  • cat3 — VARCHAR(10)
  • addr1 — VARCHAR(500)
  • addr2 — VARCHAR(500)
  • map_x — VARCHAR(50)
  • map_y — VARCHAR(50)
  • first_image — VARCHAR(500)
  • first_image2 — VARCHAR(500)
  • overview — TEXT
  • is_pet_friendly — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_area_code
  • INDEX — idx_content_type
  • INDEX — idx_pet_friendly

transportation_info

  • transportation_id — BIGINT — Primary key
  • plan_id — BIGINT — Foreign key → travel_plans.plan_id
  • transport_type — VARCHAR(50)
  • departure_location — VARCHAR(200)
  • arrival_location — VARCHAR(200)
  • departure_time — DATETIME
  • arrival_time — DATETIME
  • price — INT
  • reservation_url — VARCHAR(500)
  • is_selected — BOOLEAN
  • created_at — DATETIME
  • INDEX — idx_plan_id

travel_plans

  • plan_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200)
  • departure_region_code — VARCHAR(10)
  • arrival_region_code — VARCHAR(10)
  • departure_date — DATE
  • arrival_date — DATE
  • adult_count — INT
  • child_count — INT
  • has_pet — BOOLEAN
  • template_id — BIGINT
  • is_public — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_user_id
  • INDEX — idx_is_public

travel_records

  • record_id — BIGINT
  • plan_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_plan_id
  • INDEX — idx_user_id

user_travel_preferences

  • preference_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • preferred_trip_type — VARCHAR(50)
  • preferred_activities — TEXT
  • budget_preference — VARCHAR(50)
  • accommodation_preference — VARCHAR(50)
  • season_preference — VARCHAR(50)
  • transportation_preference — VARCHAR(50)
  • food_preference — VARCHAR(50)
  • travel_style — VARCHAR(50)
  • additional_info — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_user_id

users

  • user_id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)
  • phone — VARCHAR(20)
  • profile_image — TEXT
  • role — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_email