TripMate
Tables (15)
accommodation_info
- accommodation_id — INT
- plan_id — INT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- address — VARCHAR(300)
- city — VARCHAR(100)
- check_in_date — DATE
- check_out_date — DATE
- room_type — VARCHAR(100)
- price_per_night — DECIMAL(10, 2)
- total_price — DECIMAL(10, 2)
- rating — DECIMAL(2, 1)
- booking_url — VARCHAR(500)
- amenities — TEXT
- notes — TEXT
- is_selected — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_plan_id
ai_recommendations
- recommendation_id — INT
- plan_id — INT — NOT NULL
- recommendation_type — ENUM('flight', 'accommodation', 'destination') — NOT NULL
- prompt — TEXT
- response — TEXT
- created_at — TIMESTAMP
- INDEX — idx_plan_id
board_comments
- comment_id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- parent_comment_id — INT — 대댓글인 경우 부모 댓글 ID
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_post_id
- INDEX — idx_user_id
- INDEX — idx_parent_comment — parent_comment_id
board_posts
- post_id — INT
- plan_id — INT — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- thumbnail_url — VARCHAR(255)
- view_count — INT
- like_count — INT
- comment_count — INT
- is_featured — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
- INDEX — idx_created_at
- INDEX — idx_view_count
- INDEX — idx_like_count
bookmarks
- bookmark_id — INT
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_user_id
destinations
- destination_id — INT
- plan_id — INT — NOT NULL
- name — VARCHAR(200) — NOT NULL
- category — VARCHAR(50)
- address — VARCHAR(300)
- city — VARCHAR(100)
- visit_date — DATE
- visit_time — TIME
- duration — INT — 방문 예상 시간 (분)
- entry_fee — DECIMAL(10, 2)
- rating — DECIMAL(2, 1)
- description — TEXT
- website_url — VARCHAR(500)
- latitude — DECIMAL(10, 8)
- longitude — DECIMAL(11, 8)
- notes — TEXT
- is_selected — BOOLEAN
- display_order — INT
- created_at — TIMESTAMP
- INDEX — idx_plan_id
- INDEX — idx_visit_date
flight_info
- flight_id — INT
- plan_id — INT — NOT NULL
- airline — VARCHAR(100)
- flight_number — VARCHAR(20)
- departure_airport — VARCHAR(100)
- arrival_airport — VARCHAR(100)
- departure_time — DATETIME
- arrival_time — DATETIME
- price — DECIMAL(10, 2)
- booking_url — VARCHAR(500)
- seat_class — VARCHAR(50)
- notes — TEXT
- is_selected — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_plan_id
password_reset_tokens
- token_id — INT
- user_id — INT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- used — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_token
post_likes
- like_id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_post_id
- INDEX — idx_user_id
record_images
- image_id — INT
- record_id — INT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- caption — TEXT
- display_order — INT
- uploaded_at — TIMESTAMP
- INDEX — idx_record_id
templates
- template_id — INT
- template_name — VARCHAR(100) — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- thumbnail_url — VARCHAR(255)
- is_default — BOOLEAN
- created_at — TIMESTAMP
- usage_count — INT
- INDEX — idx_category
travel_plans
- plan_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- departure_city — VARCHAR(100)
- arrival_city — VARCHAR(100)
- departure_date — DATE
- arrival_date — DATE
- adult_count — INT
- child_count — INT
- is_template — BOOLEAN
- is_public — BOOLEAN
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
- INDEX — idx_is_public
- INDEX — idx_created_at
travel_records
- record_id — INT
- plan_id — INT — NOT NULL
- record_date — DATE — NOT NULL
- record_time — TIME
- title — VARCHAR(200)
- content — TEXT
- location — VARCHAR(200)
- weather — VARCHAR(50)
- mood — VARCHAR(50)
- expense — DECIMAL(10, 2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_plan_id
- INDEX — idx_record_date
user_sessions
- session_id — VARCHAR(255)
- user_id — INT — NOT NULL
- ip_address — VARCHAR(45)
- user_agent — VARCHAR(500)
- created_at — TIMESTAMP
- expires_at — TIMESTAMP — NOT NULL
- INDEX — idx_user_id
- INDEX — idx_expires_at
users
- user_id — INT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- last_login — TIMESTAMP
- status — ENUM('active', 'inactive', 'suspended')
- INDEX — idx_email