멘토스
테이블 (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