ㄷㄷㄷㄷ
테이블 (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