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 (알림 수신 여부)