멘토스

테이블 (41)

article_ai_summaries

  • id — BIGSERIAL
  • article_id — BIGINT — 외래 키 → news_articles.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id
  • target_level_id — BIGINT — 외래 키 → level_definitions.id
  • pipeline_run_id — BIGINT — 외래 키 → pipeline_runs.id
  • summary_type — VARCHAR(30) — NOT NULL
  • summary_text — TEXT — NOT NULL
  • related_question_text — TEXT
  • created_at — TIMESTAMP — NOT NULL

article_topics

  • article_id — BIGINT — 외래 키 → news_articles.id — NOT NULL
  • topic_id — BIGINT — 외래 키 → interest_topics.id — NOT NULL

auth_identities

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

chat_message_sources

  • id — BIGSERIAL
  • chat_message_id — BIGINT — 외래 키 → chat_messages.id — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • article_id — BIGINT — 외래 키 → news_articles.id
  • indicator_snapshot_id — BIGINT — 외래 키 → market_indicator_snapshots.id
  • knowledge_chunk_id — BIGINT — 외래 키 → knowledge_chunks.id
  • report_section_id — BIGINT — 외래 키 → report_sections.id
  • citation_text — TEXT

chat_messages

  • id — BIGSERIAL
  • session_id — BIGINT — 외래 키 → chat_sessions.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id
  • level_id — BIGINT — 외래 키 → level_definitions.id
  • sender_type — VARCHAR(20) — NOT NULL
  • message_type — VARCHAR(20) — NOT NULL
  • content_text — TEXT — NOT NULL
  • prompt_tokens — INTEGER
  • completion_tokens — INTEGER
  • created_at — TIMESTAMP — NOT NULL

chat_sessions

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • title — VARCHAR(255)
  • session_status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • last_message_at — TIMESTAMP

daily_reports

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • level_id — BIGINT — 외래 키 → level_definitions.id — NOT NULL
  • pipeline_run_id — BIGINT — 외래 키 → pipeline_runs.id
  • report_date — DATE — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • summary_text — TEXT
  • outlook_text — TEXT
  • learning_question_text — TEXT
  • status — VARCHAR(20) — NOT NULL
  • generated_at — TIMESTAMP — NOT NULL
  • delivered_at — TIMESTAMP

debate_sessions

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_a_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • mentor_b_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • user_level_id — BIGINT — 외래 키 → level_definitions.id — NOT NULL
  • topic_title — VARCHAR(255) — NOT NULL
  • issue_description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • reflection_question — TEXT
  • started_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

debate_sources

  • id — BIGSERIAL
  • debate_turn_id — BIGINT — 외래 키 → debate_turns.id — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • article_id — BIGINT — 외래 키 → news_articles.id
  • indicator_snapshot_id — BIGINT — 외래 키 → market_indicator_snapshots.id
  • knowledge_chunk_id — BIGINT — 외래 키 → knowledge_chunks.id
  • citation_text — TEXT

debate_turns

  • id — BIGSERIAL
  • debate_session_id — BIGINT — 외래 키 → debate_sessions.id — NOT NULL
  • speaker_mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • turn_no — INTEGER — NOT NULL
  • turn_type — VARCHAR(30) — NOT NULL
  • content_text — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

interest_topics

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL

investment_strategies

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • principle_summary — TEXT
  • risk_profile_tag — VARCHAR(30)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

knowledge_chunks

  • id — BIGSERIAL
  • document_id — BIGINT — 외래 키 → knowledge_documents.id — NOT NULL
  • chunk_index — INTEGER — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • token_count — INTEGER
  • vector_store_ref — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

knowledge_documents

  • id — BIGSERIAL
  • document_type — VARCHAR(30) — NOT NULL
  • source_article_id — BIGINT — 외래 키 → news_articles.id
  • pipeline_run_id — BIGINT — 외래 키 → pipeline_runs.id
  • title — VARCHAR(500) — NOT NULL
  • body_text — TEXT — NOT NULL
  • source_url — VARCHAR(1000)
  • published_at — TIMESTAMP
  • status — VARCHAR(20) — NOT NULL
  • last_embedded_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

learning_modules

  • id — BIGSERIAL
  • strategy_id — BIGINT — 외래 키 → investment_strategies.id — NOT NULL
  • level_id — BIGINT — 외래 키 → level_definitions.id — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • concept_summary — TEXT
  • quiz_question — TEXT
  • quiz_answer_text — TEXT
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

level_definitions

  • id — BIGSERIAL
  • level_no — INTEGER — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • min_xp — INTEGER — NOT NULL
  • unlock_summary — TEXT
  • created_at — TIMESTAMP — NOT NULL

market_indicator_snapshots

  • id — BIGSERIAL
  • indicator_id — BIGINT — 외래 키 → market_indicators.id — NOT NULL
  • pipeline_run_id — BIGINT — 외래 키 → pipeline_runs.id
  • observed_at — TIMESTAMP — NOT NULL
  • period_label — VARCHAR(30) — NOT NULL
  • numeric_value — NUMERIC(20,6)
  • value_text — VARCHAR(255)
  • change_rate — NUMERIC(10,4)
  • raw_payload — TEXT
  • created_at — TIMESTAMP — NOT NULL

market_indicators

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • unit — VARCHAR(30)
  • source_name — VARCHAR(100)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

mentor_focus_topics

  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • topic_id — BIGINT — 외래 키 → interest_topics.id — NOT NULL

mentor_recommendation_items

  • id — BIGSERIAL
  • recommendation_id — BIGINT — 외래 키 → mentor_recommendations.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • rank_no — INTEGER — NOT NULL
  • score — NUMERIC(5,2)
  • reason_text — TEXT

mentor_recommendations

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • primary_mentor_id — BIGINT — 외래 키 → mentors.id
  • reason_summary — TEXT
  • created_at — TIMESTAMP — NOT NULL

mentors

  • id — BIGSERIAL
  • strategy_id — BIGINT — 외래 키 → investment_strategies.id — NOT NULL
  • unlock_level_id — BIGINT — 외래 키 → level_definitions.id
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • one_liner — VARCHAR(255)
  • philosophy — TEXT
  • speaking_style — TEXT
  • prompt_template — TEXT
  • is_free — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

news_articles

  • id — BIGSERIAL
  • source_id — BIGINT — 외래 키 → news_sources.id — NOT NULL
  • pipeline_run_id — BIGINT — 외래 키 → pipeline_runs.id
  • external_id — VARCHAR(255)
  • title — VARCHAR(500) — NOT NULL
  • summary — TEXT
  • content_text — TEXT
  • original_url — VARCHAR(1000) — NOT NULL
  • publisher — VARCHAR(100)
  • author_name — VARCHAR(100)
  • thumbnail_url — VARCHAR(1000)
  • published_at — TIMESTAMP
  • collected_at — TIMESTAMP — NOT NULL
  • raw_payload — TEXT
  • status — VARCHAR(20) — NOT NULL

news_sources

  • id — BIGSERIAL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • base_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notifications

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • notification_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • related_type — VARCHAR(30)
  • related_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • sent_at — TIMESTAMP
  • read_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

onboarding_survey_answers

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • question_code — VARCHAR(50) — NOT NULL
  • question_text — VARCHAR(255)
  • answer_value — TEXT
  • answer_payload — TEXT
  • answered_at — TIMESTAMP — NOT NULL

pipeline_runs

  • id — BIGSERIAL
  • run_type — VARCHAR(50) — NOT NULL
  • source_name — VARCHAR(100)
  • status — VARCHAR(30) — NOT NULL
  • requested_by_user_id — BIGINT — 외래 키 → users.id
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • fetched_count — INTEGER — NOT NULL
  • saved_count — INTEGER — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

quest_templates

  • id — BIGSERIAL
  • required_level_id — BIGINT — 외래 키 → level_definitions.id
  • code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • quest_type — VARCHAR(20) — NOT NULL
  • action_type — VARCHAR(30) — NOT NULL
  • target_count — INTEGER — NOT NULL
  • xp_reward — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

report_sections

  • id — BIGSERIAL
  • report_id — BIGINT — 외래 키 → daily_reports.id — NOT NULL
  • section_type — VARCHAR(30) — NOT NULL
  • heading — VARCHAR(255)
  • content_text — TEXT — NOT NULL
  • display_order — INTEGER — NOT NULL

report_sources

  • id — BIGSERIAL
  • report_section_id — BIGINT — 외래 키 → report_sections.id — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • article_id — BIGINT — 외래 키 → news_articles.id
  • indicator_snapshot_id — BIGINT — 외래 키 → market_indicator_snapshots.id
  • knowledge_chunk_id — BIGINT — 외래 키 → knowledge_chunks.id
  • citation_text — TEXT

scrap_folders

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • is_system_generated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

scraps

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • folder_id — BIGINT — 외래 키 → scrap_folders.id
  • article_id — BIGINT — 외래 키 → news_articles.id
  • chat_message_id — BIGINT — 외래 키 → chat_messages.id
  • debate_session_id — BIGINT — 외래 키 → debate_sessions.id
  • report_id — BIGINT — 외래 키 → daily_reports.id
  • memo_text — TEXT
  • created_at — TIMESTAMP — NOT NULL

user_device_tokens

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • platform — VARCHAR(20) — NOT NULL
  • device_token — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_interest_topics

  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • topic_id — BIGINT — 외래 키 → interest_topics.id — NOT NULL

user_learning_progress

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • module_id — BIGINT — 외래 키 → learning_modules.id — NOT NULL
  • familiarity_choice — VARCHAR(30)
  • quiz_attempts — INTEGER — NOT NULL
  • is_mastered — BOOLEAN — NOT NULL
  • mastered_at — TIMESTAMP
  • completed_at — TIMESTAMP

user_mentor_selections

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • selection_reason — VARCHAR(30) — NOT NULL
  • selected_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP

user_mentor_unlocks

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • mentor_id — BIGINT — 외래 키 → mentors.id — NOT NULL
  • unlock_method — VARCHAR(30) — NOT NULL
  • unlocked_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP

user_profiles

  • user_id — BIGINT — 외래 키 → users.id
  • current_level_id — BIGINT — 외래 키 → level_definitions.id — NOT NULL
  • current_mentor_id — BIGINT — 외래 키 → mentors.id
  • age_band — VARCHAR(30)
  • has_investment_experience — BOOLEAN — NOT NULL
  • investment_experience_months — INTEGER
  • holdings_summary — TEXT
  • investment_amount_band — VARCHAR(50)
  • investment_purpose — VARCHAR(100)
  • risk_tolerance — VARCHAR(30)
  • learning_stage — VARCHAR(30) — NOT NULL
  • total_xp — INTEGER — NOT NULL
  • onboarding_completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_quests

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • quest_template_id — BIGINT — 외래 키 → quest_templates.id — NOT NULL
  • assigned_date — DATE — NOT NULL
  • due_date — DATE
  • current_count — INTEGER — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • completed_at — TIMESTAMP
  • rewarded_xp — INTEGER — NOT NULL

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

xp_transactions

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • amount — INTEGER — NOT NULL
  • reason_type — VARCHAR(30) — NOT NULL
  • reason_detail — VARCHAR(255)
  • reference_type — VARCHAR(30)
  • reference_id — BIGINT
  • occurred_at — TIMESTAMP — NOT NULL