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