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