모셔용

테이블 (30)

chat_messages

  • id — BIGINT — 기본 키 — NOT NULL
  • chat_session_id — BIGINT — 외래 키 → chat_sessions.id — NOT NULL
  • sender — ENUM('user','assistant') — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_sessions

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id
  • context_place_id — BIGINT — 외래 키 → places.id
  • created_at — DATETIME — NOT NULL

families

  • id — BIGINT — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

family_members

  • id — BIGINT — 기본 키 — NOT NULL
  • family_id — BIGINT — 외래 키 → families.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • member_role — ENUM('child','parent') — NOT NULL
  • relation_label — VARCHAR(20)
  • joined_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

filial_reports

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id — NOT NULL
  • total_score — SMALLINT
  • satisfaction_score — SMALLINT
  • rest_interval_score — SMALLINT
  • walk_burden_score — SMALLINT
  • summary — VARCHAR(255)
  • best_place_id — BIGINT — 외래 키 → places.id
  • generated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

health_constraints

  • id — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • label — VARCHAR(60) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

invite_codes

  • id — BIGINT — 기본 키 — NOT NULL
  • family_id — BIGINT — 외래 키 → families.id — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • status — ENUM('active','used','expired') — NOT NULL
  • created_by_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • used_by_user_id — BIGINT — 외래 키 → users.id
  • expires_at — DATETIME
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

parent_personality_results

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_profile_id — BIGINT — 외래 키 → parent_profiles.id — NOT NULL
  • travel_personality_type_id — BIGINT — 외래 키 → travel_personality_types.id — NOT NULL
  • is_current — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

parent_personality_scores

  • id — BIGINT — 기본 키 — NOT NULL
  • result_id — BIGINT — 외래 키 → parent_personality_results.id — NOT NULL
  • metric_code — VARCHAR(40) — NOT NULL
  • score — SMALLINT — NOT NULL

parent_profile_constraints

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_profile_id — BIGINT — 외래 키 → parent_profiles.id — NOT NULL
  • health_constraint_id — BIGINT — 외래 키 → health_constraints.id — NOT NULL

parent_profile_themes

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_profile_id — BIGINT — 외래 키 → parent_profiles.id — NOT NULL
  • travel_theme_id — BIGINT — 외래 키 → travel_themes.id — NOT NULL

parent_profiles

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • fitness_level — SMALLINT — NOT NULL
  • activity_level — ENUM('slow','moderate','active') — NOT NULL
  • food_preference — ENUM('korean_only','open_minded') — NOT NULL
  • avoid_spicy — BOOLEAN — NOT NULL
  • mobility_aid — ENUM('none','cane','walker','wheelchair') — NOT NULL
  • completion_percent — SMALLINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

place_accessibility

  • id — BIGINT — 기본 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → places.id — NOT NULL
  • has_stairs — BOOLEAN
  • has_slope — BOOLEAN
  • is_indoor — BOOLEAN
  • has_elevator — BOOLEAN
  • has_seating — BOOLEAN
  • wheelchair_accessible — BOOLEAN
  • restroom_distance_m — INT
  • accessibility_score — SMALLINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

places

  • id — BIGINT — 기본 키 — NOT NULL
  • tour_api_content_id — VARCHAR(20)
  • content_type_id — VARCHAR(10)
  • region_id — BIGINT — 외래 키 → regions.id
  • name — VARCHAR(120) — NOT NULL
  • category — VARCHAR(40)
  • address — VARCHAR(255)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • phone — VARCHAR(30)
  • homepage_url — VARCHAR(500)
  • image_url — VARCHAR(500)
  • operating_hours — VARCHAR(255)
  • admission_fee — VARCHAR(100)
  • overview — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pledge_items

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_pledge_id — BIGINT — 외래 키 → trip_pledges.id — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_from_template — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pledge_signatures

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_pledge_id — BIGINT — 외래 키 → trip_pledges.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • signature_image_url — VARCHAR(500)
  • signed_at — DATETIME
  • created_at — DATETIME — NOT NULL

recommendation_adjustments

  • id — BIGINT — 기본 키 — NOT NULL
  • parent_profile_id — BIGINT — 외래 키 → parent_profiles.id — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id
  • adjustment_code — VARCHAR(40) — NOT NULL
  • adjustment_value — DECIMAL(6,3) — NOT NULL
  • created_at — DATETIME — NOT NULL

regions

  • id — BIGINT — 기본 키 — NOT NULL
  • area_code — VARCHAR(10)
  • sido — VARCHAR(30) — NOT NULL
  • sigungu — VARCHAR(40)
  • name — VARCHAR(60) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

travel_personality_types

  • id — BIGINT — 기본 키 — NOT NULL
  • type_code — VARCHAR(8) — NOT NULL
  • name — VARCHAR(40) — NOT NULL
  • description — TEXT
  • recommendation_principle — TEXT
  • character_image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

travel_themes

  • id — BIGINT — 기본 키 — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • label — VARCHAR(40) — NOT NULL
  • tour_api_category — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_days

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id — NOT NULL
  • day_number — SMALLINT — NOT NULL
  • travel_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_feedback_tags

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_feedback_id — BIGINT — 외래 키 → trip_feedbacks.id — NOT NULL
  • tag — ENUM('walk_comfortable','rest_enough','food_satisfied','restroom_easy','quiet_good','want_again','time_with_family_good','stairs_many','walk_long','rest_needed','crowded','cold','long_car_ride','next_indoor') — NOT NULL

trip_feedbacks

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id — NOT NULL
  • parent_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • overall_rating — DECIMAL(2,1)
  • walk_rating — SMALLINT
  • rest_rating — SMALLINT
  • submitted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_participants

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

trip_pledges

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_id — BIGINT — 외래 키 → trips.id — NOT NULL
  • title — VARCHAR(80)
  • signature_image_url — VARCHAR(500)
  • shared_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_stops

  • id — BIGINT — 기본 키 — NOT NULL
  • trip_day_id — BIGINT — 외래 키 → trip_days.id — NOT NULL
  • place_id — BIGINT — 외래 키 → places.id — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • stop_type — ENUM('sightseeing','meal','rest','cafe') — NOT NULL
  • arrival_time — TIME
  • dwell_minutes — SMALLINT
  • note — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trips

  • id — BIGINT — 기본 키 — NOT NULL
  • family_id — BIGINT — 외래 키 → families.id — NOT NULL
  • created_by_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • region_id — BIGINT — 외래 키 → regions.id — NOT NULL
  • title — VARCHAR(80) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — ENUM('planning','ready','in_progress','completed','archived') — NOT NULL
  • preference_weight — ENUM('parent_only','include_child') — NOT NULL
  • pace — ENUM('relaxed','moderate','packed') — NOT NULL
  • comfort_score — SMALLINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

user_consents

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • consent_type — ENUM('privacy','location','feedback_learning') — NOT NULL
  • agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

user_settings

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • schedule_share_noti — BOOLEAN — NOT NULL
  • trip_day_noti — BOOLEAN — NOT NULL
  • feedback_request_noti — BOOLEAN — NOT NULL
  • location_permission — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • role — ENUM('child','parent') — NOT NULL
  • oauth_provider — ENUM('kakao','apple','naver','google') — NOT NULL
  • oauth_subject — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(50)
  • age_band — VARCHAR(10) — NOT NULL
  • gender — ENUM('female','male','undisclosed')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME