🗄️ 数据库设计文档

erDiagram stock_watch ||--o{ stock_watch_alert : "触发预警" stock_analysis ||--o{ stock_analysis_model : "各模型结果" stock_report ||--o{ stock_report_chunk : "PDF分块" stock_news }o--|| stock_news_source : "来源" stock_watch { int id PK int user_id FK string code string name bool is_monitoring decimal alert_price_high decimal alert_price_low } stock_analysis { int id PK int user_id FK string code string analysis_type json dimensions int sentiment_score tinyint status } stock_report { int id PK string title string institution string related_code string file_url tinyint parse_status int parse_progress text ai_summary } stock_brief { int id PK date trade_date int issue_no text full_content json stock_reviews tinyint status }