traping
Tables (10)
ADMINS
- admin_id — INT — Primary key
- role — ENUM('super', 'manager', 'cs') — NOT NULL
- created_at — DATETIME
AI_LOG
- id — INT
- user_id — INT
- request_type — VARCHAR(100)
- input_text — TEXT
- output_text — TEXT
- recommended_place — VARCHAR(255)
- reason — TEXT
- created_at — DATETIME
CHATBOT
- id — INT — Primary key
- user_id — INT
- session_id — VARCHAR(100)
- sender — ENUM('user', 'ai')
- message — TEXT
- bot_persona — VARCHAR(100)
- nickname — VARCHAR(100)
- created_at — DATETIME
COMMENTS
- comment_id — INT — Primary key
- user_id — INT
- post_id — INT
- parent_comment_id — INT
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- image_url — VARCHAR(500)
LIKES
- like_id — INT — Primary key
- user_id — INT
- post_id — INT
- comment_id — INT
- review_id — INT
- created_at — DATETIME
NOTICE
- notice_id — INT — Primary key
- admin_id — INT
- is_fixed — BOOLEAN
- title — VARCHAR(255)
- content — TEXT
- view_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- file_url — VARCHAR(500)
- category — VARCHAR(100)
PLACES
- id — INT — Primary key
- region — VARCHAR(100)
- name — VARCHAR(255)
- category — VARCHAR(100)
- address — VARCHAR(500)
- lat — DOUBLE
- lng — DOUBLE
- description — TEXT
- image_url — VARCHAR(500)
- rating — DECIMAL(3,2)
- created_at — DATETIME
POSTS
- post_id — INT — Primary key
- user_id — INT
- category — VARCHAR(100)
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- views — INT
- image_url — TEXT
- video_url — TEXT
- youtube_url — VARCHAR(500)
- map_location — VARCHAR(255)
- tags — VARCHAR(255)
REPORT_COMMENT
- report_id — INT — Primary key
- comment_id — INT
- reporter_id — INT
- target_user_id — INT
- reason — TEXT
- created_at — DATETIME
- status — VARCHAR(50)
- admin_id — INT
- processed_at — DATETIME
SCHEDULE
- id — INT — Primary key
- user_id — INT
- schedule_title — VARCHAR(255)
- region — VARCHAR(100)
- date — DATE
- time — TIME
- place_name — VARCHAR(255)
- address — VARCHAR(500)
- transportation — VARCHAR(100)
- cost — INT
- memo — TEXT
- lodging_name — VARCHAR(255)
- lodging_checkin — DATE
- lodging_checkout — DATE
- created_at — DATETIME