TripLinker

Tables (28)

ADMIN_LOGS

  • id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • action_type — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(30)
  • target_id — BIGINT
  • description — TEXT
  • created_at — DATETIME — NOT NULL

CHAT_MESSAGES

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → CHAT_SESSIONS.id — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • extracted_data — JSON
  • created_at — DATETIME — NOT NULL

CHAT_SESSIONS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id
  • form_id — BIGINT — Foreign key → PLAN_INPUT_FORM.id
  • final_context_message_id — BIGINT — Foreign key → CHAT_MESSAGES.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

CURATIONS

  • id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id
  • title — VARCHAR(200) — NOT NULL
  • theme — VARCHAR(100)
  • display_order — INT — NOT NULL
  • start_at — DATETIME
  • end_at — DATETIME
  • is_default — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

EXPENSES

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • description — VARCHAR(200)
  • amount — BIGINT — NOT NULL
  • is_estimated — TINYINT — NOT NULL
  • expense_date — DATE
  • created_at — DATETIME — NOT NULL

NOTIFICATIONS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • is_read — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

OAUTH_ACCOUNTS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

PASSWORD_RESET_TOKENS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • is_used — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

PLACES

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • address — VARCHAR(300)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • is_indoor — TINYINT — NOT NULL
  • is_no_kids — TINYINT — NOT NULL
  • is_pet_friendly — TINYINT — NOT NULL
  • avg_price — INT
  • external_rating — DECIMAL(3,1)
  • external_link — VARCHAR(500)
  • saved_count — INT
  • created_at — DATETIME — NOT NULL

PLACE_REVIEWS

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → PLACES.id — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • comment — VARCHAR(255)
  • rating — TINYINT

PLACE_SCRAPS

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → PLACES.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

PLACE_TAGS

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → PLACES.id — NOT NULL
  • tag — VARCHAR(50) — NOT NULL

PLAN_INPUT_FORM

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • departure — VARCHAR(100)
  • transport_type — VARCHAR(20)
  • accommodation_type — VARCHAR(50)
  • accommodation_options — VARCHAR(255)
  • companion_type — VARCHAR(20)
  • companion_count — INT
  • travel_styles — VARCHAR(255)
  • dietary_info — VARCHAR(255)
  • has_infant — TINYINT
  • has_pet — TINYINT
  • schedule_density — VARCHAR(20)
  • budget — BIGINT
  • preference_source — VARCHAR(20)
  • loaded_from_plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

PLAN_MEMBERS

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • joined_at — DATETIME — NOT NULL

PLAN_PLACES

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • place_id — BIGINT — Foreign key → PLACES.id — NOT NULL
  • day_number — INT
  • visit_order — INT
  • visit_date — DATE
  • stay_duration — INT
  • created_at — DATETIME — NOT NULL

PLAN_ROUTES

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — 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(20) — NOT NULL
  • distance_km — DECIMAL(10,2)
  • duration_min — INT
  • cost — INT
  • route_order — INT

PLAN_SHARE_LINKS

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • token — VARCHAR(255) — NOT NULL — UNIQUE
  • permission — VARCHAR(10) — NOT NULL
  • expires_at — DATETIME
  • created_at — DATETIME — NOT NULL

POPULAR_PLANS_SNAPSHOT

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id — NOT NULL
  • rank — INT — NOT NULL
  • score — INT — NOT NULL
  • snapshot_at — DATETIME — NOT NULL

POSTS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • style_tags — VARCHAR(255)
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • is_public — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

POST_COMMENTS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • update_at — DATETIME — NOT NULL

POST_IMAGES

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • s3_object_key — VARCHAR(500) — NOT NULL
  • image_order — INT
  • created_at — DATETIME — NOT NULL

POST_LIKES

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • created_at — DATETIME — NOT NULL

POST_SCRAPS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

REFRESH_TOKENS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

REPORTS

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → POSTS.id — NOT NULL
  • reporter_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • reason — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • admin_note — TEXT
  • processed_at — DATETIME
  • created_at — DATETIME — NOT NULL

TRAVEL_PLANS

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • form_id — BIGINT — Foreign key → PLAN_INPUT_FORM.id
  • title — VARCHAR(200)
  • destination — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • is_public — TINYINT — NOT NULL
  • scraped_from_plan_id — BIGINT — Foreign key → TRAVEL_PLANS.id
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • route_recalc_needed — TINYINT — NOT NULL

USERS

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • gender — VARCHAR(1)
  • mbti — VARCHAR(4)
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • login_fail_count — INT — NOT NULL
  • locked_until — DATETIME
  • last_pw_changed_at — DATETIME
  • pw_change_noti_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

USER_SECURITY_HISTORY

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • event_type — VARCHAR(30) — NOT NULL
  • description — VARCHAR(200)
  • created_at — DATETIME — NOT NULL