test

Tables (11)

investment_journal

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • journal_date — DATE — NOT NULL
  • emotion — VARCHAR(50) — NOT NULL
  • reason — TEXT — NOT NULL
  • mistake — TEXT — NOT NULL
  • created_at — DATETIME

journal_feedback

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • week_start — DATE — NOT NULL
  • week_end — DATE — NOT NULL
  • summary_text — TEXT
  • strength — TEXT
  • improvements — TEXT
  • next_week_tip — TEXT
  • generated_by — VARCHAR(50)
  • generated_at — DATETIME

learning_contents

  • content_id — BIGINT
  • type — ENUM('VIDEO', 'TEXT', 'CARD') — NOT NULL
  • title — VARCHAR(25) — NOT NULL
  • body — TEXT
  • credit_reward — INT — NOT NULL
  • created_at — DATE — NOT NULL

learning_contents_tags

  • content_id — BIGINT — Primary key — NOT NULL
  • profile_tag — VARCHAR(50) — Primary key — NOT NULL

learning_quiz

  • quiz_id — BIGINT
  • content_id — BIGINT — NOT NULL
  • question — TEXT — NOT NULL
  • options — TEXT — NOT NULL
  • answer — INT — NOT NULL

user

  • id — BIGINT
  • user_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • risk_type — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(100)
  • email — VARCHAR(100)
  • provider — VARCHAR(100)

user_credit

  • user_id — BIGINT
  • total_credit — INT — NOT NULL
  • updated_at — DATE — NOT NULL

user_investment_profile_history

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • risk_type — VARCHAR(50) — NOT NULL
  • diagnosed_at — DATE — NOT NULL

user_investment_profiles

  • user_id — BIGINT
  • risk_type — ENUM('CONSERVATIVE', 'MODERATE', 'AGGRESSIVE') — NOT NULL
  • interest_sector — VARCHAR(50) — NOT NULL
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

user_quiz_results

  • user_id — BIGINT — Primary key — NOT NULL
  • quiz_id — BIGINT — Primary key — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • credit_earned — INT — NOT NULL
  • attempted_at — DATE — NOT NULL

user_setting

  • user_id — BIGINT
  • push_notify — BOOLEAN
  • is_active — BOOLEAN
  • updated_at — DATETIME