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)