ㄷㄷㄷㄷ

테이블 (7)

사용자 (User)

  • user_id — INT
  • name — VARCHAR(100)
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • risk_profile — VARCHAR(50)
  • investment_goal — TEXT

시장정보 (MarketInfo)

  • info_id — INT
  • asset_id — INT
  • info_type — VARCHAR(50)
  • content — TEXT
  • published_at — DATETIME

알림 (Alert)

  • alert_id — INT
  • user_id — INT
  • alert_type — VARCHAR(50)
  • message — TEXT
  • created_at — DATETIME

자산 (Asset)

  • asset_id — INT
  • asset_name — VARCHAR(100)
  • asset_type — VARCHAR(50)
  • current_price — DECIMAL(18,2)
  • risk_level — VARCHAR(50)

전략 추천 (StrategyRecommendation)

  • strategy_id — INT
  • user_id — INT
  • risk_profile — VARCHAR(50)
  • suggested_assets — TEXT
  • created_at — DATETIME
  • strategy_note — TEXT

투자내역 (Investment)

  • investment_id — INT
  • portfolio_id — INT
  • asset_id — INT
  • amount_invested — DECIMAL(18,2)
  • invested_at — DATETIME

포트폴리오 (Portfolio)

  • portfolio_id — INT
  • user_id — INT
  • total_value — DECIMAL(18,2)
  • created_at — DATETIME
  • updated_at — DATETIME