| from sqlalchemy import Column, Integer, String, Float, DateTime, Text | |
| from app.database import Base | |
| from datetime import datetime | |
| class AnalysisHistoryModel(Base): | |
| __tablename__ = "analysis_history" | |
| id = Column(Integer, primary_key=True, index=True) | |
| tender_code = Column(String(50), index=True) | |
| tender_name = Column(String(255)) | |
| decision = Column(String(50)) | |
| score = Column(Integer) | |
| summary = Column(Text) | |
| risks = Column(Text) # JSON string | |
| technical_analysis = Column(Text) | |
| legal_analysis = Column(Text) | |
| commercial_analysis = Column(Text) | |
| proposal_draft = Column(Text) | |
| report_markdown = Column(Text) | |
| created_at = Column(DateTime, default=datetime.utcnow) | |