Plamingo
Tables (33)
activity_logs
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- member_id — bigint — Foreign key → members.id
- action_type — varchar(30) — NOT NULL
- target_type — varchar(30)
- target_id — bigint
- description — varchar(500) — NOT NULL
- metadata_json — json
- created_at — datetime — NOT NULL
card_comments
- id — bigint — Primary key — NOT NULL
- plan_card_id — bigint — Foreign key → plan_cards.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
categories
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- name — varchar(50) — NOT NULL
- category_type — varchar(30) — NOT NULL
- marker_color — varchar(20) — NOT NULL
- marker_icon — varchar(50) — NOT NULL
- sort_order — int — NOT NULL
expense_participants
- id — bigint — Primary key — NOT NULL
- expense_id — bigint — Foreign key → expenses.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- share_amount — decimal(12,2) — NOT NULL
- created_at — datetime — NOT NULL
- settlement_status — varchar(20) — NOT NULL
- settled_at — datetime
expenses
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- payer_id — bigint — Foreign key → members.id — NOT NULL
- title — varchar(100) — NOT NULL
- category — varchar(30) — NOT NULL
- total_amount — decimal(12,2) — NOT NULL
- currency — varchar(10) — NOT NULL
- exchange_rate — decimal(18,8)
- converted_amount — decimal(12,2)
- expense_date — date — NOT NULL
- split_type — varchar(20) — NOT NULL
- receipt_url — varchar(500)
- memo — text
- created_by — bigint — Foreign key → members.id — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
flyway_schema_history
- installed_rank — int — Primary key — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — int
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — int — NOT NULL
- success — tinyint(1) — NOT NULL
guest_sessions
- id — bigint — Primary key — NOT NULL
- token_hash — char(64) — NOT NULL
- expires_at — datetime — NOT NULL
- claimed_at — datetime
- created_at — datetime — NOT NULL
itinerary_days
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- itinerary_date — date — NOT NULL
- day_number — int — NOT NULL
- title — varchar(100)
- description — text
- status — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- departure_type — varchar(20) — 출발지 타입 (TRIP_PLACE|CUSTOM)
- departure_name — varchar(100) — 출발지 표시 이름
- departure_lat — decimal(9, 6) — 출발지 위도
- departure_lng — decimal(9, 6) — 출발지 경도
- departure_trip_place_id — bigint — 저장된 장소 기반 출발지일 때 trip_place_id
- departure_travel_minutes — int — 출발지 → 첫 장소 이동 시간(분)
- departure_travel_meters — int — 출발지 → 첫 장소 이동 거리(m)
- departure_travel_mode — varchar(20) — 출발지 → 첫 장소 이동수단
itinerary_items
- id — bigint — Primary key — NOT NULL
- itinerary_day_id — bigint — Foreign key → itinerary_days.id — NOT NULL
- trip_place_id — bigint — Foreign key → trip_places.id
- title — varchar(100)
- start_time — time
- end_time — time
- sort_order — int — NOT NULL
- transport_minutes — int
- transport_meters — int — 이동 거리(미터)
- transport_mode — varchar(20) — 이동 수단(도보/대중교통/자동차)
- transport_detail — varchar(255) — 노선, 역, 정류장 등 이동 상세 정보
- transport_mode_manual — tinyint(1) — NOT NULL — 사용자가 직접 선택한 이동수단 여부
- transport_mode_preference — varchar(20) — 사용자가 선택한 이동수단 enum 값
- transport_distance_meters — int
- memo — text
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
members
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- nickname — varchar(50) — NOT NULL
- profile_image_url — varchar(500)
- provider — varchar(20) — NOT NULL
- provider_id — varchar(255) — NOT NULL
- password_hash — varchar(100)
- email_verified_at — datetime
- default_region — varchar(255)
- status — varchar(20) — NOT NULL
- last_login_at — datetime
- withdrawn_at — datetime
- personal_info_expires_at — datetime
- personal_info_deleted_at — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- local_email — varchar(255)
- local_nickname — varchar(50)
notifications
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- trip_id — bigint — Foreign key → trips.id
- notification_type — varchar(30) — NOT NULL
- title — varchar(100)
- content — varchar(500) — NOT NULL
- target_type — varchar(30)
- target_id — bigint
- is_read — tinyint(1) — NOT NULL
- read_at — datetime
- created_at — datetime — NOT NULL
place_comments
- id — bigint — Primary key — NOT NULL
- trip_place_id — bigint — Foreign key → trip_places.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- content — varchar(500) — NOT NULL
- created_at — datetime — NOT NULL
place_graph_edges
- id — bigint — Primary key — NOT NULL
- from_place_id — bigint — Foreign key → places.id — NOT NULL
- to_place_id — bigint — Foreign key → places.id — NOT NULL
- transport_type — varchar(30) — NOT NULL
- distance_meters — int — NOT NULL
- travel_minutes — int — NOT NULL
- compatibility_score — decimal(5,4)
- source — varchar(30) — NOT NULL
- cached_at — datetime — NOT NULL
- expires_at — datetime
place_style_tags
- id — bigint — Primary key — NOT NULL
- place_id — bigint — Foreign key → places.id — NOT NULL
- style_type — varchar(30) — NOT NULL
- suitability_score — decimal(5,4) — NOT NULL
- source — varchar(30) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
place_vote_requests
- id — bigint — Primary key — NOT NULL
- trip_place_id — bigint — Foreign key → trip_places.id — NOT NULL
- created_by — bigint — Foreign key → members.id — NOT NULL
- status — varchar(20) — NOT NULL
- required_response_count — int — NOT NULL
- total_member_count — int — NOT NULL
- created_at — datetime — NOT NULL
- expires_at — datetime — NOT NULL
- closed_at — datetime
place_vote_responses
- id — bigint — Primary key — NOT NULL
- vote_request_id — bigint — Foreign key → place_vote_requests.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- choice_value — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
places
- id — bigint — Primary key — NOT NULL
- google_place_id — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- address — varchar(500)
- latitude — decimal(10, 7) — NOT NULL
- longitude — decimal(10, 7) — NOT NULL
- place_type — varchar(100)
- google_photo_name — varchar(1000)
- opening_hours_json — text — Google Places API opening_hours JSON
- image_url — varchar(500)
- website_url — varchar(500)
- phone_number — varchar(50)
- business_status — varchar(30)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
plan_card_tags
- id — bigint — Primary key — NOT NULL
- plan_card_id — bigint — Foreign key → plan_cards.id — NOT NULL
- tag_id — bigint — Foreign key → trip_tags.id — NOT NULL
- created_at — datetime — NOT NULL
plan_cards
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- title — varchar(100) — NOT NULL
- summary — text
- cover_image_url — varchar(500)
- visibility — varchar(20) — NOT NULL
- created_by — bigint — Foreign key → members.id — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
saved_trips
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- saved_at — datetime — NOT NULL
travel_photos
- id — bigint — Primary key — NOT NULL
- travel_record_id — bigint — Foreign key → travel_records.id — NOT NULL
- uploaded_by — bigint — Foreign key → members.id — NOT NULL
- image_url — varchar(500) — NOT NULL
- thumbnail_url — varchar(500)
- sort_order — int — NOT NULL
- created_at — datetime — NOT NULL
travel_records
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- itinerary_item_id — bigint — Foreign key → itinerary_items.id
- place_id — bigint — Foreign key → places.id — NOT NULL
- recorded_by — bigint — Foreign key → members.id — NOT NULL
- visited_at — datetime — NOT NULL
- memo — text
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
trip_date_availabilities
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- available_date — date — NOT NULL
- created_at — datetime — NOT NULL
trip_date_proposals
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- proposed_by — bigint — Foreign key → members.id — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
trip_date_votes
- id — bigint — Primary key — NOT NULL
- proposal_id — bigint — Foreign key → trip_date_proposals.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- choice — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
trip_guest_members
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- guest_session_id — bigint — Foreign key → guest_sessions.id — NOT NULL
- role — varchar(20) — NOT NULL
- joined_at — datetime — NOT NULL
trip_invitations
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- invite_code — varchar(100) — NOT NULL
- created_by — bigint — Foreign key → members.id — NOT NULL
- expires_at — datetime — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — datetime — NOT NULL
trip_members
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- role — varchar(20) — NOT NULL
- joined_at — datetime — NOT NULL
trip_places
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- place_id — bigint — Foreign key → places.id — NOT NULL
- category_id — bigint — Foreign key → categories.id — NOT NULL
- added_by — bigint — Foreign key → members.id — NOT NULL
- status — varchar(20) — NOT NULL
- priority — int
- user_note — text
- ai_note — text
- preferred_time — varchar(30)
- estimated_stay_minutes — int
- marker_color — varchar(20)
- marker_icon — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
trip_retrospectives
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- member_id — bigint — Foreign key → members.id — NOT NULL
- good_points — text
- improvements — text
- summary — text
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
trip_tags
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- name — varchar(50) — NOT NULL
- color — varchar(20)
- icon — varchar(50)
- created_by — bigint — Foreign key → members.id — NOT NULL
- sort_order — int — NOT NULL
- created_at — datetime — NOT NULL
trip_travel_styles
- travel_style — varchar(30) — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
trips
- id — bigint — Primary key — NOT NULL
- owner_id — bigint — Foreign key → members.id — NOT NULL
- title — varchar(100) — NOT NULL
- description — text
- destination — varchar(100)
- start_date — date
- end_date — date
- cover_image_url — varchar(500)
- transport_type — varchar(30)
- companion_type — varchar(30)
- travel_style — varchar(30)
- activity_level — varchar(20)
- status — varchar(20) — NOT NULL
- budget_per_person — decimal(12, 2)
- total_budget — decimal(12, 2)
- currency — varchar(10) — NOT NULL
- meeting_place_id — bigint — Foreign key → places.id
- visibility — varchar(20) — NOT NULL
- completion_confirmed_at — datetime
- view_count — bigint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- day_start_time — time — NOT NULL — 하루 일정 시작 시간
- day_end_time — time — NOT NULL — 하루 일정 종료 시간
- travel_pace — varchar(20) — NOT NULL — 여행 페이스 (FAST/NORMAL/RELAXED)
- destination_lat — double
- destination_lng — double
- destination_english_name — varchar(100)
- destination_country_code — varchar(2)