service

Tables (10)

budget_type_detail (지갑 기준)

  • Key (budget_type_id) — Primary key — NOT NULL
  • Key (preference_id) — Foreign key → travel_style.style_id — NOT NULL
  • min_budget (최소 예산)
  • max_budget (최대 예산)

course (경로)

  • course_id (Key) — Primary key — NOT NULL
  • name (코스 이름)
  • type (유형)
  • coast (비용)
  • location (위치)

goal_type_detail (목표 기준)

  • Key (goal_type_id) — Primary key — NOT NULL
  • Key (preference_id) — Foreign key → travel_style.style_id — NOT NULL
  • country (나라)
  • max_food_budget (최소 한 끼 지출 금액)

notification (알림)

  • notification_id (Key) — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • content (내용)
  • is_read (읽음 여부)

recommended_travel (추천 여행 목록)

  • recommended_id (Key) — Primary key — NOT NULL
  • style_id (id) — Foreign key → travel_style.style_id — NOT NULL
  • travel_id — Foreign key → travels.travel_id — NOT NULL
  • is_selected (선택 여부)

social_account (소셜 로그인)

  • socila_account_id (Key) — Primary key — NOT NULL
  • provider (Field2)
  • provider_user_id (Field)
  • user_id — Foreign key → users.user_id — NOT NULL

travel_course (여행 경로)

  • travel_course_id (Key) — Primary key — NOT NULL
  • Key (travel_id) — Foreign key → travels.travel_id — NOT NULL
  • course_id (Key2) — Foreign key → course.course_id — NOT NULL

travel_style (유형 선택)

  • style_id (id) — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • type (여행 유형) — enum
  • depart_date (출발 날짜)
  • arrive_date (도착 날짜)
  • traveler_count (여행 인원)
  • traveler_type (구성원 유형)
  • travle_style (선호 여행 유형)
  • airline_type (항공권 유형)
  • lodging_type (숙소 유형)

travels (여행)

  • travel_id — Primary key — NOT NULL
  • country (나라명)
  • lodging_type (숙소 유형)
  • airline_type (항공 유형)

users (사용자)

  • user_id — Primary key — NOT NULL
  • name (이름)
  • profile_url (프로필이미지)
  • email (가입 이메일)
  • is_alarm (알림 수신 여부)