TripMate

Tables (15)

accommodation_info

  • accommodation_id — INT
  • plan_id — INT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(300)
  • city — VARCHAR(100)
  • check_in_date — DATE
  • check_out_date — DATE
  • room_type — VARCHAR(100)
  • price_per_night — DECIMAL(10, 2)
  • total_price — DECIMAL(10, 2)
  • rating — DECIMAL(2, 1)
  • booking_url — VARCHAR(500)
  • amenities — TEXT
  • notes — TEXT
  • is_selected — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_plan_id

ai_recommendations

  • recommendation_id — INT
  • plan_id — INT — NOT NULL
  • recommendation_type — ENUM('flight', 'accommodation', 'destination') — NOT NULL
  • prompt — TEXT
  • response — TEXT
  • created_at — TIMESTAMP
  • INDEX — idx_plan_id

board_comments

  • comment_id — INT
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • parent_comment_id — INT — 대댓글인 경우 부모 댓글 ID
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_post_id
  • INDEX — idx_user_id
  • INDEX — idx_parent_comment — parent_comment_id

board_posts

  • post_id — INT
  • plan_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • thumbnail_url — VARCHAR(255)
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • is_featured — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_user_id
  • INDEX — idx_created_at
  • INDEX — idx_view_count
  • INDEX — idx_like_count

bookmarks

  • bookmark_id — INT
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_user_id

destinations

  • destination_id — INT
  • plan_id — INT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(50)
  • address — VARCHAR(300)
  • city — VARCHAR(100)
  • visit_date — DATE
  • visit_time — TIME
  • duration — INT — 방문 예상 시간 (분)
  • entry_fee — DECIMAL(10, 2)
  • rating — DECIMAL(2, 1)
  • description — TEXT
  • website_url — VARCHAR(500)
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • notes — TEXT
  • is_selected — BOOLEAN
  • display_order — INT
  • created_at — TIMESTAMP
  • INDEX — idx_plan_id
  • INDEX — idx_visit_date

flight_info

  • flight_id — INT
  • plan_id — INT — NOT NULL
  • airline — VARCHAR(100)
  • flight_number — VARCHAR(20)
  • departure_airport — VARCHAR(100)
  • arrival_airport — VARCHAR(100)
  • departure_time — DATETIME
  • arrival_time — DATETIME
  • price — DECIMAL(10, 2)
  • booking_url — VARCHAR(500)
  • seat_class — VARCHAR(50)
  • notes — TEXT
  • is_selected — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_plan_id

password_reset_tokens

  • token_id — INT
  • user_id — INT — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_token

post_likes

  • like_id — INT
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_post_id
  • INDEX — idx_user_id

record_images

  • image_id — INT
  • record_id — INT — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • caption — TEXT
  • display_order — INT
  • uploaded_at — TIMESTAMP
  • INDEX — idx_record_id

templates

  • template_id — INT
  • template_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50)
  • thumbnail_url — VARCHAR(255)
  • is_default — BOOLEAN
  • created_at — TIMESTAMP
  • usage_count — INT
  • INDEX — idx_category

travel_plans

  • plan_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • departure_city — VARCHAR(100)
  • arrival_city — VARCHAR(100)
  • departure_date — DATE
  • arrival_date — DATE
  • adult_count — INT
  • child_count — INT
  • is_template — BOOLEAN
  • is_public — BOOLEAN
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_user_id
  • INDEX — idx_is_public
  • INDEX — idx_created_at

travel_records

  • record_id — INT
  • plan_id — INT — NOT NULL
  • record_date — DATE — NOT NULL
  • record_time — TIME
  • title — VARCHAR(200)
  • content — TEXT
  • location — VARCHAR(200)
  • weather — VARCHAR(50)
  • mood — VARCHAR(50)
  • expense — DECIMAL(10, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_plan_id
  • INDEX — idx_record_date

user_sessions

  • session_id — VARCHAR(255)
  • user_id — INT — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(500)
  • created_at — TIMESTAMP
  • expires_at — TIMESTAMP — NOT NULL
  • INDEX — idx_user_id
  • INDEX — idx_expires_at

users

  • user_id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • profile_image — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login — TIMESTAMP
  • status — ENUM('active', 'inactive', 'suspended')
  • INDEX — idx_email