TalkQQuest2
Tables (42)
Admin_Users
- id — CHAR(36) — Primary key — NOT NULL
- granted_by — CHAR(36)
- created_at — DATETIME(3) — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
Archive_Folders
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Archive_Items
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- folder_id — CHAR(36) — Foreign key → Archive_Folders.id
- item_type — ENUM('conversation','phrase','report','mission','weekly_compare') — NOT NULL
- reference_id — CHAR(36) — NOT NULL
- tags — JSON
- created_at — DATETIME(3) — NOT NULL
Auth_Identities
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- provider — ENUM('email','kakao','naver') — NOT NULL
- provider_user_id — VARCHAR(255)
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Badges
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- condition — JSON — NOT NULL
- icon_url — VARCHAR(500)
Blocked_Users
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- blocked_user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Calendar_Events
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- community_id — CHAR(36) — Foreign key → Communities.id
- title — VARCHAR(255) — NOT NULL
- started_at — TIMESTAMP(0) — NOT NULL
- ended_at — TIMESTAMP(0)
- created_at — TIMESTAMP(0) — NOT NULL
Chat_Messages
- id — CHAR(36) — Primary key — NOT NULL
- community_id — CHAR(36) — Foreign key → Communities.id — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id
- content — TEXT — NOT NULL
- type — ENUM('text','system') — NOT NULL
- created_at — TIMESTAMP(0) — NOT NULL
Communities
- id — CHAR(36) — Primary key — NOT NULL
- host_user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- category — VARCHAR(100)
- region — VARCHAR(100)
- address — VARCHAR(255)
- capacity — INT — NOT NULL
- current_members — INT — NOT NULL
- started_at — TIMESTAMP(0)
- ended_at — TIMESTAMP(0)
- cover_image_url — VARCHAR(500)
- tags — JSON
- visibility — ENUM('public','private') — NOT NULL
- status — ENUM('draft','open','closed') — NOT NULL
- interests — JSON
- created_at — TIMESTAMP(0) — NOT NULL
Community_Bookmarks
- id — CHAR(36) — Primary key — NOT NULL
- community_id — CHAR(36) — Foreign key → Communities.id — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- created_at — TIMESTAMP(0) — NOT NULL
Community_Join_Requests
- id — CHAR(36) — Primary key — NOT NULL
- community_id — CHAR(36) — Foreign key → Communities.id — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- status — ENUM('pending','approved','rejected','cancelled','waitlisted') — NOT NULL
- waitlist_order — INT
- message — TEXT
- created_at — TIMESTAMP(0) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Community_Members
- id — CHAR(36) — Primary key — NOT NULL
- community_id — CHAR(36) — Foreign key → Communities.id — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- role — ENUM('host','member') — NOT NULL
- joined_at — TIMESTAMP(0) — NOT NULL
Conversation_Messages
- id — CHAR(36) — Primary key — NOT NULL
- conversation_id — CHAR(36) — Foreign key → Conversations.id — NOT NULL
- role — ENUM('user','guide','system') — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Conversations
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- mode — VARCHAR(50)
- mission_setup_id — CHAR(36) — Foreign key → Mission_Setups.id
- selected_topic — VARCHAR(255)
- persona — VARCHAR(255)
- user_task — VARCHAR(255)
- flow_step — INT — NOT NULL
- status — ENUM('in_progress','completed','abandoned') — NOT NULL
- started_at — DATETIME(3) — NOT NULL
- finished_at — DATETIME(3)
Device_Tokens
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- fcm_token — VARCHAR(500) — NOT NULL
- platform — ENUM('android','ios') — NOT NULL
- last_active_at — DATETIME(3) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Email_Verifications
- id — CHAR(36) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- code — VARCHAR(10) — NOT NULL
- expires_at — DATETIME(3) — NOT NULL
- verified — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Feedbacks
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- conversation_id — CHAR(36) — Foreign key → Conversations.id — NOT NULL
- kindness_score — INT
- initiative_score — INT
- empathy_score — INT
- question_link_score — INT
- metrics — JSON
- mission_summary — JSON
- summary_chips — JSON
- conversation_summary — TEXT
- card_summary — TEXT
- conversation_highlights — JSON
- saved_phrase — TEXT
- status — ENUM('pending','ready','failed') — NOT NULL
- ready_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
Goals
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- goal_type — VARCHAR(50) — NOT NULL
- target — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Login_History
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- device_info — JSON
- ip_address — VARCHAR(45)
- logged_in_at — DATETIME(3) — NOT NULL
Mission_Playbooks
- id — CHAR(36) — Primary key — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- data — JSON — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Mission_Prep_Items
- id — CHAR(36) — Primary key — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- type — ENUM('question','starter','tip') — NOT NULL
- content — TEXT — NOT NULL
- order_index — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Mission_Records
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- conversation_id — CHAR(36) — Foreign key → Conversations.id
- result — ENUM('success','failure','avoidance') — NOT NULL
- memo — TEXT
- duration_minutes — INT
- emotion — VARCHAR(50)
- xp_earned — INT — NOT NULL
- status — ENUM('in_progress','completed') — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- completed_at — DATETIME(3)
Mission_Saves
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Mission_Setups
- id — CHAR(36) — Primary key — NOT NULL
- mission_id — CHAR(36) — Foreign key → Missions.id — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- environment — ENUM('school','workplace','daily_place','community','online') — NOT NULL
- partner_role — ENUM('friend','senior','junior','peer','other') — NOT NULL
- partner_gender — ENUM('male','female') — NOT NULL
- partner_age_group — ENUM('teens','twenties','thirties','forties','fifties','sixties_plus') — NOT NULL
- intimacy_level — TINYINT — NOT NULL
- formality_level — TINYINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Missions
- id — CHAR(36) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- preparation_tip — TEXT
- caution — TEXT
- difficulty — INT — NOT NULL
- estimated_minutes — INT — NOT NULL
- reward_xp — INT — NOT NULL
- category — VARCHAR(100) — NOT NULL
- is_template — BOOLEAN — NOT NULL
- created_by_user_id — CHAR(36) — Foreign key → Users.id
- creator_personality_type — ENUM('introvert','extrovert','ambivert')
- setup_guideline — JSON
- created_at — DATETIME(3) — NOT NULL
Notification_Settings
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- mission_reminder — BOOLEAN — NOT NULL
- mission_reminder_time — VARCHAR(5) — NOT NULL
- community_approved — BOOLEAN — NOT NULL
- report_ready — BOOLEAN — NOT NULL
- marketing — BOOLEAN — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Notifications
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- body — TEXT
- reference_id — CHAR(36)
- reference_type — VARCHAR(50)
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Payments
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- subscription_id — CHAR(36) — Foreign key → Subscriptions.id
- amount — DECIMAL(10, 2) — NOT NULL
- currency — VARCHAR(3) — NOT NULL
- method — VARCHAR(50) — NOT NULL
- status — ENUM('pending','completed','failed','refunded') — NOT NULL
- external_id — VARCHAR(255)
- retry_count — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- completed_at — DATETIME(3)
Plans
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- currency — VARCHAR(3) — NOT NULL
- ai_limit — INT
- feedback_limit — INT
- features — JSON
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Recommendation_Logs
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- source — ENUM('llm','template','fallback') — NOT NULL
- llm_model — VARCHAR(50)
- target_difficulty — INT
- avoided_categories — JSON
- prompt_input — JSON
- raw_response — TEXT
- parse_success — BOOLEAN — NOT NULL
- recommended_mission — JSON
- fallback_reason — VARCHAR(100)
- created_mission_id — CHAR(36) — Foreign key → Missions.id
- refresh_index — INT
- recommended_date — DATE
- created_at — DATETIME(3) — NOT NULL
Refresh_Tokens
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- token — VARCHAR(512) — NOT NULL
- device_info — JSON
- expires_at — DATETIME(3) — NOT NULL
- revoked — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Reports
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- period — VARCHAR(30) — NOT NULL
- conversation_id — CHAR(36) — Foreign key → Conversations.id — NOT NULL
- data — JSON
- created_at — DATETIME(3) — NOT NULL
Saved_Phrases
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- conversation_id — CHAR(36) — Foreign key → Conversations.id
- content — TEXT — NOT NULL
- memo — TEXT
- chips — JSON
- created_at — DATETIME(3) — NOT NULL
Subscriptions
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- plan_id — CHAR(36) — Foreign key → Plans.id — NOT NULL
- status — ENUM('pending','active','expired','cancelled') — NOT NULL
- started_at — DATETIME(3) — NOT NULL
- expires_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
Terms
- id — CHAR(36) — Primary key — NOT NULL
- type — ENUM('terms','privacy') — NOT NULL
- version — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(3) — NOT NULL
Usage
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- cycle_start — DATE — NOT NULL
- ai_count — INT — NOT NULL
- feedback_count — INT — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
User_Badges
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- badge_id — CHAR(36) — Foreign key → Badges.id — NOT NULL
- earned_at — DATETIME(3) — NOT NULL
User_Growth_Profiles
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- summary — TEXT
- strengths — JSON
- improvements — JSON
- struggle_situations — JSON
- metric_averages — JSON
- suggested_difficulty — TINYINT
- reflected_feedback_count — INT — NOT NULL
- last_feedback_id — CHAR(36)
- last_reflected_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
User_Profiles
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- nickname — VARCHAR(50)
- status_type — VARCHAR(50)
- personality_type — ENUM('introvert','extrovert','ambivert')
- difficult_situations — JSON
- preferred_style — VARCHAR(255)
- interests — JSON
- purpose — JSON
- avatar_url — VARCHAR(500)
- bio — TEXT
- daily_conversation_goal — INT — NOT NULL
- level — INT — NOT NULL
- xp — INT — NOT NULL
- onboarding_completed — BOOLEAN — NOT NULL
- onboarding_step — INT — NOT NULL
- onboarding_temp_data — JSON
- created_at — DATETIME(3) — NOT NULL
- updated_at — TIMESTAMP(0) — NOT NULL
Users
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- terms_agreed_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
- last_login_at — DATETIME(3)
- status — ENUM('active','inactive','deleted') — NOT NULL
- deleted_at — DATETIME(3)
Weekly_Compare_Reports
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- week_index — INT — NOT NULL
- data — JSON — NOT NULL
- created_at — DATETIME(3) — NOT NULL
XP_History
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → Users.id — NOT NULL
- amount — INT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- reference_id — CHAR(36)
- reference_type — VARCHAR(50)
- created_at — DATETIME(3) — NOT NULL