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