travle_team
Tables (16)
ADMINS
- admin_id — BIGINT
- user_id — BIGINT — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
AI_LOG
- id — BIGINT
- user_id — BIGINT — NOT NULL
- request_type — VARCHAR(50)
- input_text — TEXT
- output_text — TEXT
- recommended_place — BIGINT
- reason — TEXT
- created_at — TIMESTAMP
CHATBOT
- id — BIGINT
- user_id — BIGINT
- session_id — VARCHAR(100)
- sender — VARCHAR(10)
- message — TEXT
- bot_persona — VARCHAR(50)
- nickname — VARCHAR(100)
- created_at — TIMESTAMP
COMMENTS
- comment_id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- image_url — VARCHAR(500)
FAVORITES
- favorite_id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT
- comment_id — BIGINT
- map_location — VARCHAR(255)
- created_at — TIMESTAMP
FRIENDS
- friend_id — BIGINT
- requester_id — BIGINT — NOT NULL
- receiver_id — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
LIKES
- like_id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT
- comment_id — BIGINT
- review_id — BIGINT
- created_at — TIMESTAMP
LOGIN_LOG
- log_id — BIGINT
- user_id — BIGINT — NOT NULL
- login_time — TIMESTAMP
- ip_address — VARCHAR(100)
- device_info — VARCHAR(255)
- login_success — BOOLEAN
NOTICE
- notice_id — BIGINT
- admin_id — BIGINT — NOT NULL
- is_fixed — BOOLEAN
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- file_url — VARCHAR(500)
- category — VARCHAR(50)
PLACES
- id — BIGINT
- region — VARCHAR(100)
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(50)
- address — VARCHAR(255)
- lat — DOUBLE
- lng — DOUBLE
- description — TEXT
- image_url — VARCHAR(500)
- rating — DECIMAL(2,1)
- created_at — TIMESTAMP
POSTS
- post_id — BIGINT
- user_id — BIGINT — NOT NULL
- category — VARCHAR(50)
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- views — INT
- image_url — VARCHAR(1000)
- video_url — VARCHAR(500)
- youtube_url — VARCHAR(500)
- map_location — VARCHAR(255)
- tags — VARCHAR(255)
REPORT_COMMENT
- report_id — BIGINT
- comment_id — BIGINT — NOT NULL
- reporter_id — BIGINT — NOT NULL
- target_user_id — BIGINT — NOT NULL
- reason — VARCHAR(255)
- created_at — TIMESTAMP
- status — VARCHAR(20)
- admin_id — BIGINT
- processed_at — TIMESTAMP
REPORT_POST
- report_id — BIGINT
- post_id — BIGINT — NOT NULL
- reporter_id — BIGINT — NOT NULL
- target_user_id — BIGINT — NOT NULL
- reason — VARCHAR(255)
- created_at — TIMESTAMP
- status — VARCHAR(20)
- admin_id — BIGINT
- processed_at — TIMESTAMP
SCHEDULE
- id — BIGINT
- user_id — BIGINT — NOT NULL
- schedule_title — VARCHAR(255) — NOT NULL
- region — VARCHAR(100)
- date — DATE
- time — VARCHAR(50)
- place_name — VARCHAR(255)
- address — VARCHAR(255)
- transportation — VARCHAR(50)
- cost — DECIMAL(10,2)
- memo — TEXT
- lodging_name — VARCHAR(255)
- lodging_checkin — TIMESTAMP
- lodging_checkout — TIMESTAMP
- created_at — TIMESTAMP
USERS
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(500)
- phone — VARCHAR(50)
- birth_year — INT
- gender — VARCHAR(10)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(20)
USER_DATA
- id — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(100)
- nickname — VARCHAR(100)
- phone — VARCHAR(50)
- profile_image — VARCHAR(500)
- notification — VARCHAR(20)
- theme — VARCHAR(20)
- language — VARCHAR(20)
- total_trips — INT
- visited_regions — TEXT
- created_at — TIMESTAMP
- schedule_list — TEXT