모셔용
테이블 (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